Skip to content

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

Premium CPD Bundle| Last Updated 2024 | Certificates & Transcripts from Care Skills (Discounted Price)

Care Skills Training

Summary

Price
£25 inc VAT
Study method
Online, On Demand What's this?
Duration
8.3 hours · Self-paced
Qualification
No formal qualification
CPD
10 CPD hours / points
CPD What's this?
Certificates
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students
121 students purchased this course

Add to basket or enquire

Overview

Looking to boost your professional skills and master Microsoft Office tools like Word, Excel, PowerPoint, and Office 365?
Look no further than our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, brought to you by Care Skills Training. This comprehensive training is designed to deliver top-quality education at exceptional value, with limited-time discounts available.

Why Choose This Course?

Developed by industry experts, this course covers everything from the basics to more advanced features of Microsoft Office. Whether you're starting from scratch or want to sharpen your existing skills, the structured modules are easy to follow and accessible on any device—laptop, tablet, or smartphone.

Learn at your own pace, anytime and anywhere, with lifetime access to course materials.

Course Highlights:

  • Step-by-step tutorials on Word, Excel, PowerPoint, and Office 365

  • Self-paced learning from any smart device

  • Expert-designed modules for easy understanding

  • Lifetime access to all content

  • 14-day money-back guarantee

  • Tutor support throughout your learning journey

Assessment & Certification:

Upon completing the course, you'll take a multiple-choice assessment to test your knowledge.

  • Receive a free downloadable PDF certificate from Reed

  • Claim your CPD-accredited PDF certificate from Care Skills Training for just £5.99

  • Want a hard copy? We’ll send one by courier for £14.99

These certificates are a great way to showcase your skills and boost your CV, making you stand out in today’s competitive job market.

Transparent Pricing – No Hidden Costs

We believe in clear communication. There are no surprise fees or exam charges. All costs are detailed upfront.

Don't miss this opportunity to upgrade your skills and accelerate your career.
Enroll now in our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course today!

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

CPD

10 CPD hours / points
Accredited by The CPD Certification Service

Curriculum

7
sections
138
lectures
8h 20m
total

    • 1: Introduction 02:58
    • 2: Getting started on Windows, macOS, and Linux 01:21
    • 3: How to ask great questions 01:14
    • 4: FAQ’s 01:19
    • 5: Order 1 Certificate and Get 1 Transcript Free 01:00 PDF

    • 6: Excel 2021: Basics 05:20
    • 7: Start Excel Spreadsheet 04:26
    • 8: Enter Text and Numbers 07:24
    • 9: Relative References 03:40
    • 10: Working with ranges 06:52
    • 11: Save and Save as Actions 07:52
    • 12: File Extensions, Share, Export, and Publish files 05:53
    • 13: Excel 2021: Rows, Columns, and Cells 02:34
    • 14: Modifying Rows and Column lengths 05:03
    • 15: Excel 2021: Data Handling 07:07
    • 16: Copying Formulas 03:01
    • 17: Page setup options 05:50
    • 18: Fit to print on One Page 02:39
    • 19: Print Workbooks 02:47
    • 20: Excel 2021: Sorting and Filtering 03:48
    • 21: Sorting Data Descending Order 02:25
    • 22: Filter Data 04:09

    • 23: Excel 2021: Writing Formulas Creating Basic Formulas 06:14
    • 24: Datetime Formulas 06:20
    • 25: Mathematical formulas phase1 19:54
    • 26: Mathematical formulas phase2 12:23
    • 27: Excel 2021: Advanced Formulas VLOOKUP formula 12:12
    • 28: HLOOKUP formula 04:07
    • 29: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 07:39
    • 30: Handling #NA and Approximates match in XLOOKUP 10:31
    • 31: Excel 2021: Data and Tools Split Text into columns 07:03
    • 32: Flash Fill 07:03
    • 33: Data Validation 06:34
    • 34: Remove Duplicates 07:47
    • 35: Import Data from Text files 05:38
    • 36: Import Data from .CSV files 03:22
    • 37: Excel 2021: Formatting data and tables Formatting Font 04:15
    • 38: Formatting Alignment 06:04
    • 39: Formatting Numbers 04:37
    • 40: Formatting Date 03:29
    • 41: Formatting Tables 05:13
    • 42: Excel 2021: Pivot Tables Pivot Tables 06:43
    • 43: Pivot Charts 01:49
    • 44: Excel 2021: Charts Excel Charts – Categories 02:30
    • 45: Elements of a chart 04:12
    • 46: Creating Charts 01:55
    • 47: Column or Bar charts 04:21
    • 48: Formatting charts 03:37
    • 49: Line Charts 02:13
    • 50: Pie and Doughnut charts 03:47

    • 51: PowerPoint 2021: Course Introduction Overview 03:47
    • 52: Start PowerPoint Presentation 04:59
    • 53: Screen setting and Views 04:37
    • 54: PowerPoint 2021: Basics Presentation Tips and Guidelines 06:00
    • 55: Creating a New Presentation 03:51
    • 56: Working with Slides 03:40
    • 57: Save a Presentation 04:16
    • 58: Print Slides 03:10
    • 59: PowerPoint 2021: Text and Bullet Options Formatting Text 05:05
    • 60: Slide Text Alignments 03:01
    • 61: Multi-Column Text Alignments 01:40
    • 62: Adding Bullets and Numbered List Items 02:48
    • 63: PowerPoint 2021: Adding Graphic Assets Insert Shapes 03:26
    • 64: Insert Icons 03:02
    • 65: Insert Graphics 03:38
    • 66: Add 3D Models 02:41
    • 67: Insert Pictures 02:58

    • 68: PowerPoint 2021: Picture Formatting Picture Options 03:56
    • 69: Picture Cropping 02:33
    • 70: Applying Built-in Picture Styles 04:02
    • 71: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 02:33
    • 72: Modifying SmartArt 03:13
    • 73: Creating a Target Chart using SmartArt 03:04
    • 74: PowerPoint 2021: Working with Tables Create a Table on Slide 04:13
    • 75: Formatting Tables 02:24
    • 76: Inserting Tables 01:55
    • 77: Table Layouts 01:19
    • 78: PowerPoint 2021: Working with Charts Add a Chart 01:57
    • 79: Formatting Charts 01:48
    • 80: Insert Chart from Microsoft Excel 02:57
    • 81: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 02:31
    • 82: Adding Audio to a Presentation 01:33
    • 83: Screen Recording and Adding 02:28
    • 84: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 04:14
    • 85: PowerPoint 2021: Animation Object Animation 03:14
    • 86: Effect Options 02:03
    • 87: Advanced Animation 01:31
    • 88: Triggers to control animation 01:47
    • 89: PowerPoint 2021: Slideshow Effects Onscreen Presentation 02:16
    • 90: Hiding Slides 01:42
    • 91: Changing the Order of Slides 01:50
    • 92: Copying Slides 02:10

    • 93: Word 2021: Introduction Overview of MS Word 03:57
    • 94: Start MS Word 2021 04:48
    • 95: Word 2021: Basics Create a new blank document 04:20
    • 96: Creating a paragraph text 04:55
    • 97: Non-printing characters 02:59
    • 98: Save a document 02:45
    • 99: Open a document 01:22
    • 100: Find and replace 03:50
    • 101: Word 2021: Word Formatting AutoCorrect options 02:54
    • 102: Formatting text 03:59
    • 103: Copy cut and paste 03:50
    • 104: Character formatting 02:28
    • 105: Format painter 03:58
    • 106: Work with numbers 01:43
    • 107: Add bullets 02:46
    • 108: Outline creation 03:42
    • 109: Word 2021: Tables Creating a table 02:30
    • 110: Adding rows and columns to a table 02:10
    • 111: Formatting table data 02:19
    • 112: Borders and shading 01:45
    • 113: Sorting in a table 03:41
    • 114: Draw a table 03:31
    • 115: Convert text to table 02:43
    • 116: Convert table to text 02:05
    • 117: Insert a spreadsheet 01:41
    • 118: Quick tables – readily available formats 01:52
    • 119: Word 2021: Styles Working with styles 01:54
    • 120: Creating styles 01:50
    • 121: Clear formatting 01:16
    • 122: Word 2021: Page Layout 01:44
    • 123: Orientation 01:23
    • 124: Page size setting 00:57
    • 125: Adding columns 03:24
    • 126: Page break – section break 01:37
    • 127: Adding watermark 02:58
    • 128: Headers and footers 02:41
    • 129: Word 2021: Envelops and Labels Create envelops 02:28
    • 130: Creating labels 01:58
    • 131: Word 2021: Mail Merges Creating a mail merge document 03:19
    • 132: Word 2021: Review and Printing Thesaurus and spell check 01:09
    • 133: Word count 01:21
    • 134: Speech - read aloud 00:58
    • 135: Language - translate 01:13
    • 136: Tracking 01:10

    • 137: Congratulations! 01:00 PDF
    • 138: Get an Accredited Certificate for Each Course 01:00 PDF

Course media

Description

Introduction to Microsoft Office 365

  1. Getting Started
    1. Introduction
    2. Getting started on Windows, macOS, and Linux
    3. How to ask great questions
    4. FAQ’s

Basics of Excel

  1. Excel 2021: Basics
    1. Excel Overview
    2. Start Excel Spreadsheet
    3. Enter Text and Numbers
    4. Relative References
    5. Working with ranges
    6. Save and Save as Actions
    7. File Extensions, Share, Export, and Publish files
  1. Excel 2021: Rows, Columns, and Cells
    1. Adding Rows and Columns
    2. Modifying Rows and Column lengths
  2. Excel 2021: Data Handling
    1. Copy, Cut, and Paste
    2. Copying Formulas
  3. Excel 2021: Page Setting Up and Print
    1. Page setup options
    2. Fit to print on One Page
    3. Print Workbooks
  4. Excel 2021: Sorting and Filtering
    1. Sorting Data Ascending Order
    2. Sorting Data Descending Order
    3. Filter Data

Excel 2021 Advanced

  1. Excel 2021: Writing Formulas
    1. Creating Basic Formulas
    2. Datetime Formulas
    3. Mathematical formulas phase1
    4. Mathematical formulas phase2
  2. Excel 2021: Advanced Formulas
    1. VLOOKUP formula
    2. HLOOKUP formula
  3. Excel 2021: XLOOKUP only for 2021 and Office 365
    1. XLOOKUP
    2. Handling #NA and Approximates match in XLOOKUP
  4. Excel 2021: Data and Tools
    1. Split Text into columns
    2. Flash Fill
    3. Data Validation
    4. Remove Duplicates
    5. Import Data from Text files
    6. Import Data from .CSV files
  5. Excel 2021: Formatting data and tables
    1. Formatting Font
    2. Formatting Alignment
    3. Formatting Numbers
    4. Formatting Date
    5. Formatting Tables
  6. Excel 2021: Pivot Tables
    1. Pivot Tables
    2. Pivot Charts
  7. Excel 2021: Charts
    1. Excel Charts – Categories
    2. Elements of a chart
    3. Creating Charts
    4. Column or Bar charts
    5. Formatting charts
    6. Line Charts
    7. Pie and Doughnut charts

Basics of Powerpoint

  1. PowerPoint 2021: Course Introduction
    1. Overview
    2. Start PowerPoint Presentation
    3. Screen setting and Views
  2. PowerPoint 2021: Basics
    1. Presentation Tips and Guidelines
    2. Creating a New Presentation
    3. Working with Slides
    4. Save a Presentation
    5. Print Slides
  3. PowerPoint 2021: Text and Bullet Options
    1. Formatting Text
    2. Slide Text Alignments
    3. Multi-Column Text Alignments
    4. Adding Bullets and Numbered List Items
  4. PowerPoint 2021: Adding Graphic Assets
    1. Insert Shapes
    2. Insert Icons
    3. Insert Graphics
    4. Add 3D Models
    5. Insert Pictures

Advanced Powerpoint Training

  1. PowerPoint 2021: Picture Formatting
    1. Picture Options
    2. Picture Cropping
    3. Applying Built-in Picture Styles
  1. PowerPoint 2021: SmartArt Graphics
    1. Add SmartArt Graphic
    2. Modifying SmartArt
    3. Creating a Target Chart using SmartArt
  2. PowerPoint 2021: Working with Tables
    1. Create a Table on Slide
    2. Formatting Tables
    3. Inserting Tables
    4. Table Layouts
  3. PowerPoint 2021: Working with Charts
    1. Add a Chart
    2. Formatting Charts
    3. Insert Chart from Microsoft Excel
  4. PowerPoint 2021: Adding Multimedia
    1. Adding Video to a Presentation
    2. Adding Audio to a Presentation
    3. Screen Recording and Adding
  5. PowerPoint 2021: Working with Transition
    1. Applying Transitions to Presentation
  6. PowerPoint 2021: Animation
    1. Object Animation
    2. Effect Options
    3. Advanced Animation
    4. Triggers to control animation
  7. PowerPoint 2021: Slideshow Effects
    1. Onscreen Presentation
    2. Hiding Slides
    3. Changing the Order of Slides
    4. Copying Slides

Microsoft Word: Basics to Advanced

  1. Word 2021: Introduction
    1. Overview of MS Word
    2. Start MS Word 2021
  2. Word 2021: Basics
    1. Create a new blank document
    2. Creating a paragraph text
    3. Non-printing characters
    4. Save a document
    5. Open a document
    6. Find and replace
  3. Word 2021: Word Formatting
    1. AutoCorrect options
    2. Formatting text
    3. Copy cut and paste
    4. Character formatting
    5. Format painter
    6. Work with numbers
    7. Add bullets
    8. Outline creation
  4. Word 2021: Tables
    1. Creating a table
    2. Adding rows and columns to a table
    3. Formatting table data
    4. Borders and shading
    5. Sorting in a table
    6. Draw a table
    7. Convert text to table
    8. Convert table to text
    9. Insert a spreadsheet
    10. Quick tables – readily available formats
  5. Word 2021: Styles
    1. Working with styles
    2. Creating styles
    3. Clear formatting
  6. Word 2021: Page Layout
    1. Margins
    2. Orientation
    3. Page size setting
    4. Adding columns
    5. Page break – section break
    6. Adding watermark
    7. Headers and footers
  7. Word 2021: Envelops and Labels
    1. Create envelops
    2. Creating labels
  8. Word 2021: Mail Merges
    1. Creating a mail merge document
  1. Word 2021: Review and Printing
    1. Thesaurus and spell check
    2. Word count
    3. Speech - read aloud
    4. Language - translate
    5. Tracking

Who is this course for?

The "Mastering Microsoft Office: Word, Excel, PowerPoint, and 365" course is generally aimed at a broad audience, including:

  • Beginners
  • Intermediate Users
  • Professionals
  • Students
  • Job Seekers
  • Anyone Interested in Efficiency
  • Small Business Owners
  • Project Managers
  • Administrative Assistants
  • Freelancers
  • Educators
  • Remote Workers

Requirements

There is no prerequisite for this course. Don’t worry—we will teach you everything step by step.

Career path

Here are job positions relevant to the course:

  • Administrative Assistant
  • Executive Assistant
  • Project Manager
  • Data Analyst
  • Marketing Coordinator
  • Sales Representative
  • Financial Analyst
  • Human Resources Professional
  • IT Support Specialist
  • Customer Service Representative
  • Small Business Owner
  • Freelance Consultant
  • Remote Worker

Questions and answers

No questions or answers found containing ''.

Justine asked:

Do I need Microsoft os for this course or can it be done on Android?

Answer:

This course can be accessed and completed from any device, be it Microsoft os, Mac os, or Android. However, you will need access to software like Microsoft Word, Excel, and PowerPoint to practice what you have learned from the course.

This was helpful. Thank you for your feedback.
asked:

Is this suitable for dyslexic students? What kind of support would they receive?

Answer:

Yes, the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course is suitable for dyslexic students. It offers self-paced learning, video tutorials, and accessible materials. 24/7 Tutor Support is available for any extended help if needed.

This was helpful. Thank you for your feedback.
Sarah asked:

I currently only have office 365. Would I be required to purchase Office 2021 to complete this course?

Answer:

No. Office 365 is enough to be able to complete this course.

This was helpful. Thank you for your feedback.
Ask a question

Reviews

1.5
Course rating
30%
Service
40%
Content
20%
Value

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 Excel courses, Microsoft Office 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 2025. All rights reserved.