Microsoft Excel 2016 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 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 Manage Workbooks Save a workbook as a template Copy macros between workbooks Mange Document Versions Reference data in another workbook Reference data by using structured references Enable macros in a workbook Display hidden ribbon tabs Manage Workbook Review Restrict