Excel Data Analysis for Dummies - 5th Edition by Paul McFedries (Paperback)

About the Book

Book Synopsis

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.

From the Back Cover

Develop your data-analysis skills

Full of straightforward explanations and crystal-clear examples, Excel^(R) Data Analysis For Dummies is your beginner-friendly guide to analyzing data in Microsoft Excel^(R). You'll learn to create and visualize data, deploy PivotTables, use statistical functions to predict future results and describe relationships, and more. Get step-by-step guidance on how to use the world's bestselling spreadsheet and data-analysis application to achieve powerful results, whether you're new to Excel^(R) or a spreadsheet wizard.

Inside...

• Import data into Excel^(R)
• Analyze Excel^(R) data with functions
• Build PivotTables and PivotCharts
• Make reliable predictions
• Describe data relationships
• Interpret financial data
• Find patterns and trends
• Avoid common statistical pitfalls

About the Author

Paul McFedries is the owner of Logophilia Limited, a successful technical writing firm. He has 25 years' experience writing instructional computer books and is the author of over 100 books that have sold a combined 4 million copies worldwide.