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

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