The Instructor starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. You will also learn how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, math and some information functions. The course focuses on practical examples that will help Trainees easily transition to using Excel’s most powerful formulas and functions in real-world scenarios.