MS Excel 2016 - Master

MS Excel 2016 - Master

Updated Jun 07, 2019

Bite Size courses will give you the freedom and flexibility to learn Microsoft Office in easy to use bite size chunks. You can dip in and out of lesson at the time of need, or take the full course if you have more time. Learn Microsoft Office the easy way with Bite Size. Each lesson takes on average 3-5 minutes to complete and the estimated full course duration is 3 - 4 hours.

Course Overview

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.

Learning Objectives

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 high 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.

Course Notes

  • The table of contents indicates current status of each lesson with the 'X' icon indicating the lesson has been started and the 'Tick' icon indicating the lesson is complete.
  • Once a course is open, lessons can be taken in any order.
  • Once a lesson is open use the TOC to navigate