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:
Enhance your profile with a CPD-accredited certificate, available for an additional cost after course completion.
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
No Reviews found for this course.