Excel data analysis by examples

Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office—the number-one productivity suite—and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format.


* Table of Contents:


Chapter 1. Sort

Chapter 2. Filter

Chapter 3. Conditonal Formatting

Chapter 4. Charts

Chapter 5. Pivot Tables

Chapter 6. Tables

Chapter 7. What-If Analysis

Chapter 8. Solver

Chapter 9. Analysis ToolPak


+ Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft


+ Expands your Excel knowledge and helps you use Excel data more efficiently


+ Demonstrates how to retrieve data from databases; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas


Includes practical examples, tips to help you get the most out of Excel's features and functions