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