Excel Functions and other functionalities Short-Shot

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()