"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 1 Day

Course Overview

Target student This course takes users to a high level of knowledge in using Microsoft Excel. Data Consolidation Advanced Database Options Outlining Pivot Tables & Pivot Charts Dashboards Working with MACROS





Delegates should have an understanding of any of the Windows operating system and a good understanding of Microsoft Excel at level 2 Intermediate or have equivalent working knowledge.

Data Consolidation

Using Data Consolidation

Using Data Analysis Tools

Working with Scenarios



Data Input tables

Advance Database functions

  • DSum
  • DMax
  • DMin
  • DAverage

Tracing Formulas

Watch Window


Using the Excel Table Feature


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

Using Absolute and Relative Reference (Relative Reference Button)

Assigning a Macro to the Quick Access Toolbar and to the Ribbon

Editing/Deleting Macros