O'Reilly logo

Advanced Excel Essentials by Jordan Goldmeier

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4

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 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required