Excel Data Analysis For Dummies

by Paul McFedries

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.

Genres: Nonfiction, Reference, Software, Technology

340 pages, Kindle Edition

First published July 15, 2002

Reviews

[Frank · Rating 4 out of 5]

Very good! I read up to and including Pivot Tables. It feels good to finally know what the heck are pivot tables! There are plenty of pictures to guide you and the instructions are well written, except for one thing, and this is why I gave it 4 stars instead of 5. In the beginning of the book, it is explained that in order to guide you, a ribbon name will be given, followed by the ribbon's category name, followed by the button you should click. Well, the ribbon name was often ignored, so I was hunting down the button I was supposed to click.

Highly recommended.

[NeeL]

Couldn't finish this one, left at 65%.
Because I've forgotten about all the t-test, f-test, regression etc. will have to learn and come back
:(

[Ashok Krishna · Rating 4 out of 5]

Whether you're a beginner, student trying to grasp the basics of Excel or a corporate executive trying to grab some insights from your data using an efficient spreadsheet like Excel, or a budding data analyst trying to work your way through heaps of data in a simple way, this book has something for everyone. Not in depth, but this can take you far enough to give you confidence about your ability to work through your data.

[Kristen · Rating 2 out of 5]

This book ranged from completely basic to "I thought this was for dummies".