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