North Central College - Naperville, IL

Course Description

Ms Excel 2013: Advanced

This advanced course will build on the skills and concepts taught in MS Excel 2013: Intermediate. You will work with advanced functions and formulas like IF, PMT, and VLOOKUP. In addition, you will learn about data validation and custom AutoFilter and Advanced Filter. You will also learn how to work with PivotTables and PivotCharts, import and export data, and query external databases. Finally, you will learn about advance charting features, analytical features like Goal Seek and Scenarios, and running and recording Macros. (Fee includes workbook)

T, 10/28/14- 11/18/14        06:30PM - 08:30PM