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.