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

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

Course Overview

Become a trained professional from the safety and comfort of your own home by taking Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time. 

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.  

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties. 

By completing Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up. 

Course Benefits

Will I receive a certificate of completion?

After successfully completing this course, you will qualify for the CPD Certificate from One Education as proof of your continued expert development. Certificate is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.

Why Study This Course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

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:06:00
Start Excel Spreadsheet 00:04:00
Enter Text and Numbers 00:07:00
Relative References 00:04:00
Working with ranges 00:07: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:03:00
Formatting Tables 00:06: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:06: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:02:00
Section 25: PowerPoint 2021: Slideshow Effects
Onscreen Presentation 00:02:00
Hiding Slides 00:02:00
Changing Order of Slides 00:02: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
Order Your Certificate
Order Your Certificate Now 00:00:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon