Ultimate Microsoft Office; Excel, Word, PowerPoint & Access [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access is a top-rated Udemy course taught by Simon Sez IT — with over 77704+ students enrolled since it launched.

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

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on Ultimate Microsoft Office; Excel, Word, PowerPoint & Access won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the Ultimate Microsoft Office; Excel, Word, PowerPoint & Access Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access Udemy Promotion code

Course Sections
Excel 2019: Introduction
Excel 2019 Beginner: Creating Workbooks
Excel 2019 Beginner: Saving Workbooks
Excel 2019 Beginner: Navigating Workbooks
Excel 2019 Beginner: Page Setup & Print Options
Excel 2019 Beginners: Working with Rows, Columns and Cells
Excel 2019 Beginners: Moving Data
Excel 2019 Beginners: Formulas & Functions
Excel 2019 Beginner: Working with Sheets
Excel 2019 Beginner: Formatting Worksheets
Excel 2019 Beginner: Charts
Excel 2019 Beginner: Working with Names
Excel 2019 Beginner: Sorting and Filtering
Excel 2019 Beginner: Outlining and Subtotaling
Excel 2019 Beginner: Working with Views
Excel 2019 Beginner: Linking Files
Excel 2019 Beginner: Advanced Formula Creation
Excel 2019 Beginner: Pivot Tables
Excel 2019 Beginner: Additional Excel Features
Excel 2019 Beginner: Shortcuts
Excel 2019 Beginner: Closing
Excel 2019 Advanced: Intro to Advanced Course
Excel 2019 Advanced: Functions
Excel 2019 Advanced: Date and Time Functions
Excel 2019 Advanced: Text Functions
Excel 2019 Advanced: Logical Functions
Excel 2019 Advanced: Lookup Functions
Excel 2019 Advanced: Financial Functions
Excel 2019 Advanced: Statistical Functions
Excel 2019 Advanced: Connecting to External Data
Excel 2019 Advanced: Tables
Excel 2019 Advanced: Pivot Tables
Excel 2019 Advanced: Data Analysis
Excel 2019 Advanced: Graphs and Charts
Excel 2019 Advanced: Excel Web App
Excel 2019 Advanced: Course Conclusion
Word 2019: Introduction
Word 2019: Getting Started with Word
Word 2019: Character Formatting
Word 2019: Paragraph Formatting
Word 2019: Managing Lists
Word 2019: Tables
Word 2019: Styles
Word 2019: Controlling Page Appearance
Word 2019: Sectioning
Word 2019: Graphics
Word 2019: Envelopes and Labels
Word 2019: Mail Merges
Word 2019: Page Setup Options
Word 2019: Indexing and Table of Contents
Word 2019: Review and Printing
Word 2019: Other Word Options
Word 2019: Wrap Up
PowerPoint 2019: Course Introduction
PowerPoint 2019: Overview
PowerPoint 2019: Getting Started
PowerPoint 2019: Text and Bullet Editing Options
PowerPoint 2019: Adding Graphics
PowerPoint 2019: Working with objects
PowerPoint 2019: Editing pictures
PowerPoint 2019: Working with SmartArt
PowerPoint 2019: Working with Tables
PowerPoint 2019: Working with Charts
PowerPoint 2019: Unlocking the Power of Masters
PowerPoint 2019: Adding Media
PowerPoint 2019: Working with Transitions
PowerPoint 2019: Animation
PowerPoint 2019: Hyperlinks and Action Buttons
PowerPoint 2019: Slideshow Options
PowerPoint 2019: Preparing a presentation for delivery
PowerPoint 2019: Exploring the Backstage Area
PowerPoint 2019: Course Close
Access 2019 Beginners: Introduction
Access 2019 Beginners: Getting Started with Access 2019
Access 2019 Beginners: The Ribbon and Toolbars
Access 2019 Beginners: Keyboard Shortcuts and Key Tip
Access 2019 Beginners: Access Options
Access 2019 Beginners: Tables
Access 2019 Beginners: Importing Data
Access 2019 Beginners: Backup, Restore and Repair
Access 2019 Beginners: Datasheet View
Access 2019 Beginners: Relationships
Access 2019 Beginners: Forms
Access 2019 Beginners: Subforms
Access 2019 Beginners: Queries
Access 2019 Beginners: Expressions
Access 2019 Beginners: Reports
Access 2019 Beginners: Printing
Access 2019 Beginners: More Data Types
Access 2019 Beginners: More About Forms
Access 2019 Beginners: Exporting
Access 2019 Beginners: Application Parts
Access 2019 Beginners: More Access Options
Access 2019 Beginners: Info Tab
Access 2019 Beginners: Course Close
Access 2019 Advanced: Introduction
Access 2019 Advanced: Primary Keys and Indexes
Access 2019 Advanced: Using Datasheet View
Access 2019 Advanced: Linking to Other Access Databases
Access 2019 Advanced: Using ODBC and SQL Server
Access 2019 Advanced: Splitting an Access Database
Access 2019 Aadvanced: Macros
Access 2019 Advanced: The Ribbon
Access 2019 Advanced: Visual Basic for Applications
Access 2019 Advanced: Access Events Model
Access 2019 Advanced: Forms
Access 2019 Advanced: Advanced Use of Queries
Access 2019 Advanced: Packaging You Application
Conclusion
Outlook 2019: Introduction
Setting Up Outlook
Sending and Receiving Mail
Searching Mail
Organizing and Managing Mail
Creating and Sending Mail
Working with People
Working with the Calendar
Tasks and Notes
The Backstage Options
Conclusion
Congratulations!
Microsoft Teams: Introduction
Creating Teams and Starting Conversations
Video and Audio Meetings
Additional Features
Searching
Settings
Mobile App
Teams Updates (2021)
MS Teams: Conclusion
An Introduction to OneNote
OneNote: Getting Started
OneNote: Adding Content
OneNote: Formatting Notes
OneNote: Organizing Content
OneNote: Formatting Pages
OneNote: Working with Templates
OneNote: Using Drawing Tools
OneNote: Interacting with Outlook
OneNote: Sharing a Notebook
OneNote: Collaborating on a Notebook
OneNote: Setting OneNote Options
Other Versions of OneNote
OneNote: Course Close
Extras
Additional Training
Course Description
Requirements
Excel, Word, PowerPoint, Access, Teams and Outlook installed on your machine. Preferably Office 2019 or Office 365

**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:

68+ hours of video tutorials

600+ individual video lectures

Exercise files to practice what you learned

Certificate of completion

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