Excel Microsoft 365 Apps for Enterprise - Functions 1

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