Course Includes
- Recorded Lessons: 135
- Recorded Hours: 9
- Duration: 9 days (Avg)
Course Features
- Access on mobile
- TDP Assessment Test
- 3 Jobs Available
Top Skills Covered
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 | 9:00 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
45 Courses
13+ Lesson
1260 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.