COURSE DESCRIPTION: This ILT Series course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with logical and statistical functions, as well as lookup functions and data tables such as, MATCH, and INDEX.. They will learn advanced data management, data validation and database functions. Students will learn about exporting and importing text files, XML data and getting external data, also about the analytical features of Excel (such as Goal Seek and Solver), Analysis ToolPak and scenarios. Finally they will learn running and recording macros, working with VBA code and creating functions.
PREREQUISITES: To ensure successful completion of this course, we recommend that you first complete the Microsoft Excel Introduction and Intermediate class.