This Master course is aimed at learners who have a good sound knowledge of Excel and can use basic functions such as IF and OR, NOT, countif and countblank.
This
course covers topics to enable data to be summarised and format data depending
on criteria. It also covers some analytical functions. It also covers how to record repetitive
tasks.
By the end of the course you will be able to use financial functions such as PMT, FV and Rate and also Match and Index functions. You will learn how to use conditional formatting to highlight trends and exceptions with a click of the mouse. You will learn how to work with pivot tables and charts, create and play back macros. Lastly you will learn how to use some analytical functions such as goal seek, solver and scenarios as well as use one and two input data tables.
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.
Go to the Learning Tips to view the learning objectives for this course.