"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Microsoft Excel Level 3 Advanced Duration: 1 Day

Course Overview

Data Consolidation Advanced Database Options Outlining Pivot Tables & Pivot Charts Dashboards Working with MACROS




Target student

This course takes users to a high level of knowledge in using Microsoft Excel.


Delegates should have an understanding of any of the Windows operating system and a good understanding of Microsoft Excel or alternatively should have attended Excel level 1 and level 2 training or have equivalent knowledge.

Creating Templates

Creating a Template File

Data Consolidation

Using Data Consolidation by Position

Using Data Consolidation by Category

Worksheet Protection

Protecting Data

Using Worksheet Protection

Password Protecting a Workbook

Advanced Database options

Using Data Validation

Creating validation lists

Using the Excel Table Feature


Manual outlining

Creating an auto outline

Clearing an outline


Inserting Hyperlinks


Data Range Vs Table

Creating Pivot Tables

Grouping Excel Pivot Table Data

Create Multiple Pivot Table Reports with Show Report Filter Pages

Using & Formatting Slicers

Pivot Charts

Using Slicers with Charts


Creating a simple dashboard

Adding slicers and charts to the dashboard

Linking slicers to multiple charts

Working with Macros

Recording and Using Macros

Assigning a Macro to the Quick Access Toolbar

Editing/Deleting Macros