This section illustrates the powerful features Excel has to offer to analyze data.
1 Sort: You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.
2 Filter: Filter your Excel data if you only want to display records that meet certain criteria.
3 Conditonal Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
4 Charts: A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
5 Pivot Tables: Pivot tables are the most powerful feature in Excel. A pivot table will allow you to extract the significance from a large, detailed data set.
6 Tables: Tables (or lists in Excel 2003) allow you to analyze your data quickly and easily.
7 What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily.
8 Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
9 Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.