What you’ll learn

  • Learn the essential Microsoft Office Skills in these three courses: Word, Excel, and PowerPoint
  • How to use Microsoft Word to create, format, and edit documents
  • Learn to use Microsoft Excel to create, format, and analyze data in spreadsheets
  • Master of VLOOKUP, XLOOKUP, and Pivot table to create speedy Data Analytics
  • Add multimedia elements, animations, and transitions in PowerPoint
  • Take advantage of the many benefits of cloud computing with Office 365
  • Learn time-saving techniques including how to copy slides, and set your presentation
  • How to create a mail merge in Microsoft Word
  • Make your Word documents look amazing by inserting and editing tables
  • Learn how to boost productivity and save time using AI-driven platforms
  • Apply new and improved features in Excel 2021 and Office 365
  • Work with styles, templates, tables, and images in Word
  • Effectively use formulas, functions, charts, and graphs in Excel
  • Use to apply Microsoft PowerPoint to create dynamic and engaging presentations
  • Access and manage files from anywhere using Office 365, Gen AI
  • Expert Tips and tricks to improve your productivity and efficiency in Microsoft Office.
  • Control page appearance including using columns, indents, footers, borders, and watermarks.
  • Learn how to correctly Print envelopes and labels in Word
  • Participate in Practice test to test your learning skills

Course Content

Getting Started

Introduction β–Ά Preview
Getting started on Windows macOS and Linux β–Ά Preview
How to ask great questions β–Ά Preview
FAQs β–Ά Preview

Excel 2021: Basics

Excel Overview β–Ά Preview
Start Excel Spreadsheet πŸ”’
Enter Text and Numbers πŸ”’
Relative References β–Ά Preview
Working with ranges πŸ”’
Save and Save as Actions πŸ”’
File Extensions, Share, Export, and Publish files πŸ”’

Excel 2021: Rows, Columns, and Cells

Adding Rows and Columns πŸ”’
Modifying Rows and Column lengths β–Ά Preview

Excel 2021: Data Handling

Copy Cut and Paste πŸ”’
Copying Formulas β–Ά Preview

Excel 2021: Page Setting Up and Print

Page setup options πŸ”’
Fit to print on One Page πŸ”’
Print Workbooks β–Ά Preview

Excel 2021: Sorting and Filtering

Sorting Data Ascending Order πŸ”’
Sorting Data Descending Order πŸ”’
Filter Data πŸ”’

Excel 2021: Writing Formulas

Basic formula operations πŸ”’
Date time functions πŸ”’
Mathematical functions phase1 πŸ”’
Mathematical functions phase2 πŸ”’

Excel 2021: Advanced Formulas

V Lookup formula πŸ”’
HLookup formula πŸ”’

Excel 2021: XLOOKUP only for 2021 and Office 365

XLookup πŸ”’
Handling NA and Approximates match in XLookup πŸ”’

Excel 2021: Data and Tools

Split Text into columns πŸ”’
Flash Fill πŸ”’
Data Validation πŸ”’
Remove Duplicates πŸ”’
Get - import Data from Text πŸ”’
Get - import Data from CSV πŸ”’

Excel 2021: Formatting data and tables

Formatting Font πŸ”’
Formatting Alignment πŸ”’
Formatting Number πŸ”’
Formatting Date πŸ”’
Formatting tables πŸ”’

Excel 2021: Pivot Tables

Creating Pivot Table πŸ”’
Pivot charts πŸ”’

Excel 2021: Charts

Excel Charts – Categories πŸ”’
Elements of a chart πŸ”’
Creating charts πŸ”’
Column or Bar charts πŸ”’
Formatting charts πŸ”’
Line charts πŸ”’
Pie and Doughnut charts πŸ”’

PowerPoint 2021: Course Introduction

Overview πŸ”’
Start PowerPoint Presentation πŸ”’
Screen setting and Views πŸ”’

PowerPoint 2021: Basics

Presentation Tips and Guidelines πŸ”’
Creating a New Presentation πŸ”’
Working with Slides πŸ”’
Save a Presentation πŸ”’
Print Slides πŸ”’

PowerPoint 2021: Text and Bullet Options

Formatting Text πŸ”’
Slide Text Alignments πŸ”’
Multi-Column Text Alignments πŸ”’
Adding Bullets and Numbered List Items πŸ”’

PowerPoint 2021: Adding Graphic Assets

Insert Shapes πŸ”’
Insert Shapes πŸ”’
Insert Icons πŸ”’
Insert Graphics πŸ”’
Add 3D Models πŸ”’
Insert Pictures πŸ”’

PowerPoint 2021: Picture Formatting

Picture Options πŸ”’
Picture Cropping πŸ”’
Applying Built-in Picture Styles πŸ”’

PowerPoint 2021: SmartArt Graphics

Add SmartArt Graphic πŸ”’
Modifying SmartArt πŸ”’
Creating a Target Chart using SmartArt πŸ”’

PowerPoint 2021: Working with Tables

Create a Table on Slide πŸ”’
Formatting Tables πŸ”’
Inserting Tables πŸ”’
Table Layouts πŸ”’

PowerPoint 2021: Working with Charts

