Skip to content
  1. Online
  2. Office skills
  3. Microsoft
  4. Microsoft Excel
MS Excel 365 - 2019 Intermediate Course - CPD Accredited cover image
Play overlay
Preview this course

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

This intermediate MS Excel course is designed for users who are already confident with the basic features of Excel.

Summary

Price
£25 inc VAT
Study method
Online, On Demand 
Duration
2.4 hours · Self-paced
Qualification
No formal qualification
CPD
3 CPD hours / points
CPD What's this?
Certificates
  • Reed Courses Certificate of Completion - Free
1 student purchased this course

Add to basket or enquire

Overview

By the end of this course you will be able to work with multiple worksheets and workbooks, alter your worksheet display, work with additional formatting options such as custom number formats and paste special, use conditional formatting and find blank cells, work with ranges of cells using named ranges, work with objects i.e. text boxes and screenshots, work with Tables, sort and filter data, use outlining and consolidate and use subtotals, protect worksheets/books and create and manage templates.

Certificates

CPD

3 CPD hours / points
Accredited by The CPD Certification Service

Curriculum

9
sections
45
lectures
2h 23m
total

    • 5: Hide / Show 04:39
    • 6: Arranging workbooks 02:39
    • 7: Freezing panes 02:32
    • 8: Creating custom views 03:59
    • 9: Grouping and Ungrouping worksheets 02:42
    • 10: Split command 02:49
    • 11: Advanced print settings 03:07

    • 12: Cell borders 03:53
    • 13: Custom number formats 02:00
    • 14: Paste special options 05:40
    • 15: Using functions to format text 03:09
    • 16: Working with styles 02:19
    • 17: Working with themes 02:21

    • 18: Creating rules 05:43
    • 19: Creating rules using formulas 04:37
    • 20: Finding blank cells 01:57

    • 21: Creating named ranges 02:28
    • 22: Using named ranges in formulas 02:00
    • 23: Editing named ranges 01:39

    • 24: Inserting text boxes 02:35
    • 25: Inserting pictures 01:58
    • 26: Inserting shapes and icons 02:40
    • 27: Inserting SmartArt 03:02
    • 28: Screenshots 01:50

    • 29: Creating excel tables 02:53
    • 30: Formatting excel tables 02:06
    • 31: Table totals 02:01
    • 32: Inserting / deleting tables rows and columns 02:06
    • 33: Sorting data 02:45
    • 34: Filtering data 05:07
    • 35: Data validation drop-down lists 04:52
    • 36: Removing duplicates 03:26
    • 37: Using slicers 02:48

    • 38: Outlining 02:57
    • 39: Consolidating data 02:56
    • 40: Creating subtotals 02:49

    • 41: Protecting workbooks 04:48
    • 42: Protecting worksheets 05:11
    • 43: Saving workbooks as web pages 02:09
    • 44: Creating and managing templates 03:04
    • 45: Digitally signing a workbook 02:41

Course media

Description

Topics included within this Excel 365 Intermediate Course

Using Multiple Workbooks and Worksheets

  • Using Multiple Workbooks and Worksheets
  • Linking Workbooks
  • Linking Worksheets with 3D Formulas
  • Headers and Footers

Worksheet Display Features

  • Hide and Show
  • Arranging Workbooks
  • Freezing Panes
  • Create Custom Views
  • Grouping and Ungrouping Worksheets
  • Split Command
  • Advanced Printing Settings

Additional Formatting Options

  • Cell Borders
  • Custom Number Formats
  • Paste Special Options
  • Using Functions to format text
  • Working with Styles
  • Working with Themes

Conditional Formatting

  • Creating Rules
  • Creating Rules using Formulas
  • Finding Blank Cells

Working with Ranges

  • Creating Named Ranges
  • Using Named Ranges in Formulas

Using Objects

  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Shapes and Icons
  • Inserting SmartArt
  • Screenshots

Excel Data and Tables

  • Creating Excel Tables
  • Formatting Excel Tables
  • Table Totals
  • Inserting/Deleting Table Rows and Columns
  • Sorting Data
  • Filtering Data
  • Data Validation Drop-Down Lists
  • Removing Duplicates
  • Using Slicers

Outlining Data

  • Outlining
  • Consolidating Data
  • Creating Subtotals

Additional Saving Options

  • Protecting Workbooks
  • Protecting Worksheets
  • Saving Workbooks and Web Pages
  • Creating and Managing Templates
  • Digitally Signing a Workbook
  • Editing Named Ranges

Who is this course for?

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

Requirements

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

Career path

MS Excel is a fundamental data management tool, and this Course will give you a good understanding of how Excel 365 works beyond the basic level.

Enhance your career prospects and become a whizz at Excel 365 with Bite Size.

Questions and answers

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

Ask a question

Reviews

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

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Online courses

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.