Microsoft Excel Advanced Level

Welcome to the Microsoft Excel Advanced Level Course. The Microsoft Excel Advanced Level Course provides a fantastic insight into using the Excel software. The course will explore various ways in which you prepare financial reports in the Excel system.

In order to complete the course candidates must do the following:

• • Read the course modules
  • Complete final assessment test

How can I access the Software?

As part of the course, it is useful for you to follow along and practice each function discussed by using the trial version of the Excel software. The free Excel trial will give you access for 1 month.

Try Excel for Free

We hope you enjoy the course and good luck! As part of the course it is essential for you to read the course information, please use the button below to access the course instructions prior to starting the course.

Module 1	Using Text to Columns
Using Text to Columns
Unit 1	Text to Columns

Module 2	The Paste Special Function
The Paste Special Function
Unit 1	Paste Special

Module 3	Data Validation
Data Validation
Unit 1	Data Validation

Module 4	Subtotals and Grouping
Subtotals and Grouping
Unit 1	Subtotals and Grouping

Module 5	Consolidating Data
Consolidating Data
Unit 1	Consolidate Data

Module 6	What-if Analysis - Data Tables
What-if Analysis - Data Tables
Unit 1	What-if Analysis - Data Tables

Module 7	What-if Analysis - Scenarios
What-if Analysis - Scenarios
Unit 1	What-if Analysis - Scenarios

Module 8	What-if Analysis - Goal Seek
What-if Analysis - Goal Seek
Unit 1	What-if Analysis - Goal Seek

Module 9	Text Functions
Text Functions
Unit 1	Text Functions

Module 10	Lookup Functions
Lookup Functions
Unit 1	Lookup Functions

Module 11	Maths and Trig Functions
Maths and Trig Functions
Unit 1	Maths and Trig Functions

Module 12	Statistical Functions
Statistical Functions
Unit 1	Statistical Functions

Module 13	Database Functions
Database Functions
Unit 1	Database Functions

Module 14	Hyperlinks
Hyperlinks
Unit 1	Hyperlinks

Module 15	Linking Data
Linking Data
Unit 1	Linking Data

Module 16	Formaula Auditing and Error Tracing
Formaula Auditing and Error Tracing
Unit 1	Formula Auditing and Error Tracing

Module 17	Getting External Data
Getting External Data
Unit 1	Getting External Data

Module 18	Pivot Tables and Pivot Charts
Pivot Tables and Pivot Charts
Unit 1	Pivot Tables and Pivot Charts

Module 19	Protecting and Sharing Worksheets and Workbooks
Protecting and Sharing Worksheets and Workbooks
Unit 1	Protecting and Sharing Worksheets and Workbooks

Module 20	Workbook Properties and Inspection
Workbook Properties and Inspection
Unit 1	Workbook Properties and Inspection

Module 21	Encrypting and Finalising Workbooks
Encrypting and Finalising Workbooks
Unit 1	Encrypting and Finalising Workbooks

Module 22	An Introduction to Macros
An Introduction to Macros
Unit 1	An Introduction to Macros

Module 23	Illustrations Text Boxes and WordArt
Illustrations Text Boxes and WordArt
Unit 1	Illustrations, Text Boxes and WordArt

Module 24	Custom Number Formats in Excel
Custom Number Formats in Excel
Unit 1	Custom Number Formats

Module 25	Using Custom Lists
Using Custom Lists
Unit 1	Custom Lists

Module 26	Working with Templates
Working with Templates
Unit 1	Working with Templates

Module 27	Tracking Changes in Excel
Tracking Changes in Excel
Unit 1	Tracking Changes

Module 28	Merging and Compare Excel Workbooks
Merging and Compare Excel Workbooks
Unit 1	Compare and Merge Workbooks