Add a Chart πŸ”’
Formatting Charts πŸ”’
Insert Chart from Microsoft Excel πŸ”’

PowerPoint 2021: Adding Multimedia

Adding Video to a Presentation πŸ”’
Screen Recording and Adding πŸ”’

PowerPoint 2021: Working with Transition

Applying Transitions to Presentation πŸ”’

PowerPoint 2021: Animation

Object Animation πŸ”’
Effect Options πŸ”’
Advanced Animation πŸ”’
Triggers to control animation πŸ”’

PowerPoint 2021: Slideshow Effects

Onscreen Presentation πŸ”’
Hiding Slides πŸ”’
Changing Order of Slides πŸ”’
Copying Slides πŸ”’

Word 2021: Introduction

Overview of MS Word πŸ”’
Start MS Word 2021 πŸ”’

Word 2021: Basics

Create a New Blank Document πŸ”’
Creating a Paragraph Text πŸ”’
Non-printing characters πŸ”’
Save a Document πŸ”’
Open a Document πŸ”’
Find and Replace πŸ”’

Word 2021: Word Formatting

AutoCorrect Options πŸ”’
Formatting Text πŸ”’
Copy Cut and Paste πŸ”’
Character Formatting πŸ”’
Format Painter πŸ”’
Work with Numbers πŸ”’
Add Bullets πŸ”’
Outline Creation πŸ”’

Word 2021: Tables

Creating a Table πŸ”’
Adding Rows and Columns to a table πŸ”’
Formatting Table Data πŸ”’
Borders and Shading πŸ”’
Sorting in a Table πŸ”’
Draw a Table πŸ”’
Convert Text to Table πŸ”’
Convert Table to Text πŸ”’
Insert a Spreadsheet πŸ”’
Quick Tables – Readily Available Formats πŸ”’

Word 2021: Styles

Working with Styles πŸ”’
Creating Styles πŸ”’
Clear Formatting πŸ”’

Word 2021: Page Layout

Margins πŸ”’
Orientation πŸ”’
Page size setting πŸ”’
Adding columns πŸ”’
Page break section break πŸ”’
Adding watermark πŸ”’
Headers and footers πŸ”’

Word 2021: Envelops and Lables

Create envelops πŸ”’
Creating labels πŸ”’

Word 2021: Mail Merges

Creating a mail merge document πŸ”’

Word 2021: Review and Printing

Thesaurus and spell check πŸ”’
Word count πŸ”’
Speech - read aloud πŸ”’
Language - translate πŸ”’
Tracking πŸ”’

Requirements

  • You will need a PC with Microsoft Office Suit installed or Office 365 Access
  • No prior technical experience is required!

Description

Unlock the full potential of Microsoft Office with "Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint"β€”a comprehensive course designed to empower you with advanced skills in the most essential productivity tools. Whether you're a student, professional, or entrepreneur, this course will take your abilities to the next level, enabling you to work smarter and more efficiently.


Start with Microsoft Excel, where you’ll transform raw data into actionable insights. Learn the fundamentals of data organization, calculations, and visualization. Progress to advanced topics like pivot tables, conditional formatting, and powerful functions such as VLOOKUP, HLOOKUP, and IF statements. Excel automation with formulas will also be introduced to save time and boost productivity.


update: Learn the top AI tools every professional needs to boost productivity


Move on to Microsoft PowerPoint to create stunning presentations. Learn to design slides with impactful layouts, animations, and transitions. Discover how to embed multimedia, collaborate in real-time, and deliver presentations that leave a lasting impression.


Finally, dive into Microsoft Word, where you’ll learn to create polished, professional documents. Master essential features like formatting, styles, tables, and templates. Explore advanced capabilities like mail merge, collaboration tools, and integrating graphics and charts to make your documents stand out.


Throughout the course, you’ll engage with hands-on projects and real-world examples to reinforce your learning. By the end, you’ll be proficient in using Word, Excel, and PowerPoint, ready to tackle personal, academic, and professional tasks with confidence.


Take your productivity to the next levelβ€”enroll now and master Microsoft Office 2021-365 today!

Who this course is for

  • Business professionals who want to create professional-quality documents, presentations, and spreadsheets
  • Students who need to use Microsoft Office for school projects or assignments
  • Job seekers who want to improve their Microsoft Office skills for career advancement
  • Anyone who wants to learn how to use Office 365 for collaboration and productivity
  • Freelancers, entrepreneurs, and small business owners who need to create professional documents and presentations
  • Anyone who wants to boost their productivity and efficiency with Microsoft Office tools.

Recommended Courses

Perplexity AI Masterclass: A Complete Zero to Hero
β‚Ή596
Generative AI for Beginners: Future of Innovation Unlocked
β‚Ή596
Master in Python Language Quickly Using the ChatGPT Open AI
β‚Ή499
Agentic AI Bootcamp: Build RAG AI Agents with Generative AI
β‚Ή596
β‚Ή799
β‚Ή7,989 90% off

This course includes:

  • πŸŽ₯ 5+ hours on-demand video
  • πŸ“± Access on mobile and desktop
  • β™Ύ Full lifetime access
  • 🧠 Practical sessions
  • πŸ“œ Certificate of completion