Skip to content

MS Excel 2016 - Level 4

Find a Course
  • Or choose a specific course

MS Excel 2016 – Level 4

Course Cost £235 +VAT
Duration 1 DAY
  • 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

Who Should Attend

Delegates
Course Cost £235 +VAT
Duration 1 DAY

Experts in Construction and Infrastructure Training

1000+

Training courses available

250000+

Course hours completed

50+

Expert trainers

CITB, APS, IEMA

Accreditation training centres

12

Accreditations

Testimonials

We’ve helped thousands of professionals grow their skills and confidence. Hear directly from the people who’ve taken our training courses.

The course was exceptional, well run in terms of delivery of information, IT online course but seamless. Very interesting examples of temporary works failures applicable to the businesses we worked in. Break out activities / group examples worked very well and were again well managed by the trainer. Fantastic course, I will recommend to others! Best course I have attended in years!

CITB Temporary Works Co-Ordinator

Black & Veatch

The trainers knowledge was excellent and I liked his examples and how he could relate them to every day relatable examples that we could all understand. Coming from different industries and sectors his examples were a common ground. It was handled very well virtually and the engagement worked with his questioning and answering

Contract Management

The Pension Regulator

The training was very interactive and the tutor was excellent in engaging every course attendee and ensuring that the course content was tailored to each attendees Organisation and Company requirements

CITB Temporary Works Awareness

Kone – H &S Advisor

Contact an Expert Trainer