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