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.
Switch between relative, absolute, and mixed references
Nested IF Function
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
Change a name
Delete one or more names
Show or hide outlined data
Copy outlined data