Data Analysis

A simple chart in Excel can say more than a sheet full of numbers. As you’ll see, creating charts is very easy.

Filter your Excel data if you only want to display records that meet certain criteria. Click any single cell inside a data set. On the Data tab, in the Sort & Filter group, click Filter.

Pivot tables are one of Excel’s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.

You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.

Master Excel tables and analyze your data quickly and easily. Learn how to insert, sort and filter a table, and how to display a total row at the end of a table.

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.

Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. For example, highlight all odd numbers.

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.