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

Prerequisites

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

Goalseek

Solver

Data Input tables

Advance Database functions

• DSum
• DMax
• DMin
• DAverage

Tracing Formulas

Watch Window

Tables

Using the Excel Table Feature

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

Using Absolute and Relative Reference (Relative Reference Button)

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

Editing/Deleting Macros