CHAPTER 4
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 3, 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 3, you can use formulas for filtering ...
Get Advanced Excel Essentials 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.
