Excel Data Analysis For Dummies, 5th Edition

Book Description

Turn jumbles of numbers into graphics, insights, and answers with Excel

With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions—it’s all in here, with examples and ideas for Excel users of all skill levels.

This latest edition covers the most recent updates to Excel and Microsoft 365. You’ll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice—and Dummies is the best choice for learning how to make those numbers sing.

• Learn how to use Excel’s built-in data analysis features and write your own functions to explore patterns in your data
• Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers
• Clean up large datasets and identify statistical operations that will answer your questions
• Perform financial calculations, database operations, and more—without leaving Excel

Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

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: Analyzing Table Data with Functions

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

Part 3: Discovering Advanced Data-Analysis Tools
Chapter 9: Dealing with Data Models
Chapter 10: Tracking Trends and Making Forecasts
Chapter 11: Analyzing Data Using Statistics
Chapter 12: Analyzing Data Using Descriptive Statistics
Chapter 13: Analyzing Data Using 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

About The Author

Paul McFedries