Excel data analysis by examples by Thanh Tran

Excel data analysis by examples

By

  • Genre Computers
  • Publisher Oxford University Press
  • Released
  • Size 5.73 MB
  • Length 217 Pages

Description

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

More Thanh Tran Books