You've reached the end of your
Advanced Excel Functions course free trial
Whoa, there! You've reached the end of your Advanced Excel Functions course free trial. Thanks so much for trying it out. We hope you enjoyed your free lessons!
If you've enjoyed learning with Deskbright, why not upgrade to the full Advanced Excel Functions course? When you upgrade, you'll unlock all 37 lessons for unlimited viewing.
Advanced Excel Functions
-
Table of contents
Introduction 1
Prerequisites 4
Basic lookups 4
INDEX MATCH 4
Advanced lookups 4
Lookup helpers 4
Conditional functions 14
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 1
Conclusion 1