• LOGIN
  • No products in the basket.

Get Lifetime Access to This Course & 1900+ Others for Only £149. Subscribe Now

Course Overview

Learn how to make a genuine difference in your life by taking our popular Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Our commitment to online learning and our technical experience have been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 to a whole new level and quickly reap the rewards of your study in the field you have chosen.

We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.

Please note that Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.

Learning Outcomes

  • Instant access to verified and reliable information
  • Participation in inventive and interactive training exercises
  • Quick assessment and guidance for all subjects
  • CPD accreditation for proof of acquired skills and knowledge
  • Freedom to study in any location and at a pace that suits you
  • Expert support from dedicated tutors committed to online learning

Your Path to Success

By completing the training in Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, you will be able to significantly demonstrate your acquired abilities and knowledge of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. This can give you an advantage in career progression, job applications, and personal mastery in this area.

Is This Course Right for You?

This course is designed to provide an introduction to Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.

Assessment Process

Once you have completed all the modules in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

Show off Your New Skills with a Certification of Completion

The learners have to successfully complete the assessment of this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course to achieve the CPD & IAO accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.

Course Curriculum

Section 01: Getting Started
Introduction 00:03:00
Getting started on Windows, macOS, and Linux 00:01:00
How to ask great questions 00:01:00
FAQ’s 00:01:00
Section 02: Excel 2021: Basics
Excel Overview 00:05:00
Start Excel Spreadsheet 00:04:00
Enter Text and Numbers 00:07:00
Relative References 00:04:00
Working with ranges 00:06:00
Save and Save as Actions 00:08:00
File Extensions, Share, Export, and Publish files 00:07:00
Section 03: Excel 2021: Rows, Columns, and Cells
Adding Rows and Columns 00:03:00
Modifying Rows and Column lengths 00:06:00
Section 04: Excel 2021: Data Handling
Copy, Cut, and Paste 00:07:00
Copying Formulas 00:03:00
Section 05: Excel 2021: Page Setting Up and Print
Page setup options 00:07:00
Fit to print on One Page 00:03:00
Print Workbooks 00:03:00
Section 06: Excel 2021: Sorting and Filtering
Sorting Data Ascending Order 00:04:00
Sorting Data Descending Order 00:02:00
Filter Data 00:04:00
Section 07: Excel 2021: Writing Formulas
Creating Basic Formulas 00:06:00
Datetime Formulas 00:06:00
Mathematical formulas phase1 00:20:00
Mathematical formulas phase2 00:12:00
Section 08: Excel 2021: Advanced Formulas
VLOOKUP formula 00:12:00
HLOOKUP formula 00:04:00
Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365
XLOOKUP 00:08:00
Handling #NA and Approximates match in XLOOKUP 00:11:00
Section 10: Excel 2021: Data and Tools
Split Text into columns 00:07:00
Flash Fill 00:07:00
Data Validation 00:07:00
Remove Duplicates 00:08:00
Import Data from Text files 00:07:00
Import Data from .CSV files 00:03:00
Section 11: Excel 2021: Formatting data and tables
Formatting Font 00:04:00
Formatting Alignment 00:06:00
Formatting Numbers 00:05:00
Formatting Date 00:04:00
Formatting Tables 00:05:00
Section 12: Excel 2021: Pivot Tables
Pivot Tables 00:07:00
Pivot Charts 00:02:00
Section 13: Excel 2021: Charts
Excel Charts – Categories 00:03:00
Elements of a chart 00:04:00
Creating Charts 00:02:00
Column or Bar charts 00:04:00
Formatting charts 00:04:00
Line Charts 00:02:00
Pie and Doughnut charts 00:04:00
Section 14: PowerPoint 2021: Course Introduction
Overview 00:04:00
Start PowerPoint Presentation 00:05:00
Screen setting and Views 00:05:00
Section 15: PowerPoint 2021: Basics
Presentation Tips and Guidelines 00:06:00
Creating a New Presentation 00:04:00
Working with Slides 00:04:00
Save a Presentation 00:04:00
Print Slides 00:03:00
Section 16: PowerPoint 2021: Text and Bullet Options
Formatting Text 00:05:00
Slide Text Alignments 00:03:00
Multi-Column Text Alignments 00:02:00
Adding Bullets and Numbered List Items 00:03:00
Section 17: PowerPoint 2021: Adding Graphic Assets
Insert Shapes 00:03:00
Insert Icons 00:03:00
Insert Graphics 00:04:00
Add 3D Models 00:03:00
Insert Pictures 00:03:00
Section 18: PowerPoint 2021: Picture Formatting
Picture Options 00:04:00
Picture Cropping 00:03:00
Applying Built-in Picture Styles 00:04:00
Section 19: PowerPoint 2021: SmartArt Graphics
Add SmartArt Graphic 00:03:00
Modifying SmartArt 00:03:00
Creating a Target Chart using SmartArt 00:03:00
Section 20: PowerPoint 2021: Working with Tables
Create a Table on Slide 00:04:00
Formatting Tables 00:02:00
Inserting Tables 00:02:00
Table Layouts 00:01:00
Section 21: PowerPoint 2021: Working with Charts
Add a Chart 00:02:00
Formatting Charts 00:02:00
Insert Chart from Microsoft Excel 00:03:00
Section 22: PowerPoint 2021: Adding Multimedia
Adding Video to a Presentation 00:03:00
Adding Audio to a Presentation 00:02:00
Screen Recording and Adding 00:02:00
Section 23: PowerPoint 2021: Working with Transition
Applying Transitions to Presentation 00:04:00
Section 24: PowerPoint 2021: Animation
Object Animation 00:03:00
Effect Options 00:02:00
Advanced Animation 00:02:00
Triggers to control animation 00:00:00
Section 25: PowerPoint 2021: Slideshow Effects
Onscreen Presentation 00:02:00
Hiding Slides 00:02:00
Changing Order of Slides 00:00:00
Copying Slides 00:02:00
Section 26: Word 2021: Introduction
Overview of MS Word 00:04:00
Start MS Word 2021 00:05:00
Section 27: Word 2021: Basics
Create a new blank document 00:04:00
Creating a paragraph text 00:05:00
Non-printing characters 00:03:00
Save a document 00:03:00
Open a document 00:01:00
Find and replace 00:04:00
Section 28: Word 2021: Word Formatting
AutoCorrect options 00:03:00
Formatting text 00:04:00
Copy cut and paste 00:04:00
Character formatting 00:02:00
Format painter 00:04:00
Work with numbers 00:02:00
Add bullets 00:03:00
Outline creation 00:04:00
Section 29: Word 2021: Tables
Creating a table 00:03:00
Adding rows and columns to a table 00:02:00
Formatting table data 00:02:00
Borders and shading 00:02:00
Sorting in a table 00:04:00
Draw a table 00:04:00
Convert text to table 00:03:00
Convert table to text 00:02:00
Insert a spreadsheet 00:02:00
Quick tables – readily available formats 00:02:00
Section 30: Word 2021: Styles
Working with styles 00:02:00
Creating styles 00:02:00
Clear formatting 00:01:00
Section 31: Word 2021: Page Layout
Margins 00:02:00
Orientation 00:01:00
Page size setting 00:01:00
Adding columns 00:03:00
Page break – section break 00:02:00
Adding watermark 00:03:00
Headers and footers 00:03:00
Section 32: Word 2021: Envelops and Lables
Create envelops 00:02:00
Creating labels 00:02:00
Section 33: Word 2021: Mail Merges
Creating a mail merge document 00:03:00
Section 34: Word 2021: Review and Printing
Thesaurus and spell check 00:01:00
Word count 00:01:00
Speech – read aloud 00:01:00
Language – translate 00:01:00
Tracking 00:01:00
Review

COURSE REVIEWS

£25.00 TAKE THIS COURSE

COPYRIGHT © 2023 - ACADEMY FOR HEALTH & FITNESS TRADING AS MAYFAIR COLLEGE LTD (Company number 12389626). ALL RIGHTS RESERVED.