Excel Data Analysis For Dummies, 4th Edition

Take Excel to the next level

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.

Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions.

• Work with external databases, PivotTables, and Pivot Charts
• Use Excel for statistical and financial functions and data sharing
• Get familiar with Solver
• Use the Small Business Finance Manager

If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

Table of Contents

Part 1: Getting Started with Data Analysis
Chapter 1: Learning Basic Data-Analysis Techniques
Chapter 2: Working with Data-Analysis Tools
Chapter 3: Introducing Excel Tables
Chapter 4: Grabbing Data from External Sources
Chapter 5: Scrub-a-Dub-Dub: Cleaning Data
Chapter 6: Analyzing Table Data with Functions

Part 2: Analyzing Data with PivotTables and PivotCharts
Chapter 7: Creating and Using PivotTables
Chapter 8: Performing PivotTable Calculations
Chapter 9: Building PivotCharts

Part 3: Discovering Advanced Data Analysis Tools
Chapter 10: Tracking Trends and Making Forecasts
Chapter 11: Analyzing Data with Statistics
Chapter 12: Analyzing Data with Descriptive Statistics
Chapter 13: Analyzing Data with Inferential Statistics

Part 4: The Part of Tens
Chapter 14: Ten Things You Ought to Know about Statistics
Chapter 15: Ten Ways to Analyze Financial Data
Chapter 16: Ten Ways to Raise Your PivotTable Game

Appendix: Glossary of Data Analysis and Excel Terms