Ms Office Excel Word Access Powerpoint 2019 Beginners
Tags: Microsoft Office
Learn the essentials of Microsoft Office in this 4-course bundle for Office 365 or Office 2019 users.
Last updated 2022-01-10 | 4.4
- Learn the essential Microsoft Office Skills in this four-course bundle: Excel- Word
- PowerPoint and Access
- 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.
What you'll learn
Learn the essential Microsoft Office Skills in this four-course bundle: Excel
Word
PowerPoint and Access
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 in Excel
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data in Excel
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 your PowerPoint presentation information in a non-text format
Wow your audience by adding animations
audio and video to PowerPoint
Discover practical tips to present your PowerPoint 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
Learn Word tools 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
Sorting information and running queries in Access
Navigating the Access 2019 interface
Discover how to into import data from Excel in Access
Learn Queries
use validations
how to create and print reports in Access
How to compact
repair and backup your Access database
How to create a linked table in Access
* Requirements
* Excel* Word
* PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365
Description
- Learn the essential Microsoft Office Skills in this four-course bundle: Excel, Word, PowerPoint and Access
- 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 in Excel
- Discover how to create stunning charts and graphs in Excel
- Learn practical methods to sort and filter your data in Excel
- 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 your PowerPoint presentation information in a non-text format
- Wow your audience by adding animations, audio and video to PowerPoint
- Discover practical tips to present your PowerPoint 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
- Learn Word tools 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
- Sorting information and running queries in Access
- Navigating the Access 2019 interface
- Discover how to into import data from Excel in Access
- Learn Queries, use validations, how to create and print reports in Access
- How to compact, repair and backup your Access database
- How to create a linked table in Access
Course content
82 sections • 398 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 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 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 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 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 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 Quiz
Cut, Copy and Paste Preview 07:07
Copying Formulas Preview 05:09
Module 7 - Practice Exercise Preview 01:20
Section 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 Quiz
Working with the Save and Save As Commands Preview 04:34
Adding Deleting and Renaming Sheets Preview 04:09
Additional Sheet Tab Options Preview 05:19
3 Dimensional Formulas Preview 05:28
Module 9 - Practice Exercise Preview 01:31
Section 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 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 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 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 00:57
Section Quiz
Creating an Outline Preview 06:01
Subtotals Preview 08:00
Module 14 - Practice Exercise Preview 01:08
Section 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 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 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 Quiz
Pivot Tables Preview 09:36
Pivot Charts Preview 03:16
Module 18 - Practice Exercise Preview 00:56
Section 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 Quiz
Excel Shortcuts Every User Should Know Preview 12:00
Closing Video Preview 00:37
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 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 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 Quiz
Working with Styles Preview 04:48
Creating Styles Preview 08:12
Editing Styles Preview 06:34
Practice Exercise Preview 01:08
Section 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 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 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 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 Quiz
Creating an Index Preview 06:07
Creating a Table of Contents Preview 07:32
Practice Exercise Preview 01:43
Section 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 Quiz
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 Quiz
Formatting Text Preview 10:56
Working with Bullets and Numbered Lists Preview 10:51
Exercise 03 Preview 01:27
Section 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 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 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 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 Quiz
Creating Tables Preview 07:13
Formatting Tables Preview 06:19
Inserting Tables Preview 06:40
Exercise 08 Preview 01:04
Section Quiz
Adding Charts Preview 07:04
Formatting Charts Preview 12:52
Inserting Charts from Microsoft Excel Preview 04:29
Exercise 09 Preview 01:12
Section 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 Quiz
Adding Video to a Presentation Preview 06:03
Adding Audio to a Presentation Preview 05:52
Exercise 11 Preview 01:10
Section Quiz
Applying Transitions Preview 05:38
Transition Options Preview 06:04
Exercise 12 Preview 01:02
Section 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 Quiz
Working with Action Buttons Preview 06:30
Working with Hyperllinks Preview 05:04
Exercise 14 Preview 01:02
Section 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
Introduction to Access 2019 Preview 03:19
WATCH ME: Essential Information for a Successful Training Experience Preview 02:11
Course Exercise Files Preview 00:22
Course Demo Files Preview 00:22
Downloadable Course Transcripts Preview 00:15
Acquiring Access 2019 Preview 04:24
Structure of the Course Preview 02:23
Section Quiz
Using Database Templates Preview 10:56
Creating, Saving and Opening Databases Preview 06:41
The Access Workspace and Backstage Preview 13:41
Online Help and Tell Me What You Want To Do Preview 08:42
Section Quiz
Working with the Ribbon Preview 09:28
The Quick Access Toolbar Preview 05:57
Contextual Menus Preview 02:39
The Status Bar Preview 04:07
Section Quiz
Exploring Access Options Preview 09:15
Section Quiz
Creating a Table and Fields Preview 11:30
Indexed Field Preview 08:42
Lookup Wizard Preview 11:35
Numeric Fields Preview 07:46
Practice Exercise 01 Preview 03:07
Section Quiz
Design in the Datasheet View Preview 10:12
Sorting and Filtering in Datasheet View Preview 09:56
Entering and Modifying Data in Datasheet View Preview 10:56
Section Quiz
Creating a Link Table Preview 10:35
Setting up Relationships Preview 09:55
Practice Exercise 03 Preview 10:21
Section Quiz
Creating a Form Preview 12:41
Modifying a Form Preview 05:15
Practice Exercise 04 Preview 02:08
Forms in Layout View Preview 11:11
Forms in Design View Preview 10:00
Form Design Preview 11:11
Practice Exercise 05 Preview 01:33
Section Quiz
Setting Up Subforms - Part 1 Preview 13:02
Setting Up Subforms - Part 2 Preview 09:13
Setting Up Subforms - Part 3 Preview 13:24
Practice Exercise 06 Preview 04:13
Section Quiz
Creating a Query Preview 13:27
Joins Preview 08:30
Query Wizard Preview 12:39
Practice Exercise 07 Preview 09:45
Section Quiz
Basic Reports Preview 07:46
Report Design Preview 10:43
Complex Reports Preview 13:29
Practice Exercise 08 Preview 02:23
Section Quiz
Printing and Print Properties Preview 07:54
Section Quiz
Yes/No, OLE Objects and Hyperlink Data Types Preview 11:21
Section Quiz
Exporting an Access Database Preview 04:16
Section Quiz
Adding Application Parts to a Database Preview 04:48
Additional Access 2019 Options Preview 05:42
Section Quiz
Edit Database Properties and Encrypt with Password Preview 05:31
Section Quiz
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 RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic Preview 00:00
EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic Preview 00:00
EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic Preview 00:01
EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic Preview 00:01
BONUS Lecture Preview 00:20
This course includes:
- 33.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
Recent Posts
Should you take the Google IT certification in 2021?
If you want to enter the IT industry at an entry-level, you may need to become a network development programmer or even Cisco certified so ...Read more
How to save for retirement: the accounts you should know.
No matter where we are working, what is our experience and age: wealth does not come easily to us. Especially in the case of having ...Read more
Online vs Offline Learning: Which Is The Best For an Examination
Due to the COVID-19 pandemic, schools are closed. Students must stay at home and learn online. They have started online education instead of traditional education. ...Read more
Become a business administrator with these online courses
Business is everywhere. It has been here for centuries. People in the past used their ancient tactics but now we have advanced tools to nurture ...Read more
PROVEN WAYS TO IMPROVE YOUR WEAKNESSES AND BOOST YOUR CAREER
A weakness can be the biggest hindrance in your career, either it can be weak communication skills, setting goals, or doing your career planning. We ...Read more
