Excel - Adv - Evening Course (6-8 pm) - Content B (groups of 6+ only)
Enquire About This Course
CONTENT B

Advanced Functions
- Lookup Functions (Horizontal and Vertical Lookup)
3D Ranges
- Consolidate Data (via 3D Ranges & using the Consolidate Tool)
Pivot Tables
- Create Pivot Table
- Work with Row/Column Fields
- Data Fields
- Customise Table Display
Macros
- Create Macros – Record and Modify the VBA code generated
- Relative Referencing
- Assign to Toolbars/Keyboard
- Make available to all new documents/current document only
Enquire About This Course