MS Excel 2016 - Introduction
course

MS Excel 2016 - Introduction

BiteSize
Updated Jun 13, 2024
Course Description

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 introductory MS Excel course is for anyone who needs to understand the way Excel works. It's suitable for complete beginners.

 

Learning Objectives

By the end of this course;

  • You will be able to navigate a spreadsheet, use the ribbon and the quick access toolbar.
  • You will be able to enter and edit data as well as copy and move it.  
  • You will learn about absolute and relative referencing and be able to determine the order of calculations.
  • You will learn how to create basic formulas and use basic functions such as the auto-sum, minimum, maximum, average and count Functions.  
  • You will also learn how to format worksheets, create basic charts and lastly manage large worksheets.

 

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