Microsoft Excel - Intermediate

Course Dates
02/10/2020 - 02/10/2020
9:00AM - 4:30PM (CST)
1 Campbell Plaza, Ste. B
St. Louis, MO 63139

05/19/2020 - 05/19/2020
9:00AM - 4:30PM (CDT)
1 Campbell Plaza, Ste. B
St. Louis, MO 63139


Member Fees: $175

Non-Member Fees: $195

This ILT Series course will teach students how to work with large worksheets in Microsoft Excel, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel (exam 77-421). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel.

Microsoft classes are held at Centriq Training
1 Campbell Plz | Ste 2b | Saint Louis, MO | 63139

*Registrations will not be accepted within five business days of the event.

For Cancellation/Reschedule and Inclement Weather Policy please click HERE

HRCI Accreditation:


SHRM Accreditation:


CPE Accreditation:

Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Customized Training Courses

Why settle for standard public training when you can have a custom program that would include your Mission, Vision, and Company Values? Imagine a program that tailors the workshop and activities to the market you serve! If this sounds appealing, call your AAIM Account Executive today to explore the possibilities.

Learn More About AAIM

Become a Member and Save! Our members receive additional benefits, including discounted costs on AAIM-hosted events and training.

Ask About Our Services