Course
EXFUN: 0.5 Days; Instructor-led by Michael Ouchi (Master Office Instructor)
The
heart of Excel are the formulas and functions available to calculate, format
and manipulate data. This short shot aims to give you an overview of some of
the more practical formulas and functions that you will be able to incorporate
into your day to day use of Excel.
·
Core
Functions: Sum(), Min(), Max(), Average() and Count()
·
Conditional
Formatting
·
Data
Validation
·
IF()
statements
·
Vlookup()