MS Excel 2016 - Expert

MS Excel 2016 - Expert

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 Expert level course is aimed at learners who want to get the most out of MS Excel and who have a very good practical knowledge of using MS Excel.

Learning Objectives

By the end of this course:

  • You will be to create dynamic ranges, use ISERR, ISBLANK and ISNA functions and DSUM and DCOUNT.  
  • You will also take macros to another level by exploring the Visual Basic Editor and turning off screen flashing.
  • Lastly you will explore further features with pivot tables such as filtering fields and calculated items.

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