Microsoft Office Course

WHY MICROSOFT OFFICE WITH ADVANCED EXCEL ?

Find out how to use the new natural language query feature in Excel, get writing and research assistance, get someone's attention in Outlook, create better lists in PowerPoint, and visualize math concepts using the math assistant in OneNote. Plus, learn about new apps in the Office 365 suite including To-Do and Forms.

KEY BENEFITS

• Using natural language queries in Excel.
• Getting writing assistance from Editor.
• Using the Resume Assistant in Word.
• Turning data into maps in Excel.
• Setting access to linked files right within Outlook.
• Creating better PowerPoint lists with Designer.
• Using the math assistant in OneNote.
• Working with Microsoft To-Do and Forms.

WHAT YOU LEARN?

• Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access.
• Discover the essentials of using formulas and functions in Excel.
• Discover how to create stunning charts and graphs in Excel.
• Learn practical methods to sort and filter your data in Excel.
• Discover new features in PowerPoint 2019 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.
• How to create a mail merge in Microsoft Word.
• Learn how to correctly Print envelopes and labels in Word.
• Sorting information and running queries in Access.
• Navigating the Access 2019 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.
• Working with the Outlook Calendar, including creating meetings and appointments.
• How to create Notes and link Outlook to OneNote.