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
Following what you learned about ones and zeros in Chapter 3, you can use formulas for filtering ...