Microsoft Excel 2016 Level 3

Microsoft Excel 2016 Level 3


Creating, Maintaining, Filtering and using Subtotals in a List
Recording, Assigning and Using Macros
Creating and Using User Defined Functions
Performing “What If” Analyses
Working with Scenarios
Querying a Database
Importing and Exporting Files and Data
Protecting Data
Pivot Tables, Reports and Charts.
Other Advanced Business Analysis Tools.


1 Day

Target Audience

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts


Delegates should have an understanding of the Windows operating system. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.


1: Working with Lists
Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List

2: Working with Macros and User Defined Functions
Recording and Using Macros
Assigning Macros
Using User Defined Functions

3: Using Basic Analysis Tools
Performing “What If” Analyses
Working with Scenarios

4: Using Advanced Analysis Tools and External Data
Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook

5: Using Business Analysis Tools
Working with Pivot Tables and Pivot Charts
Identifying the Parts of a Basic Pivot Table
Pivot Table Reports
Create a PivotTable from worksheet data
Create a PivotTable from an external data sourc
Create a PivotChart report from an existing PivotTable report
Delete a PivotTable or PivotChart report
Using slicers
Formatting slicers for a consistent look
Sharing slicers between PivotTables
Types of Sparklines
Create a sparkline
Customize sparklines
Control which value points are shown
Change the style of or format sparklines
Online Analytical Processing (OLAP)
Business intelligence
What is Online Analytical Processing (OLAP)?
OLAP features in Excel 2016

Appendix A: New Features in Excel 2016
New Chart Types
Get and Transform
One Click Forecasting
3D Maps
PivotTable Enhancements
Power BI
Quick Shape Formatting
Ink Equations
Data Loss Protection
File Types
The Ribbon and Toolbars
Screen Resolutions
Keyboard Shortcuts

Appendix B: Additional Features in Office 2016
Office 2016 – A New Platform
At a Glance Highlights Across the Suite
New Visual and navigational Features
File formats
User Assistance System (HELP)
Collaboration features
Themes and Quick Styles
General Keyboard Navigational Tips in Office 2016

Course Details

Course Ref:


Course Duration:

1 Day

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Location:

Virtual Classroom

Course Dates:

22nd Jun 2022 - 22nd Jun 2022
29th Jun 2022 - 29th Jun 2022
5th Jul 2022 - 5th Jul 2022
5th Sep 2022 - 5th Sep 2022

Course Price (Excl VAT):

Please call for prices...

Book this course

Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at