Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

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.5
☆☆☆☆☆ 4.5/5
(6,880 reviews)
34,290 students
Created by
Simon Sez IT

9.7

Classbaze Grade®

9.4

Freshness

9.2

Popularity

10.0

Material

Detailed Analysis »

Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019
Go to course »
Platform: Udemy
Price: check current price
Video: 68h 39m
Language: English
Next start: On Demand

Best Microsoft Office classes:

Skillshare_logo_2020
Best Microsoft Office classes on Skillshare »
Coursera Logo
Best Microsoft Office classes on Coursera »
Pluralsight Logo
BestMicrosoft Office classes on PluralSight »
Udemy logo
Best Microsoft Office classes on Udemy »
linkedin
Best Microsoft Office classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

9.7 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

9.4 / 10
This course was last updated on 10/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

9.2 / 10
We analyzed factors such as the rating (4.5/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

10.0 / 10
Video Score: 10.0 / 10
The course includes 68h 39m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 11 hours 19 minutes of 76 Microsoft Office courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

21 articles.
12 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

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

What can you learn from this course?

✓ 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

What you need to start the course?

• Excel, Word, PowerPoint, Access, Teams and Outlook installed on your machine. Preferably Office 2019 or Office 365

Who is this course is made for?

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

Are there coupons or discounts for Ultimate Microsoft Office; Excel, Word, PowerPoint & Access ? What is the current price?

The course costs $24.99. And currently there is a 81% discount on the original price of the course, which was $129.99. So you save $105 if you enroll the course now.
The average price is $13.9 of 76 Microsoft Office courses. So this course is 80% more expensive than the average Microsoft Office course on Udemy.

Will I be refunded if I'm not satisfied with the Ultimate Microsoft Office; Excel, Word, PowerPoint & Access course?

YES, Ultimate Microsoft Office; Excel, Word, PowerPoint & Access has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Ultimate Microsoft Office; Excel, Word, PowerPoint & Access course, but there is a $105 discount from the original price ($129.99). So the current price is just $24.99.

Who will teach this course? Can I trust Simon Sez IT?

Simon Sez IT has created 192 courses that got 76,669 reviews which are generally positive. Simon Sez IT has taught 587,307 students and received a 4.5 average review out of 76,669 reviews. Depending on the information available, we think that Simon Sez IT is an instructor that you can trust.

Learn everything about

Simon Sez IT

575000+ Students | Wordwide Use 183 Countries | 190+ Courses
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity – no matter whether you are implementing new software or a technological upgrade for your workplace. With over 575,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 
Browse all courses by on Classbaze.
Simon Sez IT's full profile and courses »
Go to class »

9.7

Classbaze Grade®

9.4

Freshness

9.2

Popularity

10.0

Material

Detailed Analysis »

Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019
Go to course »
Platform: Udemy
Price: check current price
Video: 68h 39m
Language: English
Next start: On Demand

Classbaze recommendations for you

Other courses by ​Simon Sez IT

Go to class »