Excel 2016 Training

Course Description:

In this 1 day course will build on the previous Excel courses, introducing more advanced topics such as macros and Power Views.

Who is this course for:

Delegates who wish to extend your knowledge into more specialised and advanced capabilities of Excel by automating some common tasks using macros, use Power Views, and edit the ribbon.

Delegate Requirements:

• Use Data Validation
• Work with Statistical Functions
• Work with Text Functions
• Work with Financial Functions
• Use Auditing Tools
• Insert Illustrations
• Create PivotTables
• Create and work with Templates
• Collaborate with others

Objectives:

• Create macros to automate common tasks
• Use form controls
• Use advanced techniques to analyse data
• Import and export data
• Use Power Queries
• Create Power Views
• Customise the Ribbon

Course Content:

Creating Macros
Creating a Macro
Comparing Relative and Absolute Macros
Running a Macro
Editing a Macro
Assigning Shortcuts to Macros
Macro Security
Analysing Data
Creating a Single Input Data Table
Creating a Two-Variable Data Table
Creating Scenarios
What If Analysis using Goal Seek
Consolidating Data
Import and Export Data
Exporting Excel Data
Importing Delimited Text
Combine data from other sources
Run Power Queries
Power Views
Adding Power View Button
Inserting a Power View Sheet
Modifying the Power View Fields and Filters
Adding Additional Visualisations
Using PowerMap
Using Form Controls
Creating a Form
Creating a Custom Form
Protecting Controls and Linked Cells
Editing the Ribbon
Editing the Tab wording
Adding a new Tab
Adding a new Group
Adding buttons to a group
Adding Macro buttons
Excel Options
General
Formulas
Proofing
Save
Language
Advanced
Customise Ribbon
Quick Access Toolbar
Add-ins
Trust Center

Duration: 1 Day

Cost: £235 + VAT