Excel Data Analysis Tools



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.

Tracing Formulas
Using the Scenario Manager
Goal Seek
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