• LOGIN
  • No products in the basket.

Login

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

In today’s digital world, proficiency in Microsoft Office is no longer a bonus, it’s essential. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course is designed for anyone who wants to elevate their productivity and unlock the full potential of Microsoft Office. Whether you’re a student, professional, entrepreneur, or stay-at-home parent, mastering these applications will equip you with the skills to excel in your chosen field.

Our interactive course structure provides clear explanations, and step-by-step guides to help your learning journey. Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is your gateway to a world of opportunity. Enrol today and take your productivity to the next level!

Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:

  • Master data analysis: Learn foundational and advanced formulas in Excel 2021, including VLOOKUP, HLOOKUP, and XLOOKUP, to manipulate and analyse data efficiently.
  • Craft compelling presentations: Gain expertise in designing impactful presentations using PowerPoint 2021. Explore elements like transitions, animations, and multimedia integration to engage your audience.
  • Produce professional documents: Develop proficiency in Word 2021 to create polished and error-free documents. Master formatting, layout, and styles to enhance readability and professionalism.
  • Navigate across platforms: Learn how to leverage the core functionalities of Microsoft Office 365 on Windows, macOS, and Linux operating systems, ensuring seamless workflow across devices.
  • Embrace collaboration: Explore the collaborative features of Microsoft Office 365 to share documents, presentations, and spreadsheets with colleagues in real-time, fostering efficient teamwork.
  • Boost efficiency: Discover time-saving techniques across all applications in Microsoft Office 365, including keyboard shortcuts, data validation tools, and automation features.

Who is This Course For:

  • Students seeking to enhance their employability.
  • Professionals looking to advance their careers.
  • Individuals who want to improve their efficiency and organisation.
  • Anyone who wants to confidently navigate the Microsoft Office suite.

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

CPD QS certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for printed hardcopy format, and £24.99 for both PDF and hard copy certificates.

Requirements:

This course does not have academic entry requirements and is open to students of all backgrounds.

Career Paths:

  • Administrative Assistant: £20,000 – £28,000
  • Business Analyst: £30,000 – £45,000
  • Marketing Executive: £25,000 – £38,000
  • Customer Service Representative: £18,000 – £25,000
  • Project Manager: £35,000 – £50,000
  • Data Analyst: £28,000 – £42,000
  • And Many More!

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

Course Reviews

N.A

0
0 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE OR ALL COURSES FOR £69.99
  • £24.99
  • 1 year
  • Course Certificate
  • Number of Units135
  • Number of Quizzes0
  • 8 hours, 20 minutes
0 STUDENTS ENROLLED