Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access, available at $159.99, has an average rating of 4.62, with 634 lectures, 122 quizzes, based on 14078 reviews, and has 70288 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone new to Microsoft Office or upgrading from a previous version or Anyone looking to improve their productivity by mastering MS Office It is particularly useful for Anyone new to Microsoft Office or upgrading from a previous version or Anyone looking to improve their productivity by mastering MS Office.

Enroll now: Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Summary

Title: Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Price: $159.99

Average Rating: 4.62

Number of Lectures: 634

Number of Quizzes: 122

Number of Published Lectures: 634

Number of Published Quizzes: 122

Number of Curriculum Items: 756

Number of Published Curriculum Objects: 756

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

Anyone new to Microsoft Office or upgrading from a previous version
Anyone looking to improve their productivity by mastering MS Office

Target Audiences

Anyone new to Microsoft Office or upgrading from a previous version
Anyone looking to improve their productivity by mastering MS Office

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

Course Curriculum

Chapter 1: Excel 2019: Introduction

Lecture 1: Intro to Excel

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: Course Exercise Files

Lecture 4: Downloadable Course Transcript

Lecture 5: What's New In Excel 2019

Lecture 6: Course Overview

Lecture 7: Overview of the Excel window

Lecture 8: Mouse-Features

Lecture 9: Back Stage View

Chapter 2: Excel 2019 Beginner: Creating Workbooks

Lecture 1: Entering Text and Numbers

Lecture 2: Creating Basic Formulas

Lecture 3: Relative References

Lecture 4: Order of Operations

Lecture 5: Working with Ranges

Lecture 6: Module 2 – Practice Exercise

Chapter 3: Excel 2019 Beginner: Saving Workbooks

Lecture 1: Working with the Save and Save As Commands

Lecture 2: File Extensions, Share, Export and Publish Files

Lecture 3: Module 3 – Practice Exercise

Chapter 4: Excel 2019 Beginner: Navigating Workbooks

Lecture 1: Opening a File

Lecture 2: Working with Larger Files

Lecture 3: Freeze Panes Option

Lecture 4: Split Screen Option

Lecture 5: Module 4 – Practice Exercise

Chapter 5: Excel 2019 Beginner: Page Setup & Print Options

Lecture 1: Headers and Footers

Lecture 2: Print Titles

Lecture 3: Comments

Lecture 4: Page Setup Options

Lecture 5: Fit to Print on One Page

Lecture 6: Printing Workbooks

Lecture 7: Module 5 – Practice Exercise

Chapter 6: Excel 2019 Beginners: Working with Rows, Columns and Cells

Lecture 1: Adding and deleting rows columns and cells

Lecture 2: Changing Column and-Row Widths

Lecture 3: Module 6 – Practice Exercise

Chapter 7: Excel 2019 Beginners: Moving Data

Lecture 1: Cut, Copy and Paste

Lecture 2: Copying Formulas

Lecture 3: Module 7 – Practice Exercise

Chapter 8: Excel 2019 Beginners: Formulas & Functions

Lecture 1: Overview of Formulas

Lecture 2: Create Formulas Using Functions Part 1

Lecture 3: Create Formulas Using Functions Part 2

Lecture 4: Absolute Values

Lecture 5: Module 8 – Practice Exercise

Chapter 9: Excel 2019 Beginner: Working with Sheets

Lecture 1: Adding Deleting and Renaming Sheets

Lecture 2: Additional Sheet Tab Options

Lecture 3: 3 Dimensional Formulas

Lecture 4: Module 9 – Practice Exercise

Chapter 10: Excel 2019 Beginner: Formatting Worksheets

Lecture 1: Formatting Cells Part 1

Lecture 2: Formatting Cells Part 2

Lecture 3: Formatting Numbers

Lecture 4: Borders and Shading

Lecture 5: Format as Table

Lecture 6: Using Styles

Lecture 7: Using Format Painter

Lecture 8: Protecting Sheets

Lecture 9: Fill Handle and Custom Lists

Lecture 10: Module 10 – Practice Exercise

Chapter 11: Excel 2019 Beginner: Charts

Lecture 1: Creating Charts

Lecture 2: Types of Charts

Lecture 3: Editing Charts Part 1

Lecture 4: Editing Charts Part 2

Lecture 5: Using Graphics to Enhance Charts

Lecture 6: Linking Chart Titles

Lecture 7: Module 11 – Practice Exercise

Chapter 12: Excel 2019 Beginner: Working with Names

Lecture 1: Creating Range Names

Lecture 2: Managing Names

Lecture 3: Using Names in Formulas

Lecture 4: Module 12 – Practice Exercise

Chapter 13: Excel 2019 Beginner: Sorting and Filtering

Lecture 1: Remove Duplicates

Lecture 2: Sort Data

Lecture 3: Filter Data

Lecture 4: Advanced Filters

Lecture 5: Module 13 – Practice Exercise

Chapter 14: Excel 2019 Beginner: Outlining and Subtotaling

Lecture 1: Creating an Outline

Lecture 2: Subtotals

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 159 votes
2 stars: 208 votes
3 stars: 1262 votes
4 stars: 4574 votes
5 stars: 7875 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu