0%

Book Description

Professional-level coverage and techniques for Excel power users

Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.

  • Demonstrates how to crunch and analyze Excel data the way the professionals do in an uncluttered, visual style

  • Offers a clear look at power-using the new Excel 2013, the latest version of the world's leading spreadsheet application from Microsoft

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

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

  • Explores all features and functions in two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks

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

Learn the full power of Excel 2013 with this helpful guide!

Table of Contents

  1. Cover
  2. Title Page
  3. Table of Contents
  4. Chapter 1: Building Formulas for Data Analysis
  5. Chapter 2: Troubleshooting Formulas
  6. Chapter 3: Enhancing Formulas with Functions
  7. Chapter 4: Analyzing Financial Data
  8. Chapter 5: Analyzing Statistical Data
  9. Chapter 6: Building Tables for Data Analysis
  10. Chapter 7: Sorting and Filtering Data
  11. Chapter 8: Learning Data Analysis Techniques
  12. Chapter 9: Working with Data Analysis Tools
  13. Chapter 10: Tracking Trends and Making Forecasts
  14. Chapter 11: Working with the Analysis ToolPak
  15. Chapter 12: Analyzing Data with PivotTables
  16. Chapter 13: Visualizing Data with Charts
  17. Chapter 14: Importing Data into Excel
  18. Chapter 15: Querying Data Sources
  19. Chapter 16: Learning VBA for Data Analysis
  20. Appendix: Using Excel Keyboard Shortcuts
18.191.223.123