MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners

Learn the essentials of Microsoft Office in this 4-course bundle for Office 365 or Office 2019 users.

4.41 (1438 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
6,018
students
35.5 hours
content
Mar 2023
last update
$74.99
regular price

What you will 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

Description

**This course includes practice exercises and LIFETIME access**

Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT.

Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential.

We’re here to make sure you aren’t one of those people.

In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.


What's included?

Excel 2019

  • What's new in Excel 2019

  • Creating workbooks

  • Entering text, numbers and working with dates

  • Navigating workbooks

  • Page setup and print options

  • Working with rows, columns and cells

  • Cut, Copy and Paste

  • Introduction to functions and formulas

  • Formatting in Excel, including formatting cells and numbers

  • Creating charts and graphs

  • Sorting and Filtering

  • Introduction to PivotTables

  • Logical and lookup formulas - the basics

PowerPoint 2019

  • How to navigate around PowerPoint

  • Presentation dos and don'ts

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Using SmartArt

  • Working with Charts and Graphs

  • How to utilize Master Slides and just how much time this could save you

  • How to add audio and video to a presentation

  • All about transitions between slides

  • Animation, the animation pane and motion paths

  • Setting your slideshow options

  • Presentation preparation and delivery

  • The backstage area of PowerPoint including printing a presentation

Word 2019

  • How to get started with Word 2019

  • Word 2019 basics including navigation, editing and saving

  • Character formatting in Word including Format Painter and AutoCorrect

  • How to properly work with bullets and numbering in Microsoft Word

  • All about formatting paragraphs and managing lists

  • Working with Tables in Word including formatting, converting data and formulas

  • Page appearance including page-breaks, watermarks and styles

  • All about Sectioning a document

  • Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)

  • How to work with envelopes and labels

  • All about mail-merge and operating Word at scale

  • How to create an Index or Contents page

  • Reviewing and Printing in Word and Page Setup

  • Protecting a Word document and basic macros in Word

Microsoft Access

  • Where to start in Microsoft Access and whether to use a template or not

  • How to modify Access to suit your needs

  • All about importing data and the datasheet view

  • How tables work in Access and how to create relationships between them

  • Creating forms and sub-forms that feed data into your tables

  • How to run queries in Access

  • Setting up validations and calculations using expressions in Access

  • Printing from Access

  • To start to use macros and Modal Dialog

  • The basics of the Access web app

  • Exporting and reporting in Access

***Exercise and demo files included***


This bundle includes:

  1. 29+ hours of video tutorials

  2. 300+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…

"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."

- Yunesh Garusinghe

"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."

- Cavin Macwan

"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"

- Coreen Teoh


Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Content

Excel 2019: Introduction

Intro to Excel
Course Exercise Files
Essential Information for a Successful Training Experience
What's New In Excel 2019
Course Overview
Overview of the Excel window
Mouse-Features
Back Stage View
Section Quiz

Excel 2019 Beginner: Creating Workbooks

Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Saving Workbooks

Working with the Save and Save As Commands
File Extensions, Share, Export and Publish Files
Module 3 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Navigating Workbooks

Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Page Setup & Print Options

Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section Quiz

Excel 2019 Beginners: Working with Rows, Columns and Cells

Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section Quiz

Excel 2019 Beginners: Moving Data

Cut, Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section Quiz

Excel 2019 Beginners: Formulas & Functions

Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Working with Sheets

Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Formatting Worksheets

Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Charts

Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Working with Names

Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Sorting and Filtering

Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Outlining and Subtotaling

Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Working with Views

Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Linking Files

Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Advanced Formula Creation

If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Pivot Tables

Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Additional Excel Features

Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tabs
Module 19 - Practice Exercise
Section Quiz

Excel 2019 Beginner: Shortcuts

Excel Shortcuts Every User Should Know

Excel 2019 Beginner: Closing

Closing Video

Word 2019: Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course exercise files
Overview of the MS Word Screen
The Backstage View

Word 2019: Getting Started with Word

Creating a New Blank Document
Working with Non-Printing Characters and Line Spacing
Saving a Document
Opening a Document
Navigating a Document
Go To, Find and Replace
Editing a Document
Practice Exercise
Section Quiz

Word 2019: Character Formatting

AutoCorrect Options
Selecting Text
Cut, Copy and Paste
Character Formatting Options
Format Painter
Working with Numbers
Working with Bullets
Creating an Outline
Practice Exercise

Word 2019: Paragraph Formatting

Alignment Options
Line Spacing Options
Working with Indents
Working with Tabs
Practice Exercise
Section Quiz

Word 2019: Managing Lists

Sorting a List

Word 2019: Tables

