Microsoft Excel Advanced

Suitable for: This advanced course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course.

Objectives: By the conclusion of the tutorial, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with examples used in the workshop and additional files supplied for practise exercises.

Course Content:

Absolute References

Switch between relative, absolute, and mixed references

IF function

Syntax

Nested IF Function

VLOOKUP function

Description

Syntax

Define and use names in formulas

Define a name for a cell or cell range on a worksheet

Define a name by using the New Name dialog box

Manage names by using the Name Manager dialog box

View names

Change a name

Delete one or more names

Subtotals

Show or hide outlined data

Copy outlined data

Remove subtotals

Pivot Tables