|
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
|
Please click here to view Content A
Click here to view list of ALL Excel courses

|