Overview
With our in-depth course, “Mastering Microsoft Office: Word, Excel, PowerPoint, and 365,” take a revolutionary trip into the core of Microsoft Office competence. Embark on a transformative journey into the heart of Microsoft Office proficiency with our comprehensive course: “Mastering Microsoft Office: Word, Excel, PowerPoint, and 365″. In today’s digital landscape, competence in Office applications isn’t just an asset; it’s a necessity. This course isn’t just about learning; it’s about empowerment. From the foundational essentials to advanced techniques, each module is meticulously crafted to unlock your potential and propel you towards mastery. Delve into the intricacies of Excel 2021, navigate the dynamic realm of PowerPoint 2021, and harness the versatility of Word 2021. With a blend of theory and hands-on practice, this course transcends traditional learning, fostering an environment where innovation thrives and expertise flourishes. Join us on this exhilarating voyage as we redefine the boundaries of possibility within the Microsoft Office suite.
How will I get my certificate?
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
Who is This course for?
- Professionals seeking to enhance their Microsoft Office skills for career advancement.
- Students aiming to bolster their employability and academic performance.
- Small business owners looking to optimize productivity and streamline operations.
- Individuals transitioning into roles that require proficiency in Office applications.
- Freelancers and entrepreneurs seeking to enhance their digital skill set.
Requirements
Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.
There is no time limit for completing this course, it can be studied in your own time at your own pace.
Career Path
Having this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 expertise will increase the value of your CV and open you up to multiple job sectors:
Office Administrator: £20,000 – £25,000
Data Analyst: £25,000 – £35,000
Project Coordinator: £25,000 – £30,000
Marketing Assistant: £18,000 – £23,000
Executive Assistant: £22,000 – £28,000
Business Development Executive: £25,000 – £35,000
Course Curriculum
- 34 sections
- 135 lectures
- 8 hours, 20 minutes total length
-
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
-
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
-
Adding Rows and Columns 00:03:00
-
Modifying Rows and Column lengths 00:05:00
-
Copy, Cut, and Paste 00:07:00
-
Copying Formulas 00:03:00
-
Page setup options 00:06:00
-
Fit to print on One Page 00:03:00
-
Print Workbooks 00:03:00
-
Sorting Data Ascending Order 00:04:00
-
Sorting Data Descending Order 00:02:00
-
Filter Data 00:04:00
-
Creating Basic Formulas 00:06:00
-
Datetime Formulas 00:06:00
-
Mathematical formulas phase1 00:20:00
-
Mathematical formulas phase2 00:12:00
-
VLOOKUP formula 00:12:00
-
HLOOKUP formula 00:04:00
-
XLOOKUP 00:08:00
-
Handling #NA and Approximates match in XLOOKUP 00:11:00
-
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
-
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
-
Pivot Tables 00:07:00
-
Pivot Charts 00:02:00
-
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
-
Overview 00:04:00
-
Start PowerPoint Presentation 00:05:00
-
Screen setting and Views 00:05:00
-
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
-
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
-
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
-
Picture Options 00:04:00
-
Picture Cropping 00:03:00
-
Applying Built-in Picture Styles 00:04:00
-
Add SmartArt Graphic 00:03:00
-
Modifying SmartArt 00:03:00
-
Creating a Target Chart using SmartArt 00:03:00
-
Create a Table on Slide 00:04:00
-
Formatting Tables 00:02:00
-
Inserting Tables 00:02:00
-
Table Layouts 00:01:00
-
Add a Chart 00:02:00
-
Formatting Charts 00:02:00
-
Insert Chart from Microsoft Excel 00:03:00
-
Adding Video to a Presentation 00:03:00
-
Adding Audio to a Presentation 00:02:00
-
Screen Recording and Adding 00:02:00
-
Applying Transitions to Presentation 00:04:00
-
Object Animation 00:03:00
-
Effect Options 00:02:00
-
Advanced Animation 00:02:00
-
Triggers to control animation 00:02:00
-
Onscreen Presentation 00:02:00
-
Hiding Slides 00:02:00
-
Changing Order of Slides 00:02:00
-
Copying Slides 00:02:00
-
Overview of MS Word 00:04:00
-
Start MS Word 2021 00:05:00
-
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
-
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
-
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
-
Working with styles 00:02:00
-
Creating styles 00:02:00
-
Clear formatting 00:01:00
-
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
-
Create envelops 00:02:00
-
Creating labels 00:02:00
-
Creating a mail merge document 00:03:00
-
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
Frequently Bought Together
4.8 course rating - 15 reviews
£19.99
£419
This course includes:
-
Duration:8 hours, 20 minutes
-
Access:1 year access
-
Units:135
-
Level:Advanced
-
CPD Points:10
-
Certificate:Yes
