Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Learn basic to advanced Microsoft Office skills in this 9-course bundle for Office 365 or Office 2019

4.53 (12912 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
64,811
students
70.5 hours
content
Jan 2024
last update
$159.99
regular price

What you will learn

Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access

HUGE Value Bundle - Eight Courses!

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

How to get set up in Outlook

All about sending and receiving emails

How to customize your mailbox and view

How to organize and manage your mail including ignoring, flagging and conditional formatting

How to organize and manage your mail including ignoring, flagging and conditional formatting

Creating and managing tasks and reminders

How to use signatures and voting buttons

Adding, managing and searching contacts in the address book

Working with the Outlook Calendar, including creating meetings and appointments

How to create Notes and link Outlook to OneNote

Description

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

Learn Excel, PowerPoint, Access, Outlook, Teams, OneNote, and Word with this tremendous value 9-course bundle from Simon Sez IT.

The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.

But you know all that because you’re on this page.

Instead, you’re probably wondering whether we’re the right team to teach you Office.

Simon Sez IT has been teaching MS Office for over 13 years, and we’ve got pretty good at it. Just take a look at our Udemy ratings if you don’t believe us.

For this Ultimate Microsoft Office 2019 course, we’ve bundled together 9 of our best-selling titles into one huge value offering.

You don’t just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Microsoft Word, and Microsoft OneNote.


***UPDATED APRIL 2020 - Outlook 2019 Added***

***UPDATED May 2020 - Microsoft Teams Added***

***UPDATED 2021 - Microsoft OneNote Added**


What's covered in each course?

Microsoft 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


Advanced Microsoft Excel 2019

  • What's new/different in Excel 2019

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Financial functions including calculating interest and depreciation

  • Statistical functions

  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

  • How to create awesome visualizations using sparklines and data bars

  • Mastery of PivotTables and Pivot Charts

  • Scenario Manager, Goal Seek, and Solver

  • Advanced charts such as Surface, Radar, Bubble, and Stock Charts


Microsoft 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


Microsoft 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 2019

  • 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


Advanced Microsoft Access 2019

  • About Primary Keys and Indexes in Access

  • About customizing and filtering on the Datasheet View

  • How to link to other databases

  • All about using ODBC and SQL Server

  • How to split an Access database into front and back-end

  • All about Macros in Access including AutoExec

  • How to do basic VBA in Access including code and error handling

  • More advanced techniques around creating forms in Access

  • Advanced queries including “multiple where” criteria


Microsoft Outlook 2019

  • How to get set up in Outlook

  • Some useful Outlook keyboard shortcuts

  • All about sending and receiving emails

  • How to customize your mailbox and view

  • How to search in Outlook

  • How to organize and manage your mail including ignoring, flagging, and conditional formatting

  • How to effectively deal with Junk Mail

  • Attaching files, photos, and graphics in Outlook

  • About recalling a message

  • How to use signatures and voting buttons

  • How to best use, add to, and manage contacts

  • Working with the Outlook Calendar, including creating meetings and appointments

  • How to share Calendars with colleagues

  • How to use Tasks in Outlook

  • How to create Notes and link Outlook to OneNote

  • How to print the right thing in Outlook


Microsoft Teams

  • How to access, download and set up Teams

  • How to create your first team and manage members and channels

  • All about posting and receiving public and private messages

  • How to do user announcements, tags, and message extensions

  • How to schedule an audio or video call

  • How to use the audio and video calling options including recording calls

  • How to use the meeting notes function

  • How to create a wiki

  • All about using apps, bots, and connectors

  • How to adjust admin and user settings

  • How to use Teams on your mobile device


Microsoft OneNote

  • How to get started using OneNote Desktop or OneNote Windows 10

  • How to add text, videos, images, clips, and links to OneNote

  • How to use the screen clipping tool in OneNote

  • How to format notes in OneNote

  • How to create a to-do list in OneNote

  • How to add tags in OneNote and search for content

  • How to link notes in OneNote

  • How to format pages in OneNote

  • How to use the pen tools in OneNote, including handwriting to text

  • How to link OneNote with Outlook

  • How to share notebooks in OneNote

  • How to collaborate using OneNote

  • How to customize your options in OneNote

  • About using OneNote Online and the OneNote App


***Exercise and demo files included***


This bundle includes:

  1. 68+ hours of video tutorials

  2. 600+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

  5. NINE full-length Microsoft courses

These courses were all recorded in the 2019 versions of MS Office but are still applicable if you’re working with Office 2013, 2016, or Office 365. Microsoft Teams and Microsoft OneNote were recorded using Office 365.


Here’s what our students are saying…

"I'm finding this course very helpful and the instructor is very easy to understand. I am learning so much more than I did from another course I tried to take and lost interest in. This course has really kept my interest."
- Dianne Munizza

"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."
- Monica Yvette Disbrow

"It's still early on in the course, but I love it. He's so very clear with each tiny thing he's teaching you. He sounds quite like a gentle and patient friend or mentor walking you through step by step. He also repeats things (not monotonously) which helps you retain what you're learning. When I first registered for this course, I thought 'oh my goodness, what have I done'... when you look at the 'your progress' dropdown at the upper right corner of your dashboard and see that you're on #21 of 518(!), it can seem a bit intimidating. But, no -- I think with this particular instructor's gift of friendly teaching, we'll all do fantastically well!"
- Celine Barton

Content

Excel 2019: Introduction

Intro to Excel
Essential Information for a Successful Training Experience
Course Exercise Files
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

Excel 2019 Advanced: Intro to Advanced Course

Introduction to the Course
Essential Information for a Successful Training Experience
Excel 2019 Advanced Course Exercise Files
Excel 2019 Advanced Course Demo Files
Course Structure

Excel 2019 Advanced: Functions

Functions - Part 1
Functions - Part 2
Autosum
Section Quiz

Excel 2019 Advanced: Date and Time Functions

How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions
Section Quiz

Excel 2019 Advanced: Text Functions

Using Text Functions - Part 1
Using Text Functions - Part 2
Section Quiz

Excel 2019 Advanced: Logical Functions

Logical Functions
Exercise 01
Section Quiz

Excel 2019 Advanced: Lookup Functions

Lookup Functions - Part 1
Lookup Functions - Part 2
Exercise 02
Section Quiz

Excel 2019 Advanced: Financial Functions

Financial Functions and Terminology
Personal Financial Functions
Principal and Interest Payments
Depreciation
Exercise 03
Section Quiz

Excel 2019 Advanced: Statistical Functions

Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference
Section Quiz

Excel 2019 Advanced: Connecting to External Data

Connecting to Other workbooks
Connecting to Access Databases
Connecting Web Data Sources
Get and Transform
Exercise 05
Section Quiz

Excel 2019 Advanced: Tables

Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 6
Section Quiz

Excel 2019 Advanced: Pivot Tables

Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot and Charts
Exercise 07
Section Quiz

Excel 2019 Advanced: Data Analysis

What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08
Section Quiz

Excel 2019 Advanced: Graphs and Charts

Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 9
Section Quiz

Excel 2019 Advanced: Excel Web App

Web App - Part 1
Web App - Part 2
Section Quiz

Excel 2019 Advanced: Course Conclusion

Close

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

Access 2019 Advanced: Introduction

Course Overview and Content
Essential Information for a Successful Training Experience
Course Exercise Files
Section Quiz

Access 2019 Advanced: Primary Keys and Indexes

Primary Keys and Indexing Rules and Guidelines
More About Indexes
Section Quiz

Access 2019 Advanced: Using Datasheet View

Setting-up Northwind Database
Working in a Datasheet View
Customizing Datasheet View and Advanced Sorting and Filtering
Subdatasheets
Exercise 01
Section Quiz

Access 2019 Advanced: Linking to Other Access Databases

Linking Two Tables to Other Access Databases
Section Quiz

Access 2019 Advanced: Using ODBC and SQL Server

Acquiring and Installing SQL Server Express
Setting Up SQL Server Database
Exercise 02
Section Quiz

Access 2019 Advanced: Splitting an Access Database

Splitting an Access Database into Front-end and Back-end
Converting Shared Table into Local Table; Moving Back-end Database
Exercise 03
Addressing Multi-user Issues when Sharing Data
Section Quiz

Access 2019 Aadvanced: Macros

Basics of Macros
Macros on Events; AutoExec
More About AutoExec; Bypassing AutoExec
Macro Security Settings
Exercise 04
Section Quiz

Access 2019 Advanced: The Ribbon

Customizing the Ribbon and Quick Access Tool
Section Quiz

Access 2019 Advanced: Visual Basic for Applications

Convert Macros to VBA; VBA Editor and Property Windows
VBA Modules; Running Code and Error Handling
Creating Modules; Subs, Functions, Intellisense and Variables
Scope, Variable Naming and Strings
Standard Functions; Logical, Case and Loop Statements
Section Quiz

Access 2019 Advanced: Access Events Model

Adding Events to Assets Database
Exercise 05
Common Events; Form and Report Events
Switchboard and Navigation Form; Error Handling
Exercise 06
Section Quiz

Access 2019 Advanced: Forms

Formatting Bound and Control Form
Split Forms; Macro Error Handling
Creating Form with Tab
Go To Combo Box and Its Properties
Exercise 07
Section Quiz

Access 2019 Advanced: Advanced Use of Queries

Basics of Queries
Syntax of SQL Statements
Use of Multiple Where Criteria & Select Statements Function
Exercise 08
Action Queries - Part 1
Action Queries - Part 2
Section Quiz

Access 2019 Advanced: Packaging You Application

Steps in Packaging Access Application
Exercise 9
Section Quiz

Conclusion

Course Close

Screenshots

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Screenshot_01Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Screenshot_02Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Screenshot_03Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Screenshot_04

Reviews

Socorro
November 16, 2023
Great introduction. Slowly but surely Tips and Tricks are being show’n to become an advanced excel user.
Michael
November 11, 2023
I'm just starting the course and it's an excellent course! My MS Office skills are really rusty so I especially need the Word and the PowerPoint for school next semester. I'm no only relearning things I've forgotten and brushing up on things I already know but I'm also learning new things as well. Thank you so much Deborah! Michael
Devam
November 9, 2023
My experience for taking this course was very good for and the steps are easy to learn and are very clear.
SIVIWE
November 5, 2023
because I had the best experience with the course content and the lectures, I believe that. I have gained a lot of knowledge and skills.
Chesca
November 1, 2023
I have spent money on quite a few courses that were informational, but lacking in depth. This course is a cut above the rest! Very detailed, and easy to follow along. I feel this course actually provides hands on practical skills to feel competent with the MS products. Thank you!
Nicole
October 23, 2023
So far, I think the course is very well paced and the instructor does a great job at explaining what she's doing step-by-step.
Riyanka
October 21, 2023
It's amazing course that I learned from this course it's easy to understand the step wise about excel
Rudy
August 29, 2023
It was good learning about concat, but feel like we wasn't shown how to do it towards the end when clicking all the multiple names? Bit confused
Amol
August 26, 2023
Its very nicely designed ,and the language,speed and the way the instructor speaks is very good and easy to learn. Amol
Ankit
August 21, 2023
If anyone want to understand the basic of various Microsoft application, this is the best course available.
Cierra
August 18, 2023
This course is perfect! As a complete beginner, I'm thrilled Cindy started from the basics. This course is giving me the confidence to start a new career.
Jobelle
August 12, 2023
Rating: ⭐⭐⭐⭐⭐ (5/5) Review Whether you are a student, a professional, or someone looking to enhance your Microsoft skills, I highly recommend this course. The structured curriculum, quality instruction, and interactive interface are excellent. Don't hesitate to get started and unlock a world of opportunities.
Muhammad
August 8, 2023
good explanation and very interesting education about learning and using Ms office apps for work and study needs. Thankyou Simon Sez IT
Nicolò
August 6, 2023
Very good, the course goes in great detail. The only thing is that it's a bit too long. Great to have a lot of resources and exercises to practice with
Anjali
August 5, 2023
happy to learn my classes through Udemy, every class has exercises and tasks to improve my hands on experience a lot.

Coupons

DateDiscountStatus
11/12/202094% OFF
expired

Charts

Price

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Price chart

Rating

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Ratings chart

Enrollment distribution

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access - Distribution chart
2743630
udemy ID
1/7/2020
course created date
1/19/2020
course indexed date
Bot
course submited by