CHAPTER 10

image

Advanced Formula Concepts

The previous chapter’s formula examples may have appeared complicated at first, but you should be able to use them with time, practice, and patience. If you followed the advice at the start of Chapter 9, which was to work through formulas with techniques like Excel’s Evaluate Formula feature, you should find them easier to understand.

In this chapter, you will investigate how these formulas are applied. Specifically, I will cover the following:

  • Filtering and highlighting
  • Selection
  • Aggregation

Filtering and Highlighting

Following what you learned about ones and zeros in Chapter 9, you can use formulas for ...

Get Dashboards for Excel 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.