As you can customize the Ribbon and the Quick Access Toolbar of excel Application, you can also customize the Gridlines of Excel Worksheet by changing its color. Follow these simple and easy steps to change the color of Gridlines in … Continue reading
A drop down list allows you to enter data into an Excel from a list of data. This makes the data entry easier. When a drop down list is created, an arrow next to the cell is displayed .You can … Continue reading
The real power in Excel comes in its ability to perform multiple mathematical calculations for you. One of the tools in Excel that you can use to perform these calculations is a Data tool called What-If Analysis. What-If analysis allows you to see … Continue reading
PivotTable reports (or, simply PivotTables) make the data in your worksheets much more manageable by summarizing the data and allowing you tomanipulate it in different ways. PivotTables can be an indispensable tool when used with large, complex spreadsheets, but they can be used with smaller … Continue reading
Imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of … Continue reading
Sparklines are miniature charts that fit into a single cell. Since they’re so compact, you can place a large number of them in your worksheets. For example, you could place one sparkline on each row to show trends within that row. In … Continue reading
A chart is a tool you can use in Excel to communicate your data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends a lot easier. In this lesson, you will learn how to insert charts and modify them so that they … Continue reading
In Excel 2010, you have many templates that can save you a lot of time. A template is a pre-designed spreadsheet that you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don’t need to know … Continue reading
Suppose someone asked you to proofread or collaborate on a worksheet they put together. If you had a hard copy, you might use a red pen to cross out cell data, mark misspellings, or add comments in the margins. However, … Continue reading
Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel, but also make it easier to use. In a previous lesson, we discussed many manual … Continue reading