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
- Cover
- Title Page
- Table of Contents
- Chapter 1: Building Formulas for Data Analysis
- Chapter 2: Troubleshooting Formulas
- Chapter 3: Enhancing Formulas with Functions
- Chapter 4: Analyzing Financial Data
- Chapter 5: Analyzing Statistical Data
- Chapter 6: Building Tables for Data Analysis
- Chapter 7: Sorting and Filtering Data
- Chapter 8: Learning Data Analysis Techniques
- Chapter 9: Working with Data Analysis Tools
- Chapter 10: Tracking Trends and Making Forecasts
- Chapter 11: Working with the Analysis ToolPak
- Chapter 12: Analyzing Data with PivotTables
- Chapter 13: Visualizing Data with Charts
- Chapter 14: Importing Data into Excel
- Chapter 15: Querying Data Sources
- Chapter 16: Learning VBA for Data Analysis
- Appendix: Using Excel Keyboard Shortcuts
Product information
- Title: Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition
- Author(s):
- Release date: July 2013
- Publisher(s): Visual
- ISBN: 9781118517147
You might also like
book
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can …
book
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Prepare for Microsoft Exam 70-779 and help demonstrate your real-world mastery of Microsoft Excel data analysis …
book
Microsoft® Excel Data Analysis and Business Modeling
Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to …
book
Excel Data Analysis For Dummies
Want to take the guesswork out of analyzing data? Let Excel do all the work for …