Chapter 3
Introducing Excel Tables
IN THIS CHAPTER
Figuring out tables
Building tables
Analyzing tables with simple statistics
Sorting tables
Discovering the difference between using AutoFilter and filtering
One of the secrets of data-analysis success is being organized. I’m talking about not your desk or your office (insert sigh of relief here) but your data. If you have a worksheet with numbers and text inserted haphazardly, analyzing that data will be next to impossible. Why? Because Excel is the neat freak of the software world. If data is strewn around the worksheet any old way, Excel throws up its hands and says, “I can’t work under these conditions!”
Fortunately, Excel understands that the rest of us aren’t so orderly, so it offers the table — a powerful tool designed not only to get your data lined up like soldiers on parade but also to help you analyze that data and extract useful information. In this chapter, you discover what tables are and why they’re so darned useful ...
Get Excel Data Analysis For Dummies, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
