Excel Expert Courses – LearnOnline

Category:

Business / Computing / Microsoft Office Courses / Part-time / Self Study /

From: £20.00

Microsoft Office Excel Expert Business Training courses

Price From: £20.00

Overview

These courses are aimed at learners who already have a good grasp of Microsoft Excel. We have 3 Excel Expert courses varying from Level 1 – Level 3.

If you would like to improve on your basic Excel skills, please see the other Excel Courses we have available.

Level 1 – 2 hours 45 minutes
Level 2 – 2 hours 45 minutes
Level 3 – 3 hours 30 minutes

Level 1

About the Course

The Microsoft 365 – Excel Expert – Level 1 course covers topics included in the MOS Expert exam. This includes using Advanced Chart features, PivotTables and PivotCharts. You will also learn how to create Scenarios, Data Tables and use Goal Seek.

There are 7 modules in this course:

Advanced Chart Features Trendlines and Sparklines

Trendlines;
Understanding Trendlines
Formatting Trendlines;
Removing Trendlines;
Forecasting Trendlines;
Other Trend Methods;
Adding Sparklines;
Removing Sparklines

Dual Axes and Chart Templates

Adding Additional Axes;
Changing Marker Colours;
Saving a Chart Template;
Applying a Chart Template;
Apply to Existing Charts.

PivotTables, PivotCharts and Slicers PivotTables

Creating PivotTables;
PivotTable Fields List;
Hide/Show the Field List;
Grouping PivotTable Data;
Arranging PivotTables;
Adding Calculated Fields;
Removing Calculated Fields;
Use GETPIVOTDATA.

Working with PivotTables

Update PivotTable Data;
Displaying PivotTable Records;
Showing Report Filter Pages;
Customising Fields;
Hiding Field Headers;
PivotTable Report Options;
Formatting PivotTables.

PivotCharts

Creating PivotCharts;
Filtering PivotCharts;
Removing Filters;
Switching Axes;
Using Quick Layout;
Applying Chart Styles;
Formatting PivotChart Objects;
Changing the Chart Type;
Drilling Down.

Slicers

What are Slicers?;
Adding Slicers;
Slicer Options;
Filtering Slicers;
Clearing Filters;
Selecting Multiple Slicers
Sharing Slicers;
Connecting Slicers.

Data Analysis Tools

Naming Variable Cells;
Naming the Result Cell;
Creating Scenarios;
Adding Scenarios;
Scenario Manager Options;
Create Summary Reports;
Using Data Tables;
Using Goal Seek.

Level 2

About the Course

The Microsoft 365 – Excel Expert – Level 2 course covers topics included in the MOS Expert exam. This includes using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools.

There are 7 modules in this course:

Logical and Informational Functions

IF Function;
OR Function;
AND Function;
Help for Error Messages;
Nested IF Functions;
IS Functions;
ISERROR Function.

Time and Mathematical Functions

Using Functions;
Insert Function Box;
TODAY Function;
Displaying Dates as Numbers;
DAY Function;
MONTH Function;
YEAR Function;
COUNT Function;
COUNTA Function;
COUNTIF Function;
SUMIF Function;
AVERAGEIF Function;
ROUND Function;
Nesting Functions;
Circular Functions;
Iterative Calculations.

Lookup Functions

VLOOKUP Function;
Creating Lookup Tables;
Inserting Functions;
VLOOKUP Arguments;
LOOKUP Function;
Modify Lookup Data;
HLOOKUP Function

Consolidating and Auditing Consolidating Workbooks

Consolidating Data;
What is Consolidation?
Selecting Destination Area;
Consolidating Workbooks;
Creating Links;
Updating Linked Data;
Outlining Features.

Auditing Tools

Using Auditing Tools;
Trace Precedents;
Trace Dependents;
Removing Tracer Arrows;
Tracing Errors in Formulas;
Correcting Formula Errors.
Viewing Formula Locations;
Show Formulas.

Protecting and Sharing Workbooks

Protecting Worksheets;
Removing Protection;
Protecting Workbooks;
Opening Protected Workbooks.

Sharing Workbooks

Sharing Methods;
Share with People;
Uploading to OneDrive

Level 3

About the Course

The Microsoft 365 – Excel Expert – Level 3 course covers topics included in the MOS Expert exam. This includes custom templates, data formats and Internationalizing workbooks. You will also get external data, use macros and form controls, evaluate formulas and use the MATCH and INDEX functions.

There are 7 modules in this course:

Internationalization and Accessibility Languages and Accessibility

Internationalization;
Language Options;
Adding Editing Languages;
Language Proofing Options;
Applying Currency Formats;
Applying Accounting Formats;
Applying Date Formats;
Creating Font Themes;
Checking for Accessibility.

AutoSave Versions and Custom Templates AutoSave and Templates

AutoSave;
Restoring AutoSave Versions;
Restoring AutoRecover Files;
Creating New Templates;
Opening Custom Templates.

Creating Custom Formats Custom Formatting

Creating Custom Formats;
Creating Number Formats;
Creating Date Formats;
Creating Time Formats;
Creating Conditional Formats;
Applying Conditional Formats;
Creating Custom Styles;
Applying Custom Styles.

Data Sources and Queries External Data and Queries

Get External Data;
Refreshing External Data;
Importing Multiple Tables;
Creating Custom Queries;
Appending Queries;
Merging Queries;
Removing Fields;
Editing Steps;
Renaming Fields.

Using Macros and Form Controls Macros and Form Controls

Macros;
Customize Ribbon Settings;
Viewing Macros;
Editing Macros;
Worksheet Controls;
Inserting Controls;
Adding Text Boxes;
Modifying VBA Code;
Using Structured References;
Using Flash Fill.

Evaluating Formulas and Watch Window

Working with Formulas;
Evaluating Formulas;
Dependents and Precedents;
Tracing Dependents;
Tracing Precedents;
Using the Watch Window.

Using MATCH and INDEX Functions MATCH and INDEX Functions

MATCH and INDEX Functions;
Entering Validation Rules;
Using MATCH Functions;
Using INDEX Functions;
Nesting Functions.

Course Features

Course features

Simulation training replicates the software you are learning providing a realistic learning experience.
Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
Assess your skills at any time by undertaking the Course Test.
Lessons can be completed within 30 minutes so training can be undertaken in “bite” size pieces.
Bookmarking allows you to learn in multiple training sessions.
Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
Designed for people who require initial and refresher training activities.
Available on-line 24 hours a day.