Microsoft Office Word, Excel, Power Point | For Beginners

Name: Microsoft Office Word, Excel, Power Point | For Beginners
Rating: 4.2 (450 reviews)

The Most Convenient Way to Boost Your Confidence And Learn MS Office Inside And Out—Quickly, No Travel or Classes.

Created byAamir Ahmed

Last updated 12/2023

English

What you'll learn

Discover new and improved features in MS-office 2021.
MS-Excel 2021 User experience.
Formulas and Functions in MS-Excel.
Data management In MS-Excel 2021.
MS-Power point 2021 User experience.
Charts and Graphs in MS-Excel 2021
Creating and managing presentation in Power Point.
Entering and Editing text on slides.
Animations and Transitions in MS-Power Point.
Working With Pictures and Videos in MS Power Point.
Slide Show Management In Power Point
Working on Tables and Charts in MS-Power Point
File conversion techniques
Printing Presentations
Hyperlink Techniques in MS-Power Point.
Different Tips and Tricks in Power Point
MS-WORD 2021 User experience.
Formatting Text in MS-Word.
Editing Text in MS-Word.
Working on smart Art in MS word.
Inserting shapes and pictures in MS-Word.
Table and Charts in MS-Word.
Working with Window in MS- Word

Course content

20 sections • 80 lectures • 5h 5m total length

Quick Overview of MS Excel5:43
Explore the Excel 2019 interface, including the ribbon, tabs, and groups. Navigate worksheets, identify cells and formulas, and review tools like the quick access toolbar and view options.

Cell Formating In Excel7:17
Format cells in Excel to distinguish numbers from text and apply formats such as currency, date, time, percentage, fraction, scientific notation, or text, then use format painter to copy formats.
Conditional Cell Formatting in Excel 20196:35
Apply conditional formatting in Excel 2019 to highlight data by rules such as greater than, less than, duplicates, top and bottom items, color scales, data bars, and icon sets.
How to organize row and columns in excel 20194:22
Using Paste Special in excel7:20
Edit Multiple worksheet at a time2:19
Group multiple worksheets in Excel by selecting the first and last sheet with shift, edit across all sheets, insert a row, change column format, then ungroup to apply changes everywhere.
Freeze Panes and split window in MS excel2:57
Table and Cells Styles in Excel5:10
How to make auto Lists in Excel2:03

Introduction to formulas in Excel1:14
Explore the basics of formulas and functions in Excel by learning operators equal to, less than, greater than, and their use in cell comparisons like A1 vs B1.
"IF" formula In Excel3:13
Sum and Average Formulas1:20
"SUMIF" Formula2:54
"NESTEDIF" Formula3:22
"DATE" formula in MS Excel3:16
Advance "DATE" Formula2:39
Learn to use the advanced date formula in Excel to calculate end dates from start dates and durations for a project plan, applying date(year, month, day) and filling down.
"INDEX" Formula2:08
"INDEX + MATCH" Function3:29
"VLOOKUP" Function in Excel5:06
Use Vlookup function in Excel to search a value in a table array, specify the column index number, and calculate price from units sold with exact or approximate range lookup.
"VLOOKUP Approximate Match" with Example1:37
"HLOOKUP" Function in Excel1:45
Rules for "VLOOKUP" & "HLOOKUP" Functions in Excel1:37
Master the rules for VLOOKUP and HLOOKUP in Excel: unique lookup value, left-to-right column index, first-column lookup, and ascending data for approximate matches.

Filtering and sorting Data in MS excel5:18
Familiarization with Data Validation in Excel5:04
Learn how to apply data validation in Excel to restrict entries to a dropdown list (male or female) or values between 11 and 29, with input and error messages.
Find And Replace Commands in Excel6:48
Master find and replace in Excel across multiple sheets using the Find and Replace dialog, including find next, find all, and format-based searches like yellow cells.
Paste special Function in excel4:24
How to use PIVOT TABLE in MS excel 20195:38
Creating backup files in MS Excel 20192:36
How to Make excel file password protected4:11
Assignment