Working with Tables
Creating a Table
Adding Rows and Columns to a Table
Formatting Table Data
Borders and Shading
Sorting in a Table
Drawing in a Table
Converting Existing Data to a Table
Quick Tables
Using Formulas in Tables
Practice Exercise
Section Quiz

Word 2019: Styles

Working with Styles
Creating Styles
Editing Styles
Practice Exercise
Section Quiz

Word 2019: Controlling Page Appearance

Working with Page Breaks
Working with Columns
Adding a Watermark
Headers and Footers
Section Quiz

Word 2019: Sectioning

What is Sectioning?
Sectioning a document
Odd and Even Sections
Practice Exercise
Section Quiz

Word 2019: Graphics

Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Icons and 3D Models
SmartArt, Charts and Screenshots
Practice Exercise
Section Quiz

Word 2019: Envelopes and Labels

Working with Envelopes
Working with Labels
Section Quiz

Word 2019: Mail Merges

What is Mail Merge?
Creating a Mail Merge Document - Part 1
Creating a Mail Merge Document - Part 2
Merging a Document with an Existing Data Source
Merging Envelopes and Labels
Merging a Directory
Practice Exercise
Section Quiz

Word 2019: Page Setup Options

Building Blocks
Auto Text
Practice Exercise
Section Quiz

Word 2019: Indexing and Table of Contents

Creating an Index
Creating a Table of Contents
Practice Exercise
Section Quiz

Word 2019: Review and Printing

Using the Thesaurus and Spell Check
Comments
Page Setup Options
Printing
Practice Exercise
Section Quiz

Word 2019: Other Word Options

Word Options
Protecting a Document
Macros

Word 2019: Wrap Up

Closing

PowerPoint 2019: Course Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course Exercise Files

PowerPoint 2019: Overview

Navigate a PowerPoint Presentation
Overview of the Screen and Views
Exercise 1

PowerPoint 2019: Getting Started

Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02
Section Quiz

PowerPoint 2019: Text and Bullet Editing Options

Formatting Text
Working with Bullets and Numbered Lists
Exercise 03
Section Quiz

PowerPoint 2019: Adding Graphics

Inserting Shapes
Inserting Graphics
Inserting Icons and 3D Models
Inserting Pictures
Exercise 04
Section Quiz

PowerPoint 2019: Working with objects

Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05
Section Quiz

PowerPoint 2019: Editing pictures

Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06
Section Quiz

PowerPoint 2019: Working with SmartArt

Creating SmartArt
Modifying SmartArt
Creating a Flowchart using SmartArt
Exercise 07
Section Quiz

PowerPoint 2019: Working with Tables

Creating Tables
Formatting Tables
Inserting Tables
Exercise 08
Section Quiz

PowerPoint 2019: Working with Charts

Adding Charts
Formatting Charts
Inserting Charts from Microsoft Excel
Exercise 09
Section Quiz

PowerPoint 2019: Unlocking the Power of Masters

Using Master Slides
Modifying Master Slides
Creating a New Master Design Template
Exercise 10
Section Quiz

PowerPoint 2019: Adding Media

Adding Video to a Presentation
Adding Audio to a Presentation
Exercise 11
Section Quiz

PowerPoint 2019: Working with Transitions

Applying Transitions
Transition Options
Exercise 12
Section Quiz

PowerPoint 2019: Animation

Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13
Section Quiz

PowerPoint 2019: Hyperlinks and Action Buttons

Working with Action Buttons
Working with Hyperllinks
Exercise 14
Section Quiz

PowerPoint 2019: Slideshow Options

Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15

PowerPoint 2019: Preparing a presentation for delivery

Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16

PowerPoint 2019: Exploring the Backstage Area

Exporting options
The Backstage Area
Printing a Presentation
Exercise 17

PowerPoint 2019: Course Close

Conclusion

Access 2019 Beginners: Introduction

Introduction to Access 2019
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Acquiring Access 2019
Structure of the Course
Section Quiz

Access 2019 Beginners: Getting Started with Access 2019

Using Database Templates
Creating, Saving and Opening Databases
The Access Workspace and Backstage
Online Help and Tell Me What You Want To Do
Section Quiz

Access 2019 Beginners: The Ribbon and Toolbars

Working with the Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar
Section Quiz

Access 2019 Beginners: Keyboard Shortcuts and Key Tip

Keyboard Shortcuts
Key Tips
Section Quiz

Access 2019 Beginners: Access Options

Exploring Access Options
Section Quiz

Access 2019 Beginners: Tables

Creating a Table and Fields
Indexed Field
Lookup Wizard
Numeric Fields
Practice Exercise 01
Section Quiz

Access 2019 Beginners: Importing Data

