You've reached the end of your
Advanced Excel Functions course free trial

Introduction

Prerequisites What is a function? Cell references Paste special

VLOOKUP VLOOKUP exercise HLOOKUP HLOOKUP exercise

INDEX MATCH INDEX MATCH exercise MATCH types MATCH exercise

INDIRECT INDIRECT exercise OFFSET OFFSET exercise

The IF function IF exercise SUMIF SUMIF exercise SUMIFS SUMIFS exercise COUNTIF COUNTIF exercise COUNTIFS COUNTIFS exercise AVERAGEIF AVERAGEIF exercise AVERAGEIFS AVERAGEIFS exercise

Culminating exercise

Conclusion