Excel 2016 Expert
- Description
- Reviews
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.
What will be learned from this program?
The topics covered in the Excel 2016 Expert program are:
- Module One: Getting Started
- Module Two: Manage Workbook Options and Settings
- Module Three: Apply Custom Data Formats and Layouts
- Module Four: Create Advanced Formulas
- Module Five: Create Advanced Charts and Tables
- Module Six: Wrapping Up
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
- Work with macros
- Define and use named ranges
- Apply functions in formulas using logical functions, math & trig functions, statistical functions and date & time functions
- Get & transform data
- Perform what if analysis
- Troubleshoot formulas
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
Recommended For:
At the end of this workshop, participants should be able to:
- All Staff
Time to Complete:
Two days
Format:
• Work Book – Lecture
• Workshops – Video
Language:
English / Arabic
Please, login to leave a review
