Excel 2016 Level 3
Work with Excel Tables and Ranges, Data integrity, Subtotals, and Data Validation. You'll learn to use a variety of Excel Functions such as: IF, SUMIF, VLOOKUP, DATE, and TIME Functions. You'll also learn to use Names in formulas and Formula Auditing Tools as well as PIVOT TABLES and much more.
Prerequisites: Excel 2016 Level 2, knowledge of Windows, Managing Files & Folders and basic computer skills. Must have an email account, Excel 2016, and bring a USB thumb drive to class. Other Excel versions subject to instructor approval.