by Oluwaseun | Aug 21, 2019 | Articles and Short Tutorials, Microsoft Powerpoint Articles
One can change the borders and shading for most of the content in PowerPoint 2010. Let’s see how it is done Applying Borders The following are the steps that will help you apply borders in your presentation. Step 1 − Select the object (text box, image, chart, picture,...
by Oluwaseun | Aug 20, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Using Styles in MS Excel With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent. A Style can consist of settings for up to six...
by Oluwaseun | Aug 20, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Data Validation MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry,...
by Oluwaseun | Aug 20, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Ranges in MS Excel A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is the cell in the second column and the first...
by Oluwaseun | Aug 20, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Sorting in MS Excel Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest....
by Oluwaseun | Aug 20, 2019 | Articles and Short Tutorials, Microsoft Excel Articles
Filters in MS Excel Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this. Follow...