This course is for anyone who has been using Excel for budgets or other data that needs calculations and would like to learn more features to improve their ability to organise and analyse data. Learners must have used Excel before to create calculations that include absolute cell references (e.g. $B$4) and IF statements.
What you will learn
By the end of the course you will be confident in using some of Excel's more advanced formulas and be able to combine them to get the results you need. You will be able to do more complex IF statements (by nesting AND and OR inside them). You will be able to do V and HLOOKUPs. You will be able to create more complex charts, including Pivot Charts.