Excel Advanced
This course is designed to learn how to use a combination of more complex functions, formulas; nested IF statements, VLOOKUP, HLOOKUP and LOOKUP tables, to learn how to begin to develop a personalised Interface through the creation of Active worksheet Buttons and Macros, to learn how to manipulate spreadsheets in Excel to present selected data using more Advanced Excel software tools: Pivot Tables and Pivot Charts.