MS Excel 2016 – Level 4
- Course focuses on advanced Excel topics like macros and Power Views.
- Designed for delegates seeking to enhance Excel skills.
- Learn to automate tasks, use Power Views, and edit the ribbon.
- Objectives include creating macros, analyzing data, and using Power Queries.
- Course content covers creating macros, analyzing data, and using Power Views.
Overview
The Excel 2016 Training course is designed for delegates seeking to enhance their Excel skills with advanced topics like macros and Power Views. Participants will learn to automate tasks, use form controls, analyze data, import/export data, and customize the Ribbon. Prerequisites include knowledge of Data Validation, Statistical, Text, and Financial Functions, PivotTables, and collaboration tools. The course aims to empower users to efficiently manipulate data and optimize Excel's capabilities in a one-day session.
Who should attend
Delegates
Course Content
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