ITC007: Excel 2016 Expert

Course Objectives

At the end of this workshop, participants should be able to:

• 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