Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

**This course consists of apply workouts and LIFETIME entry**

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

The Microsoft Office suite is utilized by tens of millions worldwide. Unlocking its full potential might see you drastically enhance your productiveness.

But you already know all that since you’re on this web page.

Instead, you’re most likely questioning whether or not we’re the proper crew to show you Office.

Simon Sez IT has been educating MS Office for over 13 years, and we’ve acquired fairly good at it. Just check out our Udemy rankings in the event you don’t imagine us.

For this Ultimate Microsoft Office 2019 course, we’ve bundled collectively 9 of our best-selling titles into one large worth providing.

You don’t simply get entry to newbie programs both. You get superior coaching in Microsoft Excel and Microsoft Access and a complete 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 coated in every course?

Microsoft Excel 2019

• What’s new in Excel 2019

• Creating workbooks

• Entering textual content, numbers and dealing with dates

• Navigating workbooks

• Page setup and print choices

• Working with rows, columns, and cells

• Cut, Copy and Paste

• Introduction to Functions and Formulas

• Formatting in Excel, together with formatting cells and numbers

• Creating charts and graphs

• Sorting and Filtering

• Introduction to PivotTables

• Logical and lookup formulation – the fundamentals

Advanced Microsoft Excel 2019

• What’s new/totally different in Excel 2019

• Advanced charting and graphing in Excel

• How to make use of detailed formatting instruments

• Lookup and superior lookup features

• Financial features together with calculating curiosity and depreciation

• Statistical features

• Connecting to different workbooks and datasets exterior of Excel e.g. MS Access and the online.

• How to create superior visualizations utilizing sparklines and information bars

• Mastery of PivotTables and Pivot Charts

• Scenario Manager, Goal Seek, and Solver

• Advanced charts comparable to Surface, Radar, Bubble, and Stock Charts

Microsoft PowerPoint 2019

• How to navigate round PowerPoint

• Presentation dos and don’ts

• Text and bullet version choices

• How to make use of graphics, pictures, objects, and shapes

• Using SmartArt

• Working with Charts and Graphs

• How to make the most of Master Slides and simply how a lot time this might prevent

• How so as to add audio and video to a presentation

• All about transitions between slides

• Animation, the animation pane, and movement paths

• Setting your slideshow choices

• Presentation preparation and supply

• The backstage space of PowerPoint together with printing a presentation

Microsoft Word 2019

• How to get began with Word 2019

• Word 2019 fundamentals together with navigation, modifying, and saving

• Character formatting in Word together with Format Painter and AutoCorrect

• How to correctly work with bullets and numbering in Microsoft Word

• All about formatting paragraphs and managing lists

• Working with Tables in Word together with formatting, changing information and formulation

• Page look together with page-breaks, watermarks, and kinds

• All about Sectioning a doc

• Inserting graphics, footage, shapes, icons, and 3d fashions (new for 2019)

• How to work with envelopes and labels

• All about mail-merge and working Word at scale

• How to create an Index or Contents web page

• Reviewing and Printing in Word and Page Setup

• Protecting a Word doc and fundamental macros in Word

Microsoft Access 2019

• Where to begin in Microsoft Access and whether or not to make use of a template or not

• How to change Access to fit your wants

• All about importing information and the datasheet view

• How tables work in Access and methods to create relationships between them

• Creating varieties and sub-forms that feed information into your tables

• How to run queries in Access

• Setting up validations and calculations utilizing expressions in Access

• Printing from Access

• To begin to use macros and Modal Dialog

• The fundamentals of the Access net 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 hyperlink to different databases

• All about utilizing ODBC and SQL Server

• How to separate an Access database into entrance and back-end

• All about Macros in Access together with AutoExec

• How to do fundamental VBA in Access together with code and error dealing with

• More superior strategies round creating varieties in Access

• Advanced queries together with “multiple where” standards

Microsoft Outlook 2019

• How to get arrange in Outlook

• Some helpful Outlook keyboard shortcuts

• All about sending and receiving emails

• How to customise your mailbox and examine

• How to look in Outlook

• How to prepare and handle your mail together with ignoring, flagging, and conditional formatting

• How to successfully take care of Junk Mail

• Attaching information, pictures, and graphics in Outlook

• About recalling a message

• How to make use of signatures and voting buttons

• How to greatest use, add to, and handle contacts

• Working with the Outlook Calendar, together with creating conferences and appointments

• How to share Calendars with colleagues

• How to make use of Tasks in Outlook

• How to create Notes and hyperlink Outlook to OneNote

• How to print the proper factor in Outlook

Microsoft Teams

• How to entry, obtain and arrange Teams

• How to create your first crew and handle members and channels

• All about posting and receiving private and non-private messages

• How to do person bulletins, tags, and message extensions

• How to schedule an audio or video name

• How to make use of the audio and video calling choices together with recording calls

• How to make use of the assembly notes perform

• How to create a wiki

• All about utilizing apps, bots, and connectors

• How to regulate admin and person settings

• How to make use of Teams in your cell gadget

Microsoft OneNote

• How to get began utilizing OneNote Desktop or OneNote Windows 10

• How so as to add textual content, movies, pictures, clips, and hyperlinks to OneNote

• How to make use of the display clipping software in OneNote

• How to format notes in OneNote

• How to create a to-do record in OneNote

• How so as to add tags in OneNote and seek for content material

• How to hyperlink notes in OneNote

• How to format pages in OneNote

• How to make use of the pen instruments in OneNote, together with handwriting to textual content

• How to hyperlink OneNote with Outlook

• How to share notebooks in OneNote

• How to collaborate utilizing OneNote

• How to customise your choices in OneNote

• About utilizing OneNote Online and the OneNote App

***Exercise and demo information included***

This bundle consists of:

1. 68+ hours of video tutorials

2. 600+ particular person video lectures

3. Exercise information to apply what you realized

4. Certificate of completion

5. NINE full-length Microsoft programs

These programs had been all recorded within the 2019 variations of MS Office however are nonetheless relevant in the event you’re working with Office 2013, 2016, or Office 365. Microsoft Teams and Microsoft OneNote had been recorded utilizing Office 365.

Here’s what our college 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

Who this course is for:

• Anyone new to Microsoft Office or upgrading from a earlier model
• Anyone trying to enhance their productiveness by mastering MS Office