Details
Goals
Be able to create formulas including one or more functions.
Prerequisite
Basic knowledge of Excel.
Contents
General formula topics
-
Use absolute references ($) in formulas.
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, NETWORKDAY
Sign up
Next session(s)
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!