Booking options
£11.99
£11.99
On-Demand course
8 hours 20 minutes
Intermediate level
Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace.
You Will Learn Following Things:
Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365.
Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas.
Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics.
Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges.
Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making.
This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever.
Perks of Learning with IOMH
One-to-one support from a dedicated tutor throughout your course.
Study online - whenever and wherever you want.
Instant Digital/ PDF certificate
100% money back guarantee
12 months access
This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever.
Process of Evaluation
After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate.
Certificate of Achievement
After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International).
Who Is This Course for?
This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite.
On the other hand, anyone who wants to establish their career as: like
MS Office User
Microsoft Office 2019 User
Touch Typing Worker
Audio Typist
Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course.
Requirements
There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course.
Do note: you must be at least 16 years old to enrol.
Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course.
Career path
Administrative Assistant - £20K to £30K/year
Data Analyst - £25K to £45K/year
Office Manager - £25K to £40K/year
Project Coordinator - £25K to £35K/year
Marketing Assistant - £20K to £30K/year
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:07:00 | ||
Save and Save as Actions | 00:08:00 | ||
File Extensions, Share, Export, and Publish files | 00:06:00 | ||
Section 03: Excel 2021: Rows, Columns, and Cells | |||
Adding Rows and Columns | 00:03:00 | ||
Modifying Rows and Column lengths | 00:05: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:06: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:06: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: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: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 |