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.
A major highlight of Excel 2021 is the introduction of XLOOKUP, a powerful tool for data lookup, which is only available for 2021 and Office 365 versions. You’ll also cover Data and Tools, Formatting Data and Tables, and Pivot Tables, enabling you to manage large data sets efficiently. The section concludes with Charts, where you will learn to visualize data with professional charts, ensuring that your presentations are both informative and visually appealing.
Next, the course transitions to PowerPoint 2021, where you will begin with an Introduction and then explore the basics of creating slides. The course covers Text and Bullet Options, guiding you on how to format text for impact. You’ll also learn how to add Graphic Assets, Picture Formatting, and SmartArt Graphics to make your presentations more engaging. Further, you’ll explore working with Tables and Charts in PowerPoint, learn to add Multimedia, and understand Transitions and Animations. By the end of the PowerPoint section, you will be equipped to create professional and dynamic presentations that leave a lasting impression.
The course concludes with the Word 2021 section, where you’ll learn the basics of Word Formatting and working with Tables. You will discover how to use Styles to maintain consistency in your documents and master Page Layout for effective document design. The course also covers Envelopes and Labels, Mail Merges, and Review and Printing, making you proficient in document creation, editing, and printing.
With each section, you’ll gain practical skills that can be applied immediately, from managing data in Excel to creating impactful presentations in PowerPoint and writing professional documents in Word. The course concludes with the option to Order Your Transcript, allowing you to showcase your new skills.
By the end of the Mastering Microsoft Office 2021 course, you will be confident in using Excel, PowerPoint, and Word, enabling you to work efficiently and effectively with Microsoft Office 2021 in any professional or personal setting.
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
Getting Started
- Introduction
- Getting started on Windows macOS and Linux
- How to ask great questions
- FAQs
Excel 2021: Basics
- 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
- Adding Rows and Columns
- Modifying Rows and Column lengths
- Care for a Feedback
Excel 2021: Data Handling
- Copy Cut and Paste
- Copying Formulas
Excel 2021: Page Setting Up and print
- Page setup options
- Fit to print on One Page
- Print Workbooks
Excel 2021: Sorting and Filtering
- Sorting Data Ascending Order
- Sorting Data Descending Order
- Filter Data
Excel 2021: Writing Formulas
- Basic formula operations
- Date time functions
- Mathematical functions phase 1
- Mathematical functions phase 2
Excel 2021: Advanced Formulas
- VLookup formula
- HLookup formula
Excel 2021: XLOOKUP Only for 2021 and Office 365
- XLookup
- Handling NA and Approximates match in XLookup
Excel 2021: Data and Tools
- 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
- Formatting Font
- Formatting Alignment
- Formatting Number
- Formatting Date
- Formatting tables
Excel 2021: Pivot Tables
- Creating Pivot Table
- Pivot charts
Excel 2021: Charts
- Excel Charts – Categories
- Elements of a chart
- Creating charts
- Column or Bar charts
- Formatting charts
- Line charts
- Pie and Doughnut charts
PowerPoint 2021: Introduction
- Overview
- Start PowerPoint Presentation
- Screen setting and Views
PowerPoint 2021: Basics
- Presentation Tips and Guidelines
- Creating a New Presentation
- Working with Slides
- Save a Presentation
- Print Slides
PowerPoint 2021: Text and Bullet Options
- Formatting Text
- Slide Text Alignments
- Multi-Column Text Alignments
- Adding Bullets and Numbered List Items
PowerPoint 2021: Adding Graphic Assets
- Insert Shapes
- Insert Icons
- Insert Graphics
- Add 3D Models
- Insert Pictures
PowerPoint 2021: Picture Formatting
- Picture Options
- Picture Cropping
- Applying Built-in Picture Styles
PowerPoint 2021: SmartArt Graphics
- Add SmartArt Graphic
- Modifying SmartArt
- Creating a Target Chart using SmartArt
PowerPoint 2021: Working with Tables
- Create a Table on Slide
- Formatting Tables
- Inserting Tables
- Table Layouts
PowerPoint 2021: Working with Charts
- Add a Chart
- Formatting Charts
- Insert Chart from Microsoft Excel
PowerPoint 2021: Adding Multimedia
- Adding Video to a Presentation
- Adding Audio to a Presentation
- Screen Recording and Adding
PowerPoint 2021: Working with Transition
- Applying Transitions to Presentation
PowerPoint 2021: Animation
- Object Animation
- Effect Options
- Advanced Animation
- Triggers to control animation
PowerPoint 2021: Slideshow Affects
- Onscreen Presentation
- Hiding Slides
- Copying Slides
- Changing Order of Slides
Word 2021: Introduction
- Overview of MS Word
- Start MS Word 2021
Word 2021: Basics
- 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
- AutoCorrect Options
- Formatting Text
- Copy Cut and Paste
- Character Formatting
- Format Painter
- Work with Numbers
- Add Bullets
- Outline Creation
Word 2021: Tables
- 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
- Working with Styles
- Creating Styles
- Clear Formatting
Word 2021: Page Layout
- Margins
- Orientation
- Page size setting
- Adding columns
- Page break section break
- Adding watermark
- Headers and footers
Word 2021: Envelops and Levels
- Create envelops
- Creating labels
Word 2021: Mail Merges
- Creating a mail merge document
Word 2021: Review and Printing
- Thesaurus and spell check
- Word count
- Speech – read aloud
- Language – translate
- Tracking
Order Your Transcript
- Order Your Transcript
How the course works
-
Get access
After payment, the course appears in your LearnDrive dashboard.
-
Learn at your pace
Work through 137 short video lessons in one sitting or several.
-
Complete the assessment
Attend the assessment and secure 70% to pass the assessment test.
-
Get your documents
Download the PDF document(s) included in your package.
Certificate and accreditation
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 LearnDriveReviews
Reviews for this course
Reviews appear here when learners who completed this course leave one.
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.
