Follow Us on Facebook, Montgomery College, Information Technology Institute

MS Excel Level III, ITI092

Register for a Class

Summer 2014 Course Description: (Click here for Fall 2014 Description) Learn to work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation and database functions such as DSUM. Import and export data, and query external databases. You will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882). For comprehensive certification training, you should complete MS Excel Level I, II, and III. Course manual comes with CertBlaster exam prep software (download)

Prerequisites: MS Excel--Levels I and II or equivalent experience is a must.

Classroom Hours: 10

Fall 2014 Course Description: This course builds on the skills and concepts taught in Excel 2013-Level II.  Learn how to work with advanced formulas, as well as lookup functions. Learn about data validation and how to import and export data. Work with PivotTables and PivotCharts. Finally, learn how to export and import data, use the analytical features of Excel such as Goal Seek and the new Analysis tool, and run and record macros. This course follows the curriculum for the Microsoft Office Specialist core-level for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert for Excel 2013 (exams 77-427 & 428). For comprehensive certification training, students should complete MS Excel Levels I, II, III. Prerequisites: MS Excel Level II or equivalent experience, Working with Windows, File Management or equivalent experience.

Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook; bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).


Course Objectives:

 After completing this course, students will know how to: