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



Or find a course by:

Microsoft Excel 2010: Intermediate

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 Microsoft Excel features to improve their productivity. The course will include how to plan and incorporate Financial Functions in workbooks using range names; create 3-D formulas, to include linking information from one worksheet to another; and the creation of Data Tables for analytical purposes. Students will also create a loan payment calculator, and an amortization schedule using financial functions in the process. In addition, students will develop, queryand filter an Excel Database. They will also create workbook templates, use the consolidation feature, and examine Smart Art graphics.

Who should attend?

Excel users with some experience who want to expand their Excel skill set or who need to learn how to use existing skills in the MS Excel 2010 interface.

Learning outcomes

  • Add custom borders to a range and create cell names
  • Create an Amortization Schedule
  • Sort and Query a Table
  • Use Database Functions (D-Functions)
  • Work with Multiple Worksheets and creating 3-D Formulas
  • Create and use templates

Chat Now