Excel Expert

Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel  environments to meet project needs and increase productivity.  Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Course Objectives:

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables


This course is part of the MS Office Certificate. Complete all required courses to gain the certificate. 

Course number:
Campuses offered:
  • Terrace

TERRACE Sep 29 (2024) 8:30am-3:30pm


  • Excel Essentials (CECOMP 916)
Register at: