Contact us

Excel 2016 Expert

  • Manage Workbook Options and Settings
  • Apply Custom Data Formats and Layouts
  • Perform Data Analysis and Business Intelligence
  • Create Advanced Formulas
  • Perform Data Analysis and Business Intelligence
  • Create Advanced Charts and Tables
  • Create and Manage PivotCharts

Language: English

Instructors: The GROWTHville Institute

$999 97% OFF

$29.95

Why this course?

Description

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.

COURSE 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
• Work with macros

Course Curriculum

Excel 2016 Expert Course (6 Modules)
Excel 2016 Expert Quick Reference Sheet 1 of 2
Excel 2016 Expert Quick Reference Sheet 2 of 2