600 Maryland Avenue, S.W.,
Washington, DC 20024-2520



Or find a course by:

Microsoft Excel 2010: Advanced

Home / Course Details

  • ORegistration open
  • FClass full
  • GGuaranteed to Go
  • RRemote Classroom
Multiple Registrations?
Session Schedule Location Tuition Status
Contract to bring this course to your location

Click here for more information

Course overview

This course is designed to introduce students to the more advanced Microsoft Excel Features. The course will introduce the students to tools required to both analyze and interpret large amounts of data. In addition students will examine formula auditing and data validation techniques and use tools to assist them in solving complex problems. Finally students will create macros using a code generator and develop simple programs using the Visual Basic for Applications (VBA) editor.

Who should attend?

Microsoft Excel users who wish to learn advanced Excel features. Participants should be familiar with Excel applications as taught in Microsoft Excel 2010: Introduction (SPRD7988)and Microsoft Excel 2010: Intermediate (SPRD8988T).

Learning outcomes

  • Create and format Pivot Tables and Pivot Charts
  • Use formula Auditing Techniques to analyze a worksheet
  • Use the Scenario Manager to record and save What-If assumptions
  • Use the Macro recorder to create a macro
  • Understand Visual Basic for Applications (VBA) code

Chat Now