Learn Microsoft Excel Powerpoint And Word
Tags: Microsoft Office
Learn the essentials of Microsoft Office in this 3-course bundle for Office 355 or Office 2019 users.
Last updated 2022-01-10 | 4.6
- Learn the essential Microsoft Office Skills in this three-course bundle: Excel- Word and PowerPoint
- Discover new and improved features in Excel 2019.
- Complete data entry
- cell formatting
- working with multiple worksheets and the “Ribbon” interface.
What you'll learn
Learn the essential Microsoft Office Skills in this three-course bundle: Excel
Word and PowerPoint
Discover new and improved features in Excel 2019.
Complete data entry
cell formatting
working with multiple worksheets and the “Ribbon” interface.
Discover how to format dates and numbers in Excel.
Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
Discover the essentials of using formulas and functions
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data
Discover new features in PowerPoint 2019 including Icons and 3D Models
Learn how to insert shapes
graphics and pictures to add some "zing" to your PowerPoint
Add charts
graphs and tables to present information in a non-text format
Wow your audience by adding animations
audio and video
Discover practical tips to present your presentation to your audience
Learn time saving techniques including how to copy slides
and exporting your presentation
Master the most common uses of Microsoft Word
How to controlling page appearance including using columns
indents
footers
borders and watermarks.
How to create a mail merge in Microsoft Word
Learn how to correctly Print envelopes and labels in Word
Learn to protect your Word document from changes
Insert professional pictures and graphics in your Word document
Make your Word documents look amazing by inserting and editing tables
* Requirements
* Excel* Word
* and PowerPoint installed on your machine. Preferably Office 2019 or Office 365
Description
- Learn the essential Microsoft Office Skills in this three-course bundle: Excel, Word and PowerPoint
- Discover new and improved features in Excel 2019.
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- Discover how to format dates and numbers in Excel.
- Learn practical methods to backup and recover your Excel spreadsheets and never lose data.
- Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
- Discover the essentials of using formulas and functions
- Discover how to create stunning charts and graphs in Excel
- Learn practical methods to sort and filter your data
- Discover new features in PowerPoint 2019 including Icons and 3D Models
- Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
- Add charts, graphs and tables to present information in a non-text format
- Wow your audience by adding animations, audio and video
- Discover practical tips to present your presentation to your audience
- Learn time saving techniques including how to copy slides, and exporting your presentation
- Master the most common uses of Microsoft Word
- How to controlling page appearance including using columns, indents, footers, borders and watermarks.
- How to create a mail merge in Microsoft Word
- Learn how to correctly Print envelopes and labels in Word
- Learn to protect your Word document from changes
- Insert professional pictures and graphics in your Word document
- Make your Word documents look amazing by inserting and editing tables
Course content
59 sections • 311 lectures
Intro to Excel Preview 01:00
WATCH ME: Essential Information for a Successful Training Experience Preview 02:03
Course Exercise Files Preview 00:23
Downloadable Course Transcripts Preview 00:15
What's New In Excel 2019 Preview 07:52
Course Overview Preview 01:16
Overview of the Excel window Preview 08:25
Mouse-Features Preview 03:12
Back Stage View Preview 02:37
Section 1 Quiz
Entering Text and Numbers Preview 04:32
Creating Basic Formulas Preview 06:49
Relative References Preview 03:01
Order of Operations Preview 04:48
Working with Ranges Preview 04:14
Module 2 - Practice Exercise Preview 01:35
Section 2 Quiz
Working with the Save and Save As Commands Preview 04:34
File Extensions, Share, Export and Publish Files Preview 03:44
Module 3 - Practice Exercise Preview 00:59
Section 3 Quiz
Opening a File Preview 05:33
Working with Larger Files Preview 05:34
Freeze Panes Option Preview 03:16
Split Screen Option Preview 03:22
Module 4 - Practice Exercise Preview 02:50
Section 4 Quiz
Headers and Footers Preview 07:23
Print Titles Preview 02:52
Comments Preview 05:23
Page Setup Options Preview 07:30
Fit to Print on One Page Preview 03:59
Printing Workbooks Preview 03:55
Module 5 - Practice Exercise Preview 01:53
Section 5 Quiz
Adding and deleting rows columns and cells Preview 06:12
Changing Column and-Row Widths Preview 03:45
Module 6 - Practice Exercise Preview 01:11
Section 6 Quiz
Cut, Copy and Paste Preview 07:07
Copying Formulas Preview 05:09
Module 7 - Practice Exercise Preview 01:20
Section 7 Quiz
Overview of Formulas Preview 02:48
Create Formulas Using Functions Part 1 Preview 10:04
Create Formulas Using Functions Part 2 Preview 05:24
Absolute Values Preview 05:16
Module 8 - Practice Exercise Preview 01:20
Section 8 Quiz
Adding Deleting and Renaming Sheets Preview 04:09
Additional Sheet Tab Options Preview 05:19
3 Dimensional Formulas Preview 05:28
Section 9 Quiz
Formatting Cells Part 1 Preview 10:04
Formatting Cells Part 2 Preview 03:38
Formatting Numbers Preview 09:24
Borders and Shading Preview 07:08
Format as Table Preview 06:07
Using Styles Preview 03:49
Using Format Painter Preview 04:29
Protecting Sheets Preview 09:01
Fill Handle and Custom Lists Preview 07:17
Module 10 - Practice Exercise Preview 01:10
Section 10 Quiz
Creating Charts Preview 09:48
Types of Charts Preview 05:58
Editing Charts Part 1 Preview 11:00
Editing Charts Part 2 Preview 03:12
Using Graphics to Enhance Charts Preview 05:05
Linking Chart Titles Preview 02:47
Module 11 - Practice Exercise Preview 00:53
Section 11 Quiz
Creating Range Names Preview 07:45
Managing Names Preview 03:17
Using Names in Formulas Preview 05:59
Module 12 - Practice Exercise Preview 01:20
Section 12 Quiz
Remove Duplicates Preview 07:45
Sort Data Preview 10:28
Filter Data Preview 07:38
Advanced Filters Preview 04:46
Module 13 - Practice Exercise Preview 01:20
Section 13 Quiz
Creating an Outline Preview 06:01
Subtotals Preview 08:00
Module 14 - Practice Exercise Preview 01:08
Section 14 Quiz
Arranging Files Preview 03:14
New Window Option Preview 02:45
Custom Views Preview 05:32
Module 15 - Practice Exercise Preview 01:07
Section 15 Quiz
Creating Formulas Between File Preview 06:35
Working with Links Preview 04:01
Consolidating Data Preview 05:16
Module 16 - Practice Exercise Preview 01:30
Section 16 Quiz
If Statements Preview 07:49
VLookups Preview 07:39
Data Validation Preview 08:13
Formula Auditing Preview 05:29
Module 17 - Practice Exercise Preview 01:20
Section 17 Quiz
Pivot Tables Preview 09:36
Pivot Charts Preview 03:16
Module 18 - Practice Exercise Preview 00:56
Section 18 Quiz
Slicers Preview 04:41
Goal Seeker Preview 02:56
Text to Columns Preview 02:49
Watch Window Preview 02:32
Customizing Ribbons and Tabs Preview 03:25
Module 19 - Practice Exercise Preview 01:23
Section 19 Quiz
Excel Shortcuts Every User Should Know Preview 12:00
Closing Video Preview 00:37
Welcome and Overview Preview 03:20
WATCH ME: Essential Information for a Successful Training Experience Preview 02:03
Course Exercise Files Preview 00:23
Downloadable Course Transcripts Preview 00:15
Navigate a PowerPoint Presentation Preview 11:46
Overview of the Screen and Views Preview 12:16
Exercise 1 Preview 01:11
Presentation Tips and Guidelines Preview 08:11
Creating a New Presentation Preview 04:45
Working with Slides Preview 07:01
Saving a Presentation Preview 06:30
Exercise 02 Preview 02:05
Section 24 Quiz
Formatting Text Preview 10:56
Working with Bullets and Numbered Lists Preview 10:51
Exercise 03 Preview 01:27
Section 25 Quiz
Inserting Shapes Preview 12:12
Inserting Graphics Preview 05:56
Inserting Icons and 3D Models Preview 06:24
Inserting Pictures Preview 06:42
Exercise 04 Preview 01:13
Section 26 Quiz
Selecting Objects Preview 03:38
Editing Objects Preview 04:35
Formatting Objects - Part 1 Preview 12:51
Formatting Objects - Part 2 Preview 09:03
Arranging Objects Preview 09:42
Grouping Objects Preview 06:27
Exercise 05 Preview 01:25
Section 27 Quiz
Picture Options Preview 06:04
Cropping Pictures Preview 06:49
Formatting Pictures Preview 07:21
Things You Can Do with Pictures Preview 09:29
Exercise 06 Preview 01:08
Section 28 Quiz
Creating SmartArt Preview 08:16
Modifying SmartArt Preview 06:05
Creating a Flowchart using SmartArt Preview 04:10
Exercise 07 Preview 01:10
Section 29 Quiz
Creating Tables Preview 07:13
Formatting Tables Preview 06:19
Inserting Tables Preview 06:40
Exercise 08 Preview 01:04
Section 30 Quiz
Adding Charts Preview 07:04
Formatting Charts Preview 12:52
Inserting Charts from Microsoft Excel Preview 04:29
Exercise 09 Preview 01:18
Section 31 Quiz
Using Master Slides Preview 05:04
Modifying Master Slides Preview 08:00
Creating a New Master Design Template Preview 10:00
Exercise 10 Preview 01:37
Section 32 Quiz
Adding Video to a Presentation Preview 06:03
Adding Audio to a Presentation Preview 05:52
Exercise 11 Preview 01:10
Section 33 Quiz
Applying Transitions Preview 05:38
Transition Options Preview 06:04
Exercise 12 Preview 01:02
Section 34 Quiz
Animating an Object Preview 10:15
Effect Options Preview 05:54
Working with the Animation Pane Preview 05:12
Motion Paths Preview 05:57
Triggers Preview 08:52
Exercise 13 Preview 01:24
Section 35 Quiz
Working with Action Buttons Preview 06:30
Working with Hyperllinks Preview 05:04
Exercise 14 Preview 01:02
Section 36 Quiz
Onscreen Presentation Options Preview 08:38
Hiding Slides Preview 03:28
Changing the order of slides Preview 02:42
Copying slides Preview 02:33
Slideshow Options Preview 04:51
Exercise 15 Preview 01:32
Rehearse Timings Preview 06:06
Recording a Presentation Preview 04:19
Slide Show Settings Preview 04:03
Creating a Custom Slide Show Preview 03:28
Exercise 16 Preview 01:18
Exporting options Preview 05:52
The Backstage Area Preview 05:24
Printing a Presentation Preview 05:13
Exercise 17 Preview 01:09
Welcome and Overview Preview 02:36
WATCH ME: Essential Information for a Successful Training Experience Preview 02:03
Course Exercise Files Preview 00:23
Downloadable Course Transcripts Preview 00:15
Overview of the MS Word Screen Preview 07:35
The Backstage View Preview 08:33
Creating a New Blank Document Preview 08:56
Working with Non-Printing Characters and Line Spacing Preview 08:27
Saving a Document Preview 06:41
Opening a Document Preview 06:53
Navigating a Document Preview 03:56
Go To, Find and Replace Preview 07:30
Editing a Document Preview 03:26
Practice Exercise Preview 00:57
Section 42 Quiz
AutoCorrect Options Preview 08:32
Selecting Text Preview 05:18
Cut, Copy and Paste Preview 08:11
Character Formatting Options Preview 08:05
Format Painter Preview 03:29
Working with Numbers Preview 08:02
Working with Bullets Preview 07:00
Creating an Outline Preview 05:41
Practice Exercise Preview 02:00
Alignment Options Preview 03:18
Line Spacing Options Preview 04:45
Working with Indents Preview 05:18
Working with Tabs Preview 12:18
Practice Exercise Preview 01:03
Section 44 Quiz
Sorting a List Preview 05:42
Working with Tables Preview 04:15
Creating a Table Preview 05:36
Adding Rows and Columns to a Table Preview 05:43
Formatting Table Data Preview 09:48
Borders and Shading Preview 12:41
Sorting in a Table Preview 06:14
Drawing in a Table Preview 07:30
Converting Existing Data to a Table Preview 04:46
Quick Tables Preview 06:03
Using Formulas in Tables Preview 08:34
Practice Exercise Preview 01:18
Section 46 Quiz
Working with Styles Preview 04:48
Creating Styles Preview 08:12
Editing Styles Preview 06:34
Practice Exercise Preview 01:08
Section 47 Quiz
Working with Page Breaks Preview 03:45
Working with Columns Preview 05:45
Adding a Watermark Preview 03:38
Headers and Footers Preview 08:52
Section 48 Quiz
What is Sectioning? Preview 03:58
Sectioning a document Preview 12:12
Odd and Even Sections Preview 02:40
Practice Exercise Preview 01:02
Section 49 Quiz
Inserting Pictures Preview 04:52
Inserting Pictures into Existing Documents Preview 05:02
Picture Options Preview 10:34
Working with Shapes Preview 10:37
Icons and 3D Models Preview 05:20
SmartArt, Charts and Screenshots Preview 13:34
Practice Exercise Preview 00:53
Section 50 Quiz
What is Mail Merge? Preview 04:07
Creating a Mail Merge Document - Part 1 Preview 12:01
Creating a Mail Merge Document - Part 2 Preview 09:54
Merging a Document with an Existing Data Source Preview 05:38
Merging Envelopes and Labels Preview 06:23
Merging a Directory Preview 04:01
Practice Exercise Preview 01:34
Section 52 Quiz
Building Blocks Preview 07:44
Auto Text Preview 03:22
Practice Exercise Preview 01:01
Section 53 Quiz
Creating an Index Preview 06:07
Creating a Table of Contents Preview 07:32
Practice Exercise Preview 01:43
Section 54 Quiz
Using the Thesaurus and Spell Check Preview 04:33
Comments Preview 04:05
Page Setup Options Preview 07:17
Printing Preview 06:20
Practice Exercise Preview 01:12
Section 65 Quiz
Closing Preview 00:23
EXTRA LESSON: Designing Better Spreadsheets Webinar Recording Preview 01:04:55
EXTRA LESSON: Data Cleaning in Excel Webinar Recording Preview 52:26
EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording Preview 01:11:18
EXTRA LESSON: Creating Engaging PowerPoint Presentations Webinar Recording Preview 01:01:45
EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic Preview 00:01
EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic Preview 00:00
EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic Preview 00:01
BONUS Lecture Preview 00:20
This course includes:
- 26.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
Recent Posts
PPC Management: how to fix 5 mistakes impacting your ad
Sometimes, you invest your money, give time and effort, and you still don’t see satisfying results in your PPC campaign. You wonder where you went ...Read more
7 react developer tools for ReactJs developers
Reactjs is a JavaScript library. The purpose is to design an attractive user interface. React is diverse, and developers use it to launch easy-to-use applications. ...Read more
Florida Connections Academy – Best Online Homeschool Program?
Florida Connections Academy is one of the leading online homeschool programs. Therefore, many parents consider this e-school as the first choice for their children’s education. ...Read more
Learn retail management through online courses
You might think that classic retail is dead because of the growth of the e-commerce business, however, you’d not be right. Retail is still in ...Read more
Drupal vs WordPress: Which should you use?
Drupal and WordPress are both content management systems. They almost have the same set of features. Therefore, everyone compares Drupal and WordPress. They are both ...Read more
