In today’s world, we are all presented with huge amounts of data. It can be an overwhelming task to try to analyze the data to get some meaningful information. These built-in tools in Excel can help you analyze your data and get the results that you need.

Topics:
Tracing Formulas
Using the Scenario Manager
Goal Seek
Solver
Data Tables
The Solver Add-in
Data Analysis Tools
Forecast Sheet
Sumif, Countif,Averageif, Sumifs, and Countifs formulas
If, And, Or, and Nested If formulas