Chapter 18. Working with Data

In this chapter, you will:

  • Explore new and improved data features in Excel

  • Learn how to get help easily when working with formulas

  • Work with structured table references in formulas

  • Understand how to resolve errors in formulas

  • Discover how to streamline your Excel workbooks

  • Get sorting and filtering essentials

For those of you who hesitate to delve into the world of Microsoft Excel because you don’t like math, I’d like to start this chapter with a little story.

I dropped precalculus twice during high school. Yes, I used to be a ranking member of the math-phobic society. Ironically, by some odd stroke of luck, I placed out on the math achievement test in my senior year. So, I wasn’t required to take math in college. It was ...

Get Documents, Presentations, and Workbooks: Using Microsoft® Office to Create Content That Gets Noticed 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.