Includes
-
Duration:
9 days
(Avg)
-
Chapters: 135
-
Total Hours: 08:17
Features
Full lifetime access
Access on mobile
Assignments
Certificate of Completion
Overview
Course Description
Learn Microsoft Office 2021-365: Word, Excel, PowerPoint
Welcome to the ultimate Microsoft Office course! In this course, you'll learn everything you need to know to become proficient in Word, Excel, PowerPoint, and Office 365.
Microsoft Excel is a powerful spreadsheet program that is essential for analyzing data and making informed decisions. In this course, you'll learn how to use Excel to create and format worksheets, perform calculations and functions, and create charts and graphs.
Microsoft PowerPoint is the premier program for creating dynamic presentations that grab your audience's attention. In this course, you'll learn how to create and format slides, add multimedia elements, and use animations and transitions to bring your presentation to life.
Microsoft Word is the go-to word-processing program for businesses and individuals alike. In this course, you'll learn how to create and format documents, use styles and templates, work with tables and images, and more.
Finally, you'll learn about Office 365 access on the cloud-based suite of productivity tools that includes Word, Excel, PowerPoint, and more. You'll discover how to collaborate with others in real time, access your files from anywhere, and take advantage of the many benefits of cloud computing.
About Your Instructor
Sekhar Metla is a software engineer with 20+ years of professional experience. He is the author of several online-selling courses with more than 50,000+ students in many countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.
Whether you're a beginner or an experienced user, this course is designed to take your Microsoft Office skills to the next level. With expert instruction and hands-on practice, you'll gain the confidence and expertise you need to succeed in today's fast-paced business environment. So, what are you waiting for? Enroll now and start mastering Microsoft Office 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.
What you'll learn
- Able to perform documentation and presenting skills.
- Proficient in using Windows, Word Processing Applications, Spreadsheet Applications, Database Applications and Presentation Graphics Applications
Requirements
- You will need a PC with Microsoft Office Suit installed or Office 365 Access
- No prior technical experience is required!
Course Content
135 Lessons | 08:17 Total hours
Getting Started
-
Introduction 00:02:58 -
Getting started on Windows, macOS, and Linux 00:01:21
-
How to ask great questions 00:01:14
-
FAQ’s 00:01:19
Excel 2021: Basics
-
Excel Overview 00:05:20
-
Start Excel Spreadsheet 00:04:26
-
Enter Text and Numbers 00:07:24
-
Relative References 00:03:40
-
Working with ranges 00:06:52
-
Save and Save as Actions 00:07:52
-
File Extensions, Share, Export, and Publish files 00:05:53
Excel 2021: Rows, Columns and Cells
-
Adding Rows and Columns 00:02:34
-
Modifying Rows and Column lengths 00:05:03
Excel 2021: Data Handling
-
Copy, Cut and Paste 00:07:07
-
Copying Formulas 00:03:01
Excel 2021: Page Setting Up and Print
-
Page setup options 00:05:50
-
Fit to print on One Page 00:02:39
-
Print Workbooks 00:02:47
Excel 2021: Sorting and Filtering
-
Sorting Data Ascending Order 00:03:48
-
Sorting Data Descending Order 00:02:25
-
Filter Data 00:04:09
Excel 2021: Writing Formulas
-
Creating Basic Formulas 00:06:14
-
Datetime Formulas 00:06:20
-
Mathematical formulas phase1 00:19:54
-
Mathematical formulas phase2 00:12:23
Excel 2021: Advanced Formulas
-
VLOOKUP formula 00:12:12
-
HLOOKUP formula 00:04:07
Excel 2021: XLOOKUP only for 2021 and Office 365
-
XLOOKUP 00:07:39
-
Handling #NA and Approximates match in XLOOKUP 00:10:31
Excel 2021: Data and Tools
-
Split Text into Columns 00:07:03
-
Flash Fill 00:07:03
-
Data Validation 00:06:34
-
Remove Duplicates 00:07:47
-
Import Data from Text files 00:05:38
-
Import Data from .CSV files 00:03:22
Excel 2021: Formatting data and tables
-
Formatting Font 00:04:15
-
Formatting Alignment 00:06:04
-
Formatting Numbers 00:04:37
-
Formatting Date 00:03:29
-
Formatting Tables 00:05:13
Excel 2021: Pivot Tables
-
Pivot Tables 00:06:43
-
Pivot Charts 00:01:49
Excel 2021: Charts
-
Excel Charts – Categories 00:02:30
-
Elements of a chart 00:04:12
-
Creating Charts 00:01:55
-
Column or Bar charts 00:04:21
-
Formatting charts 00:03:37
-
Line Charts 00:02:13
-
Pie and Doughnut charts 00:03:47
PowerPoint 2021: Course Introduction
-
Overview 00:03:47
-
Start PowerPoint Presentation 00:04:59
-
Screen setting and Views 00:04:37
PowerPoint 2021: Basics
-
Presentation Tips and Guidelines 00:06:00
-
Creating a New Presentation 00:03:51
-
Working with Slides 00:03:40
-
Save a Presentation 00:04:16
-
Print Slides 00:03:11
PowerPoint 2021: Text and Bullet Options
-
Formatting Text 00:05:05
-
Slide Text Alignments 00:03:01
-
Multi-Column Text Alignments 00:01:40
-
Adding Bullets and Numbered List Items 00:02:48
PowerPoint 2021: Adding Graphic Assets
-
Insert Shapes 00:03:27
-
Insert Icons 00:03:02
-
Insert Graphics 00:03:38
-
Add 3D Models 00:02:41
-
Insert Pictures 00:02:58
PowerPoint 2021: Picture Formatting
-
Picture Options 00:03:56
-
Picture Cropping 00:02:33
-
Applying Built-in Picture Styles 00:04:02
PowerPoint 2021: SmartArt Graphics
-
Add SmartArt Graphic 00:02:33
-
Modifying SmartArt 00:03:13
-
Creating a Target Chart using SmartArt 00:03:04
PowerPoint 2021: Working with Tables
-
Create a Table on Slide 00:04:13
-
Formatting Tables 00:02:24
-
Inserting Tables 00:01:55
-
Table Layouts 00:01:19
PowerPoint 2021: Working with Charts
-
Add a Chart 00:01:57
-
Formatting Charts 00:01:48
-
Insert Chart from Microsoft Excel 00:02:57
PowerPoint 2021: Adding Multimedia
-
Adding Video to a Presentation 00:02:31
-
Adding Audio to a Presentation 00:01:33
-
Screen Recording and Adding 00:02:29
PowerPoint 2021: Working with Transition
-
Applying Transitions to Presentation 00:04:14
PowerPoint 2021: Animation
-
Object Animation 00:03:14
-
Effect Options 00:02:03
-
Advanced Animation 00:01:31
-
Triggers to control animation 00:01:47
PowerPoint 2021: Slideshow Effects
-
Onscreen Presentation 00:02:16
-
Hiding Slides 00:01:42
-
Changing Order of Slides 00:01:50
-
Copying Slides 00:02:10
Word 2021: Introduction
-
Overview of MS Word 00:03:57
-
Start MS Word 2021 00:04:48
Word 2021: Basics
-
Create a new blank document 00:04:20
-
Creating a paragraph text 00:04:55
-
Non-printing characters 00:02:59
-
Save a document 00:02:45
-
Open a document 00:01:22
-
Find and replace 00:03:50
Word 2021: Word Formatting
-
AutoCorrect options 00:02:54
-
Formatting text 00:03:59
-
Copy cut and paste 00:03:50
-
Character formatting 00:02:28
-
Format painter 00:03:58
-
Work with numbers 00:01:43
-
Add bullets 00:02:46
-
Outline creation 00:03:42
Word 2021: Tables
-
Creating a table 00:02:30
-
Adding rows and columns to a table 00:02:11
-
Formatting table data 00:02:19
-
Borders and shading 00:01:45
-
Sorting in a table 00:03:41
-
Draw a table 00:03:31
-
Convert text to table 00:02:43
-
Convert table to text 00:02:05
-
Insert a spreadsheet 00:01:41
-
Quick tables – readily available formats 00:01:52
Word 2021: Styles
-
Working with styles 00:01:54
-
Creating styles 00:01:50
-
Clear formatting 00:01:16
Word 2021: Page Layout
-
Margins 00:01:44
-
Orientation 00:01:23
-
Page size setting 00:00:57
-
Adding columns 00:03:24
-
Page break – section break 00:01:37
-
Adding watermark 00:02:59
-
Headers and footers 00:02:41
Word 2021: Envelops and Labels
-
Create envelops 00:02:28
-
Creating labels 00:01:58
Word 2021: Mail Merges
-
Creating a mail merge document 00:03:19
Word 2021: Review and Printing
-
Thesaurus and spell check 00:01:09
-
Word count 00:01:21
-
Speech - read aloud 00:00:58
-
Language - translate 00:01:13
-
Tracking 00:01:10
About the instructor
Sekhar Metla
Instructor
32 Courses
13+ Lesson
768 Students enrolled
Sekhar Metla is a software engineer with 15 years of professional experience. He is the author of several best-selling TeacherDada courses with more than 26,000+ students in 192 countries. He has a Master of Science in Computer Applications as Software Engineering and is also Microsoft Certified Professional. His students describe him as passionate, pragmatic, and motivational in his teaching.