FC200 Intermediate Level Spreadsheeting Skills: Assessing and Organizing Data

This is an intermediate spreadsheeting course using Microsoft Excel to assess and organize data in an electronic format. The class is designed for learners who have experience using Excel and who want to increase their spreadsheeting knowledge and skills. Topics include data preparation, Excel table options and features, charting, advanced sorting and filtering using AND and OR logic, date and text formulas, flash fill, handling formula errors, VLOOKUP, named ranges, and data validation. This course combines live demonstrations, instructor-led exercises, and independent student exercises.