• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

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

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

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 8 hours 20 minutes

  • Intermediate level

Description

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.

Details

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

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: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

About The Provider

Tags

Reviews