You Will Learn
.Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access
.Learn practical methods to backup and recover your Excel spreadsheets and never lose data
.Discover the essentials of using formulas and functions in Excel
.Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
.Learn practical methods to sort and filter your data in Excel
.Discover how to create stunning charts and graphs in Excel
.Discover new features in PowerPoint 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 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