"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/Microsoft Excel Level 3 Advanced Duration: 1 Day

Microsoft Excel Level 3 Advanced Duration: 1 Day

Course Overview

Course Objectives Recording, Assigning and Using Macros Templates Data Consolidation Performing “What If” Analysis Working with Scenarios Querying a Database Importing and Exporting Files and Data Protecting Data Hyperlinks

 

 

Target student

This course takes users to a high level of knowledge using financial topics available in Excel such as

financial functions, auditing and charts.

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

Working with Macros

Recording and Using Macros

Assigning a Macro to the Quick Access Toolbar

Editing/Deleting Macros

Data Consolidation

Using Data Consolidation by Position

Using Data Consolidation by Category

Using Data Analysis Tools

Working with Scenarios

Goalseek

Solver

Worksheet Protection

Protecting Data

Using Worksheet Protection

Password Protecting a Workbook

Sharing a workbook

Track Changes

Advanced Database options

Using Data Validation

Get External Data

Importing and Exporting Files

Using the Excel Table Feature

Pivot Tables

Creating PivotTables

Creating PivotCharts

Auditing Worksheets

Identifying the Auditing Commands

The Watch Window

The Formula Evaluator

Tracing and Correcting Worksheet Errors

Outlining

Manual outlining

Creating an auto outline

Clearing an outline

Hyperlinks

Inserting Hyperlinks