Details
Goals
Be able to create more advanced formulas.
Prerequisite
Basic Excel functions.
Contents
General formula topics
-
Use structured references within Excel table (formatted with Format as Table),
-
Use formula spill.
Functions
-
Use XLOOKUP to get data from another table.
-
Use IFERROR to handle Excel formula errors.
-
Use Nested IF functions, AND, OR and IFS to create complex logical formulas,
-
Use SUMIFS, COUNTIF(S), AVERAGEIFS, MAXIFS and MINIFS to create statistical formulas based on criteria.
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!