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