Microsoft Office 2019 Beginner To Expert Level
Tags: Microsoft Office
The Most Convenient Way to Boost Your Confidence And Learn MS Office Inside And Out—Quickly, No Travel or Classes.
Last updated 2022-01-10 | 4.4
- Discover new and improved features in MS-office 2019.- MS-Excel 2019 User experience.
- Formulas and Functions in MS-Excel.
What you'll learn
Discover new and improved features in MS-office 2019.
MS-Excel 2019 User experience.
Formulas and Functions in MS-Excel.
Data management In MS-Excel 2019.
MS-Power point 2019 User experience.
Charts and Graphs in MS-Excel 2019
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 2019 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
* Requirements
* Basic Computer Knowledge* Excel
* Word and PowerPoint installed on your machine. Preferably Office 2019 or Office 365
Description
- Discover new and improved features in MS-office 2019.
- MS-Excel 2019 User experience.
- Formulas and Functions in MS-Excel.
- Data management In MS-Excel 2019.
- MS-Power point 2019 User experience.
- Charts and Graphs in MS-Excel 2019
- 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 2019 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
21 sections • 82 lectures
Quick Overview of Excel 2019 Preview 05:43
Cell Formating In Excel Preview 08:34
Conditional Cell Formatting in Excel 2019 Preview 04:02
How to organize row and columns in excel 2019 Preview 08:07
Using skip blanks and Transpose function in excel Preview 02:57
Edit Multiple worksheet at a time Preview 03:05
Freeze Panes and split window in MS excel Preview 03:46
Cell styles and Themes in MS Excel 2019 Preview 07:00
How to make auto Lists in Excel 2019 Preview 04:27
Introduction to formulas in MS Excel 2019 Preview 02:41
"IF" formula In excel Preview 07:31
Sum and Average Formulas IN MS excel Preview 04:24
Count and CountA Formula Preview 02:39
Product and Quotient Formulas in Excel Preview 03:00
Date formula in MS Excel Preview 01:57
Min and Max formulas in EXCEL Preview 01:30
Sumif Formula in Excel Preview 01:47
V-Lookup Formula in MS Excel Preview 07:55
H-Lookup Formula in MS EXCEL Preview 05:21
Some Trigonometric Formulas in Excel Preview 03:23
Some Basic Mathematical formulas in Excel Preview 02:23
Filtering and sorting Data in MS excel Preview 05:18
Familiarization with Data Validation in Excel Preview 05:04
Find And Replace Commands in Excel Preview 06:48
Paste special Function in excel Preview 04:24
How to use PIVOT TABLE in MS excel 2019 Preview 05:38
Creating backup files in MS Excel 2019 Preview 02:36
How to Make excel file password protected Preview 04:11
Assignment
This Assignment is related to FONT group in Microsoft Word . This group provides access to all the Character Formatting commands.
Introduction to Charts and graphs in Excel 2019 Preview 05:05
Formatting Charts in Excel Preview 03:57
How to Handle data gapes for plotting charts Preview 02:24
Inserting Pie and doughnut charts in Excel Preview 02:27
Create Dynamic Target Line in MS excel 2019 Preview 11:55
Basic Shortcut keys-1 Preview 06:51
Basic Shortcut Keys quiz
The purpose of This Quiz is to memorize you the basic shortcut keys so that you can work faster in MS-office and save your time
Basics of Power Point 2019 Preview 02:32
Basics of Presentation Preview 03:44
Editing Presentation Preview 04:50
Working With Slides in Presentation in MS Power Point Preview 02:50
Usefulness of Design Tab in MS Power Point Preview 04:20
Creating smart art in Power Point Part-1 Preview 04:02
Creating Smart art in Power Point Part-2 Preview 03:07
Creating Smart art in Power Point Part-3 Preview 03:40
Word Art in MS Power Point Preview 03:10
Inserting Shapes in MS power Point Preview 03:25
Animations in MS Power Point Preview 06:42
Transitions in MS Power Point Preview 05:55
Add and Format pictures in MS Power Point Preview 07:03
Inserting a video file in Power Point Preview 03:22
Power point Screen recording Preview 03:16
Edit your Videos in MS power Point Preview 04:39
Creating a photo Album by using MS power Point Preview 02:56
Working with slide show Preview 05:04
Working with SETEP slide show group Preview 02:41
How to record slide show in Power point Preview 03:03
Inserting and formatting Table in Power point Preview 04:14
Inserting and formatting charts in Power point Preview 02:42
Convert a power point file into Power point SHOW file Preview 01:55
How to convert power point file into Image and pdf file Preview 02:04
Actions on Mouse clicks in Power Point Preview 03:49
Actions on Mouse Over in Power Point Preview 02:57
Hyperlink a video file in Power Point Preview 02:20
Inserting files in MS power point Preview 03:46
Clipboard group Preview 01:53
Working with window Preview 04:37
Power Point | Assignment
After completing this Assignment you will be able to: Add slides in Power Point Working with smart art Working with Animations and Transition Formatting in Power Point
How to print presentations in MS power POint Preview 03:02
Assignment-1
This assignment is for practice purpose. Do an assignment and submit it, let me know how much this course is helpful for you.
Introduction to MS word 2019 Preview 02:14
Formatting Text in MS Word Preview 02:43
Editing text in MS Word Preview 05:10
Working with Smart Art in MS Word Preview 01:41
Insert shapes and Pictures and Formatting in MS word Preview 02:49
Inserting Tables and Charts in MS WORD Preview 02:41
Header and Footer in MS word Preview 03:15
How to take screen shots in MS word Preview 00:50
How to convert word file into PDF file Preview 01:27
Find and Replace in MS Word Preview 02:05
Watermark in MS word Preview 04:23
Page Background in MS word Preview 02:22
Unicode and LaTex math formats of equations in MS-word Preview 12:13
This course includes:
- 5.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
Recent Posts
Marketing Courses for Small Businesses in 2021
Practical knowledge of the marketing basics can help businesses to grow beyond boundaries. The majority of the business owners understand the ins and outs of ...Read more
Why Should You Learn Microsoft Office? Here are 5 Benefits.
Microsoft Office or known as Office, is a hub of software developed by Microsoft. It is available in over 100 languages globally and was introduced ...Read more
Practical Secrets To Overcome Your Laziness
Laziness is a “disease” that almost everyone was or is suffering from. Laziness may not bring immediate harm, but if this situation persists, it can ...Read more
5 Sales tools sales reps need to succeed
As shopping from online sources is becoming very popular among customers, it is very important for sales companies and sales reps to engage with customers ...Read more
The 5 Best Online Stock Trading Courses In 2022
The stock market is now lively more than ever before because of the Covid pandemic. People are looking for alternative sources of income as their ...Read more
