Ultimate Microsoft Office; Excel, Word, PowerPoint

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