And it's a wrap!

Advanced Excel Functions

Agata Bak-Geerinck

Product Owner Data, Telenet

Chapter 1

• The lookups and referencing functions

• XLOOKUP( )

• INDEX () and MATCH( )

• ... and their powerful combination!

• Using named ranges for efficiency

Chapter 2

• Building on our referencing skills

• New function: OFFSET( )

• ... and its powerful combination with INDEX( ) and MATCH( ) functions!

• Dynamic selections and ranges

Chapter 3

• New family of functions: database functions

• DSUM( ), DCOUNT( ), DAVERAGE( ) ...

• Working efficiently with large datasets

• Aggregating and calculations based on AND/OR conditions

Don't stop learning!

Advanced Excel Functions