Excel data analysis by examples
Excel data analysis for complete beginners, Step-By-Step Illustrated Guide to Mastering Excel data analysis
by Thanh X.Tran
series 1 #1
Synopsis
Expand/Collapse Synopsis
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.
