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.

Prerequisites

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

Outlining

Manual outlining

Creating an auto outline

Clearing an outline

Hyperlinks

Inserting Hyperlinks

PivotTables

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

Dashboards

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