CMTN Continuing Studies 

Upcoming courses

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.

Course number:
CECOMP 915
Campuses offered:
  • Online
  • Terrace
Times:

No upcoming dates scheduled. Please contact your local campus to express interest or contact Contract Services to set up training for your organization. 

Hours:
6
Register at:
Textbooks & supplies:
Students must supply own laptop/computer.

Contact

For more information on upcoming courses contact CMTN Workforce Training.