Tutorialspoint

FREEDOM SALE IS LIVE! Use: FREEDOM10

Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

person icon Skills Marathon

4.5

Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

Microsoft Office 2021: Boost Your Productivity and Professionalism with Expert Instruction and Hands-On Practice

updated on icon Updated on Aug, 2025

language icon Language - English

person icon Skills Marathon

category icon Office Productivity,Microsoft,Microsoft 365(Office)

Lectures -135

Duration -8 hours

Lifetime Access

4.5

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Maximize the use of Microsoft Office with “Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint“—a full and comprehensive course that will help you master these critical productivity tools. Whether you are a student, employee, or entrepreneur, this course will elevate your skills and show you how to work differently, smarter, and more efficiently.
The first part of the course covers Microsoft Excel, where you will learn how to make data from unprocessed raw data, everyday information that you can use for insights. This includes the basic principles of organizing data, calculating, and visualizing data. These principles will also take you into advanced topics that include pivot tables, conditional formats, and powerful functions such as, VLOOKUP, HLOOKUP, and IF statements. Excel automation with formulas will also be introduced to save time and boost productivity.
Move on to Microsoft PowerPoint to create stunning presentations. You will learn how to design slides using purposeful layouts, many types of animations and transitions. You will learn how to embed multimedia, collaborate in real time and present information which has an impact.
Finally, you will get into Microsoft Word and learn how to create cohesive, polished, professional documents. You will learn the basics including formatting, styles, tables and templates. Then, you will move on to advanced features such as mail merge, collaboration, graphics, and charts which will allow you to characterize your documents and make them visually engaging.
As you have been given hands-on projects and examples from the world of business, the learning process will help reinforce the objectives. You will either be able to use Word, Excel, and PowerPoint efficiently; or complete personal, academic, and professional tasks with confidence. Get more productive and get started, enrol for Microsoft Office 2021-365 today!
Who can benefit from this course:
  • Business professionals creating professional-level documents, spreadsheets and presentations
  • Students using Microsoft Office for projects or assignments.
  • Job seekers using Microsoft Office as a way to advance their careers.
  • Anyone wanting to learn Office 365 for productivity and collaboration.
  • Freelancers, entrepreneurs, and small business owners using Word or Power point to create professional documents or presentations.
  • Anyone wanting to increase their productivity and efficiency by using Microsoft Office tools.

Goals

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

Prerequisites

  • You will need a PC with Microsoft Office Suit installed or Office 365 Access
  • No prior technical experience is required!
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

Curriculum

Check out the detailed breakdown of what’s inside the course

Getting started

4 Lectures
  • play icon Introduction 02:58 02:58
  • play icon Getting started on Windows, macOS, and Linux 01:21 01:21
  • play icon How to ask great questions 01:14 01:14
  • play icon FAQ’s 01:19 01:19

Excel 2021: basics

7 Lectures
Tutorialspoint

Excel 2021: rows, columns, and cells

2 Lectures
Tutorialspoint

Excel 2021: data handling

2 Lectures
Tutorialspoint

Excel 2021: page setting up and print

3 Lectures
Tutorialspoint

Excel 2021: sorting and filtering

3 Lectures
Tutorialspoint

Excel 2021: writing formulas

4 Lectures
Tutorialspoint

Excel 2021: advanced formulas

2 Lectures
Tutorialspoint

Excel 2021: XLOOKUP only 2021 and office 365

2 Lectures
Tutorialspoint

Excel 2021: data and tools

6 Lectures
Tutorialspoint

Excel 2021: formatting data and tables

5 Lectures
Tutorialspoint

Excel 2021: pivot tables

2 Lectures
Tutorialspoint

Excel 2021: charts

7 Lectures
Tutorialspoint

Powerpoint 2021: introduction

3 Lectures
Tutorialspoint

Powerpoint 2021: basics

5 Lectures
Tutorialspoint

Powerpoint 2021: text and bullet options

4 Lectures
Tutorialspoint

Powerpoint 2021: adding graphic assets

5 Lectures
Tutorialspoint

Powerpoint 2021: picture formatting

3 Lectures
Tutorialspoint

Powerpoint 2021: smart art graphics

3 Lectures
Tutorialspoint

Powerpoint 2021: working with tables

4 Lectures
Tutorialspoint

Powerpoint 2021: working with charts

3 Lectures
Tutorialspoint

Powerpoint 2021: adding multimedia

3 Lectures
Tutorialspoint

Powerpoint 2021: working with transition

1 Lectures
Tutorialspoint

Powerpoint 2021: animation

4 Lectures
Tutorialspoint

Powerpoint 2021: slideshow effects

4 Lectures
Tutorialspoint

Word 2021: introduction

2 Lectures
Tutorialspoint

Word 2021: basics

6 Lectures
Tutorialspoint

Word 2021: word formatting

8 Lectures
Tutorialspoint

Word 2021: tables

10 Lectures
Tutorialspoint

Word 2021: styles

3 Lectures
Tutorialspoint

Word 2021: page layout

7 Lectures
Tutorialspoint

Word 2021: envelops and lables

2 Lectures
Tutorialspoint

Word 2021: mail merges

1 Lectures
Tutorialspoint

Word 2021: review and printing

5 Lectures
Tutorialspoint

Instructor Details

Skills Marathon

Skills Marathon

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515