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 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Learning Objectives:

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Demonstrate how to create macros

How You Will Benefit:

  • Become proficient in the excel 1016
  • Improve efficiency and effectiveness
  • Develop problem-solving skills
  • Participants will learn short-cuts to increase productivity
  • Enhance data management skills

Who should attend?

Anyone who is a beginning user of the 2016 version of excel

Prerequisites: None

Course Format: Live instructor led (synchronous)

Course Duration: 8 hours


Course Information



This course does not have any sections.