Skip to content
MS Excel 365 - 2019 Introduction Course - CPD Accredited cover image
Play overlay
Preview this course

MS Excel 365 - 2019 Introduction Course - CPD Accredited
Bite Size Ltd

This is the ultimate introduction course for any Microsoft Office user, no matter what skill level you are.

Summary

Price
£25 inc VAT
Study method
Online, On Demand 
Duration
2.5 hours · Self-paced
Qualification
No formal qualification
CPD
3 CPD hours / points
Certificates
  • Reed Courses Certificate of Completion - Free

Add to basket or enquire

Overview

This introductory MS Excel 365 / 2019 course is for anyone who needs to understand the way Excel works both on and off-line. It’s suitable for complete beginners. The lessons show the desktop and web version.

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

Enhance your career prospects and become a whizz at Excel 365 - 2019. This is the ultimate introduction course for any Microsoft Office user, no matter what skill level you are. Simply search for a lesson at the time of need or dip in and out when you have more time.

Certificates

CPD

3 CPD hours / points
Accredited by The CPD Certification Service

Curriculum

7
sections
58
lectures
2h 33m
total
    • 1: Excel Environment Preview 03:10
    • 2: Worksheet Terminology 02:20
    • 3: Navigating Worksheets 01:43
    • 4: Switching between open Workbooks 01:18
    • 5: The Ribbon 02:35
    • 6: Customising the Ribbon 04:05
    • 7: Mini Toolbar 02:05
    • 8: Quick Access Toolbar 02:56
    • 9: Status Bar 03:00
    • 10: Backstage view 02:31
    • 11: Getting Help 02:20
    • 12: Opening & Closing workbooks 02:35
    • 13: Creating & Saving workbooks 03:42
    • 14: File formats 02:34
    • 15: Entering data 03:14
    • 16: Selecting data 02:30
    • 17: Moving & copying data 04:11
    • 18: Editing cells 02:33
    • 19: Deleting vs Clearing data 03:49
    • 20: Using Undo & Redo 02:36
    • 21: Find & Select 03:42
    • 22: Creating custom lists 03:25
    • 23: Working with comments 03:55
    • 24: Managing columns & rows 03:31
    • 25: Inserting columns & rows 02:43
    • 26: Deleting columns & rows 02:36
    • 27: Managing worksheets 02:53
    • 28: Inserting & deleting worksheets 02:44
    • 29: Moving & copying worksheets 02:38
    • 30: Understanding formulas 02:27
    • 31: Order of calculation 02:53
    • 32: Entering & editing formulas 01:54
    • 33: Moving & copying formulas 02:49
    • 34: Relative & absolute references 03:02
    • 35: Using AutoSum 01:46
    • 36: SUM function 02:50
    • 37: MIN & MAX functions 02:06
    • 38: AVERAGE function 03:01
    • 39: COUNT function 02:05
    • 40: Live Preview 02:27
    • 41: Text Formatting 02:17
    • 42: Text alignment 01:19
    • 43: Text wrapping 01:20
    • 44: Merge & centre 02:08
    • 45: Text orientation 01:34
    • 46: Formatting numbers & dates 03:03
    • 47: Format painter 01:43
    • 48: Cell Styles 02:15
    • 49: Conditional formatting 04:49
    • 50: Chart basics 02:32
    • 51: Formatting charts 02:16
    • 52: Recommended charts 02:04
    • 53: Print Preview 02:15
    • 54: Page break preivew 02:02
    • 55: Page setup options 02:19
    • 56: Setting up print areas 02:18
    • 57: Spell check 02:43
    • 58: Printing worksheets 02:45

Course media

Description

By taking this Excel 365 Introduction Course, you will:

  • Understand more about how Excel 365 works
  • Increase your knowledge of using Excel 365
  • Learn how to work with data, worksheets, formulae and charts
  • Become more confident in using Excel 365 tools
  • Save yourself time and become more efficient.

Topics included within this Excel 365 Introduction Course

  • Getting Started
  • Working with Data
  • Working with worksheets
  • Formulae and Functions
  • Formatting
  • Charts
  • Preparing to Print

Who is this course for?

It’s ideal for anyone who wants to learn more about working with Excel 365 - 2019 at Introduction level, whatever age you are or whatever your skill level.

Requirements

Computer, internet access and the enthusiasm and a hunger to learn!

Career path

Excel is a fundamental data management tool, and this Course will give you a good understanding of how Excel 365 works. Learn at your own pace and revisit the lessons to support you. It's a great way to develop your skills at a time to suit you in Bite Size bites of learning. Enhance your career prospects and become a whizz at Excel 365 - 2019 with Bite Size.

Questions and answers

There are currently no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.