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.
EXCEL 2016 EXPERT COURSE OUTLINE:
Module One: Manage Workbook Options and Settings
Module Two: Apply Custom Data Formats and Layouts
Module Three: Create Advanced Formulas
Module Four: Create Advanced Charts and Tables