Importing Data from Excel
Practice Exercise 02
Section Quiz

Access 2019 Beginners: Backup, Restore and Repair

Backing up your Database
Compact and Repair
Section Quiz

Access 2019 Beginners: Datasheet View

Design in the Datasheet View
Sorting and Filtering in Datasheet View
Entering and Modifying Data in Datasheet View
Section Quiz

Access 2019 Beginners: Relationships

Creating a Link Table
Setting up Relationships
Section Quiz

Access 2019 Beginners: Forms

Creating a Form
Modifying a Form
Practice Exercise 04
Forms in Layout View
Forms in Design View
Form Design
Practice Exercise 05
Section Quiz

Access 2019 Beginners: Subforms

Setting Up Subforms - Part 1
Setting Up Subforms - Part 2
Setting Up Subforms - Part 3
Practice Exercise 06
Section Quiz

Access 2019 Beginners: Queries

Creating a Query
Joins
Query Wizard
Practice Exercise 07
Section Quiz

Access 2019 Beginners: Expressions

Setting Up Validations
Calculation using Expressions
Section Quiz

Access 2019 Beginners: Reports

Basic Reports
Report Design
Complex Reports
Practice Exercise 08
Section Quiz

Access 2019 Beginners: Printing

Printing and Print Properties
Section Quiz

Access 2019 Beginners: More Data Types

Yes/No, OLE Objects and Hyperlink Data Types
Section Quiz

Access 2019 Beginners: More About Forms

Form Controls
Form Themes
Navigation Forms
Section Quiz

Access 2019 Beginners: Exporting

Exporting an Access Database
Section Quiz

Access 2019 Beginners: Application Parts

Adding Application Parts to a Database

Access 2019 Beginners: More Access Options

Additional Access 2019 Options
Section Quiz

Access 2019 Beginners: Info Tab

Edit Database Properties and Encrypt with Password
Section Quiz

Access 2019 Beginners: Course Close

Course Close

Screenshots

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Screenshot_01MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Screenshot_02MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Screenshot_03MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Screenshot_04

Reviews

Ridwan
October 25, 2023
I have not finished the whole course, but I can tell that this course is really amazing. I really learned a lot from it. Therefore, I can say this course is pretty much satisfying. Thank you to all the mentors, wish you all the best luck.
Urvish
June 2, 2023
This is best experience ever in online course . That great simple and easy to understand. Thx to make videos.
Vaishali
May 21, 2023
It was really nice detailed explanation on each topic with examples and short cuts. nice practice sheets to keep practicing .
Rabia
May 16, 2023
I learned alot through these videos. Professors are really good. Looking for taking more courses after completing this microsoft office course.
Jennifer
March 23, 2023
I do have word experience but it has been many years. I am using this course as a review because there are new features that I’m not familiar with. The instructor explains and demonstrates everything well, so far.
Jennifer
March 7, 2023
I have zero experience with Excel and this is perfect! Starting from the basics is exactly what I need!
Heng
February 10, 2023
There are a lot of new things I learned from taking these courses. The instructor was clear and easy to follow along with. I really enjoyed this 4-couse bundle.
Travis
January 22, 2023
This is to hard for me... need to get something more for beginners...sorry. may i request my money back. instructor is good but is to difficult for me.
Kanani
November 7, 2022
It is well thought of, not leaving any basics behind, even those that would look obvious to someone attending an online (computer) course. The works is well explained.
Plangret
September 27, 2022
This is definitely a good match for me. The instructors are concise and very clear in their explanations.
Rakwadu
August 3, 2022
This course is a blessing because it teaches me well than the teachers at school. And i wish most learners could come to this course.
Avisek
May 15, 2022
MS Office - 2019 for beginners , as the name suggests it teaches the basics of MS Office, as it turned out after taking this course I learnt to be: 1) More organized 2) Save time while working with MS office As I had prior experience with MS office I didn't learn many things I just brushed up my basics.
Shola
April 14, 2022
Yes but i still have to go it a multiple of times to grasp the principles. The presentation is really simplified
Zayra
March 17, 2022
Cindy is pleasant to listen to, knowledgeable and goes at a pace I can keep up with. So far, it is a good fit for me.
Rosa
October 27, 2021
I thought that I had a lot of knowledge about how to work MS until I started this course, everyday I'm surprised by the amount of new tricks and things that I didn't know could be done. So worth the money and time !

Coupons

DateDiscountStatus
6/22/202291% OFF
expired

Charts

Price

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Price chart

Rating

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Ratings chart

Enrollment distribution

MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners - Distribution chart
2743622
udemy ID
1/7/2020
course created date
1/19/2020
course indexed date
Bot
course submited by