top of page
Microsoft Excel Advanced
Customising the work area
Customise the ribbon & quick access toolbar
Create & using styles
Creating a template
Macros
Create and using basic Macros
Advanced formula Constructions
Nested functions
Using VLOOKUP and MATCH Functions
SUMIF and SUMIFS
Validation
Group and Hide
Protect the worksheet
Consolidating information
Functions with 3 – D reference
Consolidating Workbooks
Data manipulation
Sub Totals
Convert to a table
Sort & Filter
Multiple File Linking
Working with workbooks
Linking individual cells
Formula auditing
Pivot tables
Creating & changing pivot tables
Pivot table views
Adding a calculation field
Pivot Chart
Creating & formatting a pivot chart
bottom of page