FR
EN
Details
Goals
Be able to create formulas including one or more functions. Be able to create more advanced formulas.
Prerequisite
Basic knowledge of Excel.
Contents
General formula topics
-
Use absolute references ($) in formulas.
-
Use structured references within Excel table (formatted with Format as Table).
-
Use formula spill.
Function input
-
Input a basic statistical function by using the AutoSum,
-
Input a function by using the function wizard,
-
Input a function by using the Excel formula autocomplete,
Functions
-
Create statistics using SUM, MAX, MIN, AVERAGE, COUNT and COUNTA,
-
Create simple logical formulas using IF,
-
Compare values with SWITCH,
-
Use MID, RIGHT, LEFT, CONCAT, LEN and TEXTJOIN to create text formulas.
-
Create date formulas using TODAY, WEEKDAY, YEAR, MONTH, NETWORKDAYS.INTL and DATE.
-
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.
-
To go further
These courses
may be of interest to you
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!