Close icon
"Welcome to a new Coursetakers Experience!"
Close icon
Hand Coins Icon
Not sure? All courses have a 30-day money-back guarantee
30-Day Money-Back Guarantee
Lifetime Access
Professional > IT Courses > Microsoft 365 (Office)
Overview Curriculum Instructor Reviews
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint Play Image

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

Master Microsoft Office 2021: Enhance Your Efficiency and Expertise with Practical Training and Pro Tips

4.3 Rating star
235 Ratings
10,323 Enrolled

Created By Metla Sudha Sekhar

For You
Course speifications
duration icon
1.5 Hours
files icon
33 Files
access icon
Lifetime/ Unlimited
certification icon
Certificate of completion
date icon
Created on Dec.5.2024
resources icon
10 downloadable resources
update icon
Last Updated 12.Apr.2025
caption icon
Closed captions
gurantee icon
30 days money back gurantee
support icon
Instructor support
Promo code
Apply

Course description

What You'll Learn



  • Master Microsoft Word, Excel, and PowerPoint with practical, hands-on training.

  • Utilize new and enhanced features in Excel 2021 and Office 365 to improve productivity.

  • Create and format professional documents using Microsoft Word.

  • Work with styles, templates, tables, and images to enhance document presentation.

  • Organize and analyze data efficiently in Microsoft Excel, including formulas, functions, charts, and graphs.

  • Gain expertise in VLOOKUP, XLOOKUP, and Pivot Tables for faster data analysis.

  • Design dynamic PowerPoint presentations with multimedia, animations, and transitions.

  • Learn cloud-based collaboration with Office 365 and Gen AI to access files from anywhere.

  • Discover time-saving techniques to streamline workflow and improve efficiency.

  • Perform mail merges, print envelopes and labels, and create professional documents in Word.

  • Participate in practice tests to reinforce learning and assess your skills.



Requirements



  • A PC with Microsoft Office Suite or Office 365 installed.

  • No prior experience needed—perfect for beginners!



Description


Unlock the full potential of Microsoft Office with "Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint"—your ultimate guide to becoming an Office expert. Whether you're a student, professional, or entrepreneur, this course will help you work smarter and more efficiently using the most essential productivity tools.



✔ Excel Mastery: Learn data organization, formulas, calculations, and visualization. Master pivot tables, conditional formatting, VLOOKUP, HLOOKUP, and automation techniques to save time and boost productivity.



✔ PowerPoint Excellence: Create engaging presentations with eye-catching animations, transitions, and multimedia integration. Learn how to collaborate in real time and design professional-quality slides.



✔ Word Expertise: Develop polished, professional documents with advanced formatting, tables, mail merge, and collaboration tools. Learn how to integrate charts, graphics, and templates for a stunning document presentation.



With real-world projects, hands-on exercises, and expert guidance, this course is designed to make you a Microsoft Office power user. Whether you're looking to advance your career, improve workplace efficiency, or streamline academic projects, this training is your shortcut to success.



Take control of your productivity—Enroll now and master Microsoft Office 2021-365 today!



Who This Course Is For:



  • Business professionals looking to create high-quality documents, presentations, and spreadsheets.

  • Students needing Microsoft Office skills for academic projects and assignments.

  • Job seekers aiming to enhance their resume with essential Office skills.

  • Freelancers, entrepreneurs, and small business owners who need to create professional content.

  • Anyone looking to boost productivity and efficiency using Microsoft Office.

View more

Course content web

34 sections | 135 lectures | 8:00 total length
Expand all sections
1. Getting Started
Close Button
Video Icon 1. Introduction.mp4
156.28 MB
Video Icon 2. Getting started on Windows macOS and Linux.mp4
3.86 MB
Video Icon 3. How to ask great questions.mp4
3.37 MB
Video Icon 4. FAQs.mp4
3.30 MB
2. Excel 2021 Basics
Close Button
Video Icon 1. Excel Overview.mp4
21.79 MB
Video Icon 2. Start Excel Spreadsheet.mp4
20.43 MB
Video Icon 3. Enter Text and Numbers.mp4
22.41 MB
Video Icon 4. Relative References.mp4
11.25 MB
Video Icon 5. Working with ranges.mp4
20.14 MB
Video Icon 6. Save and Save as Actions.mp4
24.59 MB
Video Icon 7. File Extensions, Share, Export, and Publish files.mp4
17.11 MB
3. Excel 2021 Rows, Columns, and Cells
Close Button
Video Icon 1. Adding Rows and Columns.mp4
8.27 MB
Video Icon 2 Modifying Rows and Column lengths.mp4
15.66 MB
4. Excel 2021 Data Handling
Close Button
Video Icon 1. Copy Cut and Paste.mp4
22.30 MB
Video Icon 2. Copying Formulas.mp4
10.61 MB
5. Excel 2021 Page Setting Up and Print
Close Button
Video Icon 1. Page setup options.mp4
21.21 MB
Video Icon 2. Fit to print on One Page.mp4
7.86 MB
Video Icon 3. Print Workbooks.mp4
10.43 MB
6. Excel 2021 Sorting and Filtering
Close Button
Video Icon 1. Sorting Data Ascending Order.mp4
12.00 MB
Video Icon 2. Sorting Data Descending Order.mp4
7.70 MB
Video Icon 3. Filter Data.mp4
13.13 MB
7. Excel 2021 Writing Formulas
Close Button
Video Icon 1. Creating Basic Formulas.mp4
16.23 MB
Video Icon 2. Datetime Formulas.mp4
16.50 MB
Video Icon 3. Mathematical formulas phase1.mp4
53.32 MB
Video Icon 4. Mathematical formulas phase2.mp4
33.55 MB
8. Excel 2021 Advanced Formulas
Close Button
Video Icon 1. VLOOKUP formula.mp4
30.29 MB
Video Icon 2. HLOOKUP formula.mp4
11.92 MB
9. Excel 2021 XLOOKUP only for 2021 and Office 365
Close Button
Video Icon 1. XLOOKUP.mp4
21.10 MB
Video Icon 2. Handling #NA and Approximates match in XLOOKUP.mp4
28.24 MB
10. Excel 2021 Data and Tools
Close Button
Video Icon 1. Split Text into columns.mp4
20.57 MB
Video Icon 2. Flash Fill.mp4
22.46 MB
Video Icon 3. Data Validation.mp4
17.56 MB
Video Icon 4. Remove Duplicates.mp4
24.39 MB
Video Icon 5. Import Data from Text files.mp4
23.49 MB
Video Icon 6. Import Data from .CSV files.mp4
14.17 MB
11. Excel 2021 Formatting data and tables
Close Button
Video Icon 1. Formatting Font.mp4
12.21 MB
Video Icon 2. Formatting Alignment.mp4
15.89 MB
Video Icon 3. Formatting Number.mp4
14.90 MB
Video Icon 4. Formatting Date.mp4
9.99 MB
Video Icon 5. Formatting tables.mp4
18.99 MB
12. Excel 2021 Pivot Tables
Close Button
Video Icon 1. Pivot Tables.mp4
22.59 MB
Video Icon 2. Pivot Charts.mp4
8.52 MB
13. Excel 2021 Charts
Close Button
Video Icon 1. Excel Charts – Categories.mp4
7.21 MB
Video Icon 2. Elements of a chart.mp4
13.39 MB
Video Icon 3. Creating charts.mp4
6.81 MB
Video Icon 4. Column or Bar charts.mp4
15.40 MB
Video Icon 5. Formatting charts.mp4
13.25 MB
Video Icon 6. Line charts.mp4
8.31 MB
Video Icon 7 Pie and Doughnut charts.mp4
13.62 MB
14. PowerPoint 2021 Introduction
Close Button
Video Icon 1. Overview.mp4
17.20 MB
Video Icon 2. Start PowerPoint Presentation.mp4
18.86 MB
Video Icon 3. Screen setting and Views.mp4
12.69 MB
15. PowerPoint 2021 Basics
Close Button
Video Icon 1. Presentation Tips and Guidelines.mp4
17.69 MB
Video Icon 2. Creating a New Presentation.mp4
11.79 MB
Video Icon 3. Working with Slides.mp4
10.35 MB
Video Icon 4. Save a Presentation.mp4
13.75 MB
Video Icon 5. Print Slides.mp4
10.28 MB
16. PowerPoint 2021 Text and Bullet Options
Close Button
Video Icon 1. Formatting Text.mp4
17.35 MB
Video Icon 2. Slide Text Alignments.mp4
11.83 MB
Video Icon 3. Multi-Column Text Alignments.mp4
6.64 MB
Video Icon 4. Adding Bullets and Numbered List Items.mp4
10.10 MB
17.PowerPoint 2021 Adding Graphic Assets
Close Button
Video Icon 1. Insert Shapes.mp4
11.39 MB
Video Icon 2. Insert Icons.mp4
11.14 MB
Video Icon 3. Insert Graphics.mp4
15.13 MB
Video Icon 4. Add 3D Models.mp4
10.91 MB
Video Icon 5. Insert Pictures.mp4
14.99 MB
18. PowerPoint 2021 Picture Formatting
Close Button
Video Icon 1. Picture Options.mp4
19.66 MB
Video Icon 2. Picture Cropping.mp4
8.97 MB
Video Icon 3. Applying Built-in Picture Styles.mp4
14.19 MB
19. PowerPoint 2021 SmartArt Graphics
Close Button
Video Icon 1. Add SmartArt Graphic.mp4
7.46 MB
Video Icon 2. Modifying SmartArt.mp4
11.49 MB
Video Icon 3. Creating a Target Chart using SmartArt.mp4
10.63 MB
20. PowerPoint 2021 Working with Tables
Close Button
Video Icon 1 Create a Table on Slide.mp4
12.25 MB
Video Icon 2. Formatting Tables.mp4
7.97 MB
Video Icon 3. Inserting Tables.mp4
5.85 MB
Video Icon 4. Table Layouts.mp4
4.18 MB
21. PowerPoint 2021 Working with Charts
Close Button
Video Icon 1. Add a Chart.mp4
7.10 MB
Video Icon 2. Formatting Charts.mp4
6.30 MB
Video Icon 3. Insert Chart from Microsoft Excel.mp4
10.91 MB
22. PowerPoint 2021 Adding Multimedia
Close Button
Video Icon 1. Adding Video to a Presentation.mp4
63.62 MB
Video Icon 2. Adding Audio to a Presentation.mp4
4.96 MB
Video Icon 3. Screen Recording and Adding.mp4
8.80 MB
23. PowerPoint 2021 Working with Transition
Close Button
Video Icon 1. Applying Transitions to Presentation.mp4
172.41 MB
24. PowerPoint 2021 Animation
Close Button
Video Icon 1. Object Animation.mp4
11.96 MB
Video Icon 2. Effect Options.mp4
5.90 MB
Video Icon 3. Advanced Animation.mp4
4.70 MB
Video Icon 4. Triggers to control animation.mp4
5.15 MB
25. PowerPoint 2021 Slideshow Effects
Close Button
Video Icon 1. Onscreen Presentation.mp4
9.75 MB
Video Icon 2. Hiding Slides.mp4
7.20 MB
Video Icon 3. Copying Slides.mp4
9.15 MB
Video Icon 4. Changing Order of Slides.mp4
7.64 MB
26. Word 2021 Introduction
Close Button
Video Icon 1. Overview of MS Word.mp4
18.22 MB
Video Icon 2. Start MS Word 2021.mp4
25.18 MB
27. Word 2021 Basics
Close Button
Video Icon 1. Create a New Blank Document.mp4
16.66 MB
Video Icon 2. Creating a Paragraph Text.mp4
12.58 MB
Video Icon 3. Non-printing characters.mp4
8.25 MB
Video Icon 4. Save a Document.mp4
8.88 MB
Video Icon 5. Open a Document.mp4
7.20 MB
Video Icon 6. Find and Replace.mp4
11.60 MB
28. Word 2021 Word Formatting
Close Button
Video Icon 1. AutoCorrect Options.mp4
9.52 MB
Video Icon 2. Formatting Text.mp4
12.96 MB
Video Icon 3. Copy Cut and Paste.mp4
12.42 MB
Video Icon 4. Character Formatting.mp4
11.39 MB
Video Icon 5. Format Painter.mp4
11.45 MB
Video Icon 6. Work with Numbers.mp4
5.28 MB
Video Icon 7. Add Bullets.mp4
12.70 MB
Video Icon 8. Outline Creation.mp4
16.28 MB
29. Word 2021 Tables
Close Button
Video Icon 1. Creating a Table.mp4
6.57 MB
Video Icon 2. Adding Rows and Columns to a table.mp4
6.27 MB
Video Icon 3. Formatting Table Data.mp4
6.76 MB
Video Icon 4. Borders and Shading.mp4
5.91 MB
Video Icon 5. Sorting in a Table.mp4
11.27 MB
Video Icon 6 Draw a Table.mp4
11.06 MB
Video Icon 7. Convert Text to Table.mp4
8.31 MB
Video Icon 8. Convert Table to Text.mp4
6.77 MB
Video Icon 9. Insert a Spreadsheet.mp4
5.89 MB
Video Icon 10. Quick Tables – Readily Available Formats.mp4
7.32 MB
30. Word 2021 Styles
Close Button
Video Icon 1. Working with Styles.mp4
5.58 MB
Video Icon 2. Creating Styles.mp4
5.93 MB
Video Icon 3. Clear Formatting.mp4
3.91 MB
31. Word 2021 Page Layout
Close Button
Video Icon 1. Margins.mp4
4.77 MB
Video Icon 2. Orientation.mp4
3.94 MB
Video Icon 3. Page size setting.mp4
3.08 MB
Video Icon 4. Adding columns.mp4
18.20 MB
Video Icon 5. Page break section break.mp4
8.36 MB
Video Icon 6. Adding watermark.mp4
15.67 MB
Video Icon 7. Headers and footers.mp4
18.40 MB
32. Word 2021 Envelops and Lables
Close Button
Video Icon 1. Create envelops.mp4
6.84 MB
Video Icon 2. Creating labels.mp4
5.37 MB
33. Word 2021 Mail Merges
Close Button
Video Icon 1. Creating a mail merge document.mp4
10.63 MB
34. Word 2021 Review and Printing
Close Button
Video Icon 1. Thesaurus and spell check.mp4
3.66 MB
Video Icon 2. Word count.mp4
4.30 MB
Video Icon 3. Speech - read aloud.mp4
3.19 MB
Video Icon 4 Language - translate.mp4
4.04 MB
Video Icon 5. Tracking.mp4
3.56 MB

Similar courses

Explore More

Instructor

Metla Sudha Sekhar
Person Image
access icon
0 Instructor Rating
reviews icon
Reviews
students icon
0 Students olled
play icon
7 Courses

More Courses by Metla Sudha Sekhar

Learn MySQL from scratch for Data Science and Analytics
122
Rating Star
Learn MySQL from scratch and become proficient in writing SQL queries, managing databases, and solving real-world data problems using MySQL Server and Workbench. Ideal for data analysts, business professionals, and aspiring database experts.
Metla Sudha Sekhar
11,212 Enrolled
6:00 Hours
buy icon Buy $19.99
Programming for Kids and Beginners: Learn to Code in Python
154
Rating Star
Learn Python from scratch with hands-on coding examples. This beginner-friendly course is perfect for kids, beginners, and anyone wanting to start coding in Python.
Metla Sudha Sekhar
10,988 Enrolled
3:07 Hours
buy icon Buy $39.99
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint
235
Rating Star
Master Microsoft Office 2021: Enhance Your Efficiency and Expertise with Practical Training and Pro Tips
Metla Sudha Sekhar
10,323 Enrolled
8:00 Hours
buy icon Buy $44.99
Microsoft Excel Crash Course 2025: Masterclass for Weekend
58
Rating Star
Learn Microsoft Excel from scratch and unlock its full potential! This beginner-friendly course covers essential Excel skills, including formulas, functions, Pivot Tables, data visualization, and time-saving shortcuts. Whether you're a student, professional, or entrepreneur, you'll gain practical knowledge to boost productivity, analyze data, and create stunning reports. Start mastering Excel today! 🚀
Metla Sudha Sekhar
10,228 Enrolled
5:30 Hours
buy icon Buy $19.99
Join us today!

Recieve the best deals..

Send Icon

Master Indian Cooking: 6 essential gravies for 1000+ Dishes

Course Image Play Image

Free Sample videos:

Microsoft Excel Crash Course 2025: Masterclass for Weekend
Video Icon 1. Introduction.mp4
0:00
Microsoft Excel Crash Course 2025: Masterclass for Weekend
Video Icon 2. Getting started on Windows macOS and Linux.mp4
0:00
Microsoft Excel Crash Course 2025: Masterclass for Weekend
Video Icon 3. How to ask great questions.mp4
0:00
Microsoft Excel Crash Course 2025: Masterclass for Weekend
Video Icon 4. FAQs.mp4
0:00

Coursetakers Support Centre

Captcha