This level goes further with formulae, covering Nested IF functions, V-Lookup, H-Lookup and also teaches you about Pivot tables and Pivot charts as well as the basic Marco tool.
Is this level for me?
We can cover these areas if you are already a proficient user of Excel and need to learn some more of the great tools to analyse your data better or improve efficiency in your tasks.
What you will learn.
- Grouping and SubTotals
- V-Lookup, H-Lookup and nested formulae
- Pivot tables
- Charting Pivot data
- Basic Macro function