MS Excel Course Outline – Advanced level
Course Description
This advanced MS Excel course focusses on analysing data in Excel. You will also find it helpful if you spend most of your working day using Excel and need to learn more about the various functions..
By the end of this course you will be able to work with logical functions such as IF and OR, NOT and count up blank cells, add up cells that meet a certain criteria with CountIF. You will learn how to use V and H lookups to quickly pick up data. You will learn how to perform calculations based around dates and also create different types of charts (depending on the data you have) including new ones such as Waterfall and Histograms.
Topics Covered
Logical Functions
Maths and Statistical Functions
Lookups
Text Functions
Working with dates and times
Charts
Can't see what you need?
All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.
All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.
Great deals for Corporate licences – give us a call.