Introduction to Charts and graphs in Excel 20195:05
Learn to plot charts and graphs in Excel 2019 to analyze data, and master design and formatting options for bar, column, pie, radar, and waterfall charts.
Formatting Charts in Excel3:57
Learn to format charts in Excel by adding axis titles, adjusting colors and chart styles, enabling data labels and gridlines, and fine-tuning data visibility.
How to Handle data gapes for plotting charts2:24
Inserting Pie and doughnut charts in Excel2:27
Create Dynamic Target Line in MS excel 201911:55

Basics of Presentation3:44
Master PowerPoint basics for beginners by creating slides, applying layouts, repositioning content, and organizing slides into introduction and body sections with section controls.
Editing Presentation4:50
Working With Slides in Presentation in MS Power Point2:50
Learn to add, copy, duplicate, rearrange, and delete slides in PowerPoint using keyboard shortcuts and right-click options.
Usefulness of Design Tab in MS Power Point4:20

Requirements

Basic Computer Knowledge
Excel, Word and PowerPoint installed on your machine. Preferably Office 2019/2021 or Office 365

Description

Ready to become a Microsoft Office maestro? Look no further! Dive into a comprehensive 3-course bundle that will revolutionize your skills in Excel, PowerPoint, and Word. Say goodbye to confusion and hello to confidence with these essential programs made easy!

**What's Inside:**

Learn how to Get Free Access to Microsoft Office by joining the Official Microsoft Office Developer Program.
**Master Excel:** Unravel the mysteries of data manipulation! With engaging lectures and on-demand videos, you'll conquer data entry, data cleaning, data formatting, formulas & functions, advanced charts, and mind-blowing tips and tricks about Excel. Stay ahead with lifetime access to updates!
**Conquer PowerPoint:** Transform your presentations into captivating stories! Whether you're a beginner or looking to level up. Craft slides that wow and learn at your pace!
**Word Wizardry:** Words hold power, and so will you! Dive into a great series of lectures and learn to wield Word like a pro. From formatting to document design, you'll have the tools to create masterpieces.
**Your Toolkit:**

5.5+ hours of engaging tutorials - bite-sized and easy to follow!
Unlock the secrets of 70+ individual video lectures.
Dive into hands-on assignments that reinforce your skills.
Score a shiny certificate of completion - showcase your expertise!
Worried about getting stuck? Our instructor support is here for you!

**Your Questions, Answered:**

Confused? Curious? Fear not! Our interactive Q&A section is your learning lifeline. Don't just follow along - ask, discuss, and learn!

**Sneak Peek:** Not convinced? Dip your toes with preview videos! Experience the quality firsthand before diving into this transformative journey.

**Risk-Free Learning:** Still on the fence? Take the plunge! Enroll now and if the course isn't your match made in tech-heaven, we've got your back. Enjoy a 30-day money-back guarantee, no questions asked.

Don't wait for success - create it! Enroll today and kickstart your journey towards Microsoft Office mastery. Your future self will thank you.

Who this course is for:

Anyone want to expertise MS Office
Anyone new to Microsoft Office or upgrading from a previous version

Microsoft Office Word, Excel, Power Point | For Beginners

What you'll learn

Explore related topics

Course content

MS Excel 20191 lecture • 6min

Worksheet Design of MS Excel 20198 lectures • 38min

Formulas and Functions in MS Excel 201913 lectures • 34min

Data Management in MS EXCEL 20197 lectures • 34min

Charts and graphs In MS EXCEL 20195 lectures • 26min

Top new features of MS-Word 20192 lectures • 16min

Basic Shortcut Keys1 lecture • 7min

Getting Started With Microsoft Power Point 20191 lecture • 3min

Create and Manage Presentation in MS power Point 20194 lectures • 16min

Enter and Edit Text on Slides in MS power Point 20195 lectures • 17min

Requirements

Description

Who this course is for: