Office Skill

Microsoft Office Suite: Office 365 – Excel, Powerpoint & Word

Master Microsoft Office 2021 with comprehensive training in Excel, PowerPoint, and Word. Learn everything from formulas and data handling to presentations and document formatting. Perfect for professionals and beginners alike.

Learning time
137 lessons
Format
Online, self-paced
Short video lessons
Access period
Lifetime
Last audited
18th November 2026
Accreditation CPDQE-accredited CPD course

Overview

The Mastering Microsoft Office 2021 course is designed to equip learners with in-depth knowledge and practical skills in Microsoft Office applications, including Excel, PowerPoint, and Word. This comprehensive course is ideal for anyone looking to enhance their skills in Microsoft Office, whether you're a beginner or an intermediate user aiming to refine your abilities for personal or professional use.

The course begins with a Getting Started section, introducing you to the layout and features of Microsoft Office 2021. From there, you will dive into Excel 2021, where you will start by learning the basics, such as navigating rows, columns, and cells. You’ll explore Data Handling, which includes tasks like data entry and organization, and learn how to set up pages and print from Excel. The course also covers advanced techniques, such as Sorting and Filtering, Writing Formulas, and Advanced Formulas, equipping you with the tools to manipulate and analyze data effectively.

What you'll learn

  • Understand the layout and functions of Microsoft Office 2021, including the essential tools for Excel, PowerPoint, and Word.
  • Gain proficiency in Excel for data entry, organising data, and performing calculations using formulas and functions.
  • Learn to handle large data sets in Excel, using sorting, filtering, and advanced tools like XLOOKUP and Pivot Tables.
  • Master Excel’s charting tools to create visually appealing and informative data visualisations.
  • Develop skills in creating professional PowerPoint presentations, including text formatting, graphic assets, and multimedia.
  • Learn how to add Transitions and Animations in PowerPoint for engaging and dynamic presentations.
  • Create and format documents effectively in Word, using features such as Styles, Tables, and Page Layout.
  • Understand Mail Merges, Envelopes, and Labels in Word for efficient document creation.
  • Enhance your ability to work with data in Word, Excel, and PowerPoint, improving overall productivity.
  • Apply the knowledge gained from this course to complete real-world tasks and professional projects effectively.

Suitable for

Who it's for

  • Aspiring professionals who wish to enhance their skills in Microsoft Office 2021.
  • Students and employees who require advanced Excel, PowerPoint, and Word skills for their career development.
  • Small business owners or entrepreneurs looking to improve their office software skills for efficiency.
  • HR professionals who need to create, manage, and present data and documents using Microsoft Office tools.
  • Educators who want to design high-quality lessons, presentations, and administrative documents.
  • Freelancers who want to use Microsoft Office for creating and managing professional client documents and reports.
  • Anyone interested in mastering Microsoft Office to become more efficient in their personal or professional tasks.

Helpful to know

  • No prior knowledge of Microsoft Office is required, although familiarity with basic computer operations is helpful.
  • A computer with Microsoft Office 2021 installed is recommended for optimal learning.

You will need

  • An internet connection is needed to access the course content and interactive materials.
  • A device with an internet connection

Course content

137 lessons

Getting Started 4 lessons
  • Introduction
  • Getting started on Windows macOS and Linux
  • How to ask great questions
  • FAQs
Excel 2021: Basics 7 lessons
  • Excel Overview
  • Start Excel Spreadsheet
  • Enter Text and Numbers
  • Relative References
  • Working with ranges
  • Save and Save as Actions
  • File Extensions, Share, Export, and Publish files
Excel 2021: Row, Columns, and Cells 3 lessons
  • Adding Rows and Columns
  • Modifying Rows and Column lengths
  • Care for a Feedback
Excel 2021: Data Handling 2 lessons
  • Copy Cut and Paste
  • Copying Formulas
Excel 2021: Page Setting Up and print 3 lessons
  • Page setup options
  • Fit to print on One Page
  • Print Workbooks
Excel 2021: Sorting and Filtering 3 lessons
  • Sorting Data Ascending Order
  • Sorting Data Descending Order
  • Filter Data
Excel 2021: Writing Formulas 4 lessons
  • Basic formula operations
  • Date time functions
  • Mathematical functions phase 1
  • Mathematical functions phase 2
Excel 2021: Advanced Formulas 2 lessons
  • VLookup formula
  • HLookup formula
Excel 2021: XLOOKUP Only for 2021 and Office 365 2 lessons
  • XLookup
  • Handling NA and Approximates match in XLookup
Excel 2021: Data and Tools 6 lessons
  • Split Text into columns
  • Flash Fill
  • Data Validation
  • Remove Duplicates
  • Import Data from Text files
  • Import Data from .CSV files
Excel 2021: Formatting Data and Tables 5 lessons
  • Formatting Font
  • Formatting Alignment
  • Formatting Number
  • Formatting Date
  • Formatting tables
Excel 2021: Pivot Tables 2 lessons
  • Creating Pivot Table
  • Pivot charts
Excel 2021: Charts 7 lessons
  • Excel Charts – Categories
  • Elements of a chart
  • Creating charts
  • Column or Bar charts
  • Formatting charts
  • Line charts
  • Pie and Doughnut charts
PowerPoint 2021: Introduction 3 lessons
  • Overview
  • Start PowerPoint Presentation
  • Screen setting and Views
PowerPoint 2021: Basics 5 lessons
  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Save a Presentation
  • Print Slides
PowerPoint 2021: Text and Bullet Options 4 lessons
  • Formatting Text
  • Slide Text Alignments
  • Multi-Column Text Alignments
  • Adding Bullets and Numbered List Items
PowerPoint 2021: Adding Graphic Assets 5 lessons
  • Insert Shapes
  • Insert Icons
  • Insert Graphics
  • Add 3D Models
  • Insert Pictures
PowerPoint 2021: Picture Formatting 3 lessons
  • Picture Options
  • Picture Cropping
  • Applying Built-in Picture Styles
PowerPoint 2021: SmartArt Graphics 3 lessons
  • Add SmartArt Graphic
  • Modifying SmartArt
  • Creating a Target Chart using SmartArt
PowerPoint 2021: Working with Tables 4 lessons
  • Create a Table on Slide
  • Formatting Tables
  • Inserting Tables
  • Table Layouts
PowerPoint 2021: Working with Charts 3 lessons
  • Add a Chart
  • Formatting Charts
  • Insert Chart from Microsoft Excel
PowerPoint 2021: Adding Multimedia 3 lessons
  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Screen Recording and Adding
PowerPoint 2021: Working with Transition 1 lesson
  • Applying Transitions to Presentation
PowerPoint 2021: Animation 4 lessons
  • Object Animation
  • Effect Options
  • Advanced Animation
  • Triggers to control animation
PowerPoint 2021: Slideshow Affects 4 lessons
  • Onscreen Presentation
  • Hiding Slides
  • Copying Slides
  • Changing Order of Slides
Word 2021: Introduction 2 lessons
  • Overview of MS Word
  • Start MS Word 2021
Word 2021: Basics 6 lessons
  • Create a New Blank Document
  • Creating a Paragraph Text
  • Non-printing characters
  • Save a Document
  • Open a Document
  • Find and Replace
Word 2021: Word Formatting 8 lessons
  • AutoCorrect Options
  • Formatting Text
  • Copy Cut and Paste
  • Character Formatting
  • Format Painter
  • Work with Numbers
  • Add Bullets
  • Outline Creation
Word 2021: Tables 10 lessons
  • Creating a Table
  • Adding Rows and Columns to a table
  • Formatting Table Data
  • Borders and Shading
  • Sorting in a Table
  • Draw a Table
  • Convert Text to Table
  • Convert Table to Text
  • Insert a Spreadsheet
  • Quick Tables – Readily Available Formats
Word 2021: Styles 3 lessons
  • Working with Styles
  • Creating Styles
  • Clear Formatting
Word 2021: Page Layout 7 lessons
  • Margins
  • Orientation
  • Page size setting
  • Adding columns
  • Page break section break
  • Adding watermark
  • Headers and footers
Word 2021: Envelops and Levels 2 lessons
  • Create envelops
  • Creating labels
Word 2021: Mail Merges 1 lesson
  • Creating a mail merge document
Word 2021: Review and Printing 5 lessons
  • Thesaurus and spell check
  • Word count
  • Speech – read aloud
  • Language – translate
  • Tracking
Order Your Transcript 1 lesson
  • Order Your Transcript

How the course works

  1. Get access

    After payment, the course appears in your LearnDrive dashboard.

  2. Learn at your pace

    Work through 137 short video lessons in one sitting or several.

  3. Complete the assessment

    Attend the assessment and secure 70% to pass the assessment test.

  4. Get your documents

    Download the PDF document(s) included in your package.

Certificate and accreditation

Sample certificate

What you receive

A digital Certificate of Completion (PDF) for this CPDQE-accredited course.

What the accreditation means

CPDQE accredits this course for continuing professional development (CPD). CPD accreditation is not a regulated qualification and does not by itself confirm job competence.

Checking a certificate

Anyone can check a certificate code on the LearnDrive certificate verification page.

What each package includes

Document Package 1 · £9.99 Package 2 · £9.99
Course access Lifetime access Lifetime access
Certificate of Completion (PDF) Included Included
Transcript (PDF) Not included Included
Enrolment Letter (PDF) Not included Included

Course provider

LearnDrive Courses

LearnDrive is a UK-based online learning provider run by Edtech Learning Ltd. Courses are built by an in-house instructional design team using short video and audio modules.

About LearnDrive

Reviews

Reviews for this course

No reviews for this course yet

Reviews appear here when learners who completed this course leave one.

Reviews of LearnDrive

Rated 4.8/5 on Reed, Udemy & Google

See all LearnDrive reviews

Frequently asked questions

Is there a free version of Microsoft Office?


Yes, Microsoft offers free online versions of Word, Excel, and PowerPoint via Office.com with limited features.

How to get Microsoft Office for free in the UK?


You can use Office Online for free or access a free trial of Microsoft 365 from Microsoft’s official website.

How do I install Microsoft Office on my laptop for free?


Download Office Online apps for browser use, or use the free 1-month Microsoft 365 trial to install on your laptop.

How to get MS Office for free legally?


Use Office.com online apps, student/educational licenses, or Microsoft 365 free trial; avoid pirated copies.

Are old versions of Microsoft Office free?


No, older versions require a valid license to install and use legally.

Can I get Microsoft Office as a one-time purchase?


Yes, Microsoft Office Home & Student or Home & Business editions can be bought as a one-time purchase without subscription.

Can Microsoft Office be purchased outright?


Yes, certain editions like Office 2021 allow a permanent license instead of a subscription.

How much does Microsoft Office cost in the UK?


Office Home & Student 2021 is around £119.99, while Microsoft 365 Personal subscription costs £69.99/year.

Can I have Microsoft Office without a subscription?


Yes, the one-time purchase versions provide lifetime access to the core Office apps.

What is the difference between Microsoft Office and Office 365?


Microsoft Office refers to one-time purchase apps, while Office 365 (Microsoft 365) is subscription-based with cloud features and regular updates.

How to get Microsoft Office for free?


Use Office.com, download the free apps on mobile, or start a Microsoft 365 free trial.

What does the Microsoft Office consist of?


It includes Word, Excel, PowerPoint, Outlook, OneNote, Access (PC only), and Publisher (PC only).

What is included in the Microsoft Office package?


Core apps: Word, Excel, PowerPoint, Outlook; some editions also include OneNote, Access, and Publisher.

View all FAQs

Training a team?

LearnDrive offers training for businesses. Ask about options for enrolling your staff.

Team training enquiry

Taking several courses?

A LearnDrive membership includes access to the full course library.

Compare memberships

Ready to start Microsoft Office Suite: Office 365 – Excel, Powerpoint & Word?

Selected: Course Access + Certificate of Completion (PDF) · £9.99

Change package