MS Excel - Advanced

This Advanced course focuses 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 and NOT
  • count up blank cells
  • add up cells that meet a certain criteria with COUNTIF
  • use V and H lookups to quickly pick up data
  • perform calculations based around dates and also create different types of charts depending on the data you have

Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.

You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.


Expand all