Paul McFedries

“Information appears to stew out of me naturally, like the precious ottar of roses out of the otter.” —⁠Mark Twain

Excel Data Analysis For Dummies, Fifth Edition

Everything useful there is to know about using Excel to analyze data

Front cover of the book Excel Data Analysis For Dummies, Fifth Edition

Book Info

  • Publisher: Wiley Publishing
  • Pages: 368
  • Price: US$39.99
  • Pub. date: February 15, 2022
  • Category: productivity
  • Tags: analysis, Excel, intermediate, Microsoft 365, Office, Office 2021, Office 365, spreadsheets
  • Example files: Download this book’s example files to your device (ZIP file; 2.9 MB).

The world is bursting at the seams with data. It’s on our computers, it’s in our networks, it’s on the web. Some days, it seems to be in the very air itself, borne on the wind. But here’s the thing: no one actually cares about data. A collection of data — whether it resides on your PC or some giant server somewhere — is really just a bunch of numbers and text, dates and times. No one cares about data because data doesn’t mean anything. Data isn’t cool. You know what’s cool? Knowledge is cool. Insight is cool.

So how do you turn data into knowledge? How do you tweak data to generate insight? You need to organize that data, and then you need to clean it, sort it, filter it, run calculations on it, and summarize it. In a word, you need to analyze the data.

Now for the good news: If you have (or can get) that data into Excel, you have a giant basket of data analysis tools at your disposal. Excel really seems to have been made with data analysis in mind, because it offers such a wide variety of features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. If you can get your data into Excel, Excel will help you turn that data into knowledge and insight.

This book takes you on a tour of Excel’s data-analysis tools. You learn everything you need to know to make your data spill its secrets and to uncover your data’s hidden-in-plain-sight wisdom. Best of all, if you already know how to perform the basic Excel chores, you don’t need to learn any other fancy-schmancy Excel techniques to get started in data analysis. Sweet? You bet.

Please use the following sections to learn more about the book.

Related Books
Buy It