Category Archives: Excel
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 excel Worksheet. 1) Open the Excel Worksheet; then click on the “Office” button and then […]
“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 enter the Data in the cell by selecting the data in the drop down list.” […]
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 the effect that different values have in formulas. Have you ever thought, “What interest rate […]
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 spreadsheets as well. In this lesson, you will learn the basics of creating and manipulatingPivotTables.
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 these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more […]
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 this lesson, you will learn how to insert sparklines and change their typeand appearance.
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 communicate information effectively.
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 how to do the math, or even how to write formulas – these are already […]
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, you could also do all of these things in Excel using the Track Changes and Commentsfeatures. When you’ve […]
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 formatting options such as bold and italics. In this lesson, you will learn how toformat […]