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. You'll also learn to use Names, Formula Auditing Tools, 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.