ultimate-microsoft-office-excel-word-powerpoint--access

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!

Practical Learn Methods to Backup and Recover Your Excel spreadsheets and Never Loset Data

Effectively use autofill and flashfill so 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

Practical Learnty Methods to Object and Filter Your Data in Excel

Discover new features in PowerPoint 2019 including Icons and 3D Models

How Learning to Acts, Circuits and Pictures to Add "Some" to Your PowerPoint

Add charts, graphs and tables to your PowerPoint information presentation in a non-text format

Wow your audience by adding animations, audio and video to PowerPoint

Discovery 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, bordersers, and watermarks.

How to Create a Mail in Microsoft Word

How Learning to Print Envelopes and Licks in Word

Learn to protect your Word document from change

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 import data from Excel in Access

Learn Queries, use valid, how to create and print in reports

How to Compact, Repair and Backup Your Access Base

How to Create a Link 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 Mine Your Mail Inclus in Corning, Flagging and Condualalting

Creating and managing

How to Usement Systems and Action Functions

Adding, managing and searching contacts in the address book

Working with the Outlook Calendar, including meetings and schedules

How to Create Notes and Link Outlook to OneNote

Requirements

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

Description

**This course practice is drawing and exercises LIMITEIME access**

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

The Microsoft Office Mee is used by millions worldwide. Unlocking its full potential can see youly improve your productivity.

But you know all that you're on this page.

Instead, you’re the future wondering.

Simon Sez IT was i'd been in the money department for over 13 years, and we'vet got 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 9 of our best-selling titles intact one huge value offer.

You don't just get get return to enter toner courses. You get advanced training in Microsoft Excell and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Microsoft, 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 work 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/Cancer in Excel 2019

Advanced charting and graphing in Excel

How to Use Detailment Supply Tools

Lookup and Advanced Lookup Functions

Financial functions including calculating interest and depreciation

Statistical functions

Connecting to other worksbooks and datasets outside of Excel e.g. MS Access and the web.

How to Create Special 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 Outside PowerPoint

Presentation dos and don'ts

Text and Pay Route Edition Options

How to Use, Images, Objects, and Clothing

Using SmartArt

Working with Charts and Graphs

How to Master Slides and how only much time this can save you

How to add audio and video to a presentation

All about transitions between slides

Animation, the animation, 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 work with payrs and numbering in Microsoft Word

All about formatting paragraphs and lists

Working with Tables in Word Inclusive, Converting Data and Formulas

Page life including page-breaks, watermarks, and styles

All about Sectioning a document

Inserting graphics, pictures, ctance, icons, and 3d models (new for 2019)

How to Work with Envelopes and Licks

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 pattern

How to Moment Access to Your Needs

All about importing data and the datasheet view

How tables work in Access and how to create relationships within them

Creating forms and sub-forms that feed in your tables

How to run queries in Access

Setting up appeases 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 Documents

All about using ODBC and SQL Server

How to Spindent an Access Data In Front and Back-end

All about Macros in Access Inclus Inclus

How to do basic VBA in Access Inc Inclus and Discharge

More Advanced Scrutiny About Created 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 Inclus in Corning, Flaging, and Condualally

How to Make a Connection with Junk Mail

Attaching files, photos, and graphics in Outlook

About recalling a message

How to Usement Systems and Action Functions

How to Best Use, Added to, and Mud Relationships

Working with the Outlook Calendar, including meetings and schedules

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 Cause in Outlook

Microsoft Teams

How to Access, Download and Set Up Teams

How to Create Your First Team and Widesters and Files

All about posting and receiving public and private communications

How to do user announcements, tags, and message extensions

How to schedule an audio or video call

How to Use the Audio and Video Options Including Call Descriptions

How to Use the Meeting Room Function

How to Create a Wiki

All about using apps, bots, and connectors

How to Adinding Admin and User Indications

How to Use Teams on Your Mobile Device

Microsoft OneNote

How to Start 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 to tabs in OneNote and search for content

How to Link Note 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 Use the 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 Compilation

NINE-long Microsoft courses

These courses were all recorded in the 2019 versions of MS Office but still being still if you're working with Office 2013, 2016, or Office 365. Microsoft Teams and Microsoft OneNote Werphere Using Office 365

Here's what our students are saying...

"I'm very know this method helpful and the is very attorney easy to understand. I am learning more than I did with another course I try to take and lost interest. This course really kept my interest."
- Dianne Munizza

"Loving the Train. Easy to understand and can replay the lesson if I did not catch the first time.
- Monica Yvette Disbrow

"It's still early on the course, but I love it. He's very clear with any blue thing he's your teaching. He is well liked about 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. I's first registered for this course, I ' thought, 'oh my goodness, what' I have done, when you look at the 'your progress' dropdown at the top right corner of your dashboard and see that you're on #21 of 518(!), it is a meslaving intimidating. But, no, I think with this particular's gift of friendly, teaching we'll all do constructively well!"
- Celine Barton