For businesses upgrading to Office 2016.

Overview

This practical, hands-on course is designed for users who are upgrading to Microsoft Office 2016 applications and want to explore the new user interface (UI). New features will be examined using appropriate examples and practical tasks. Users will leave equipped with the skills required to use confidently the Office 2016 versions of Excel, PowerPoint, Word, and Outlook.

Although this course concentrates on Office 2016, we will look at important functionality and features of all post-2003 versions of Microsoft Office that may have been overlooked.

Duration

1 Day

Requirements

The course assumes that you are an experienced user of an earlier version of Office.

Objectives

• To navigate the new UI efficiently
• To locate common commands and identify new commands across the Office 2016 applications
• To identify new functionality and features in specific Office 2016 applications
• To create various documents in Excel, PowerPoint, Word, and Outlook in order to boost familiarity.

Content

Exploring the UI in detail:
Looking at the Excel, Word, PowerPoint and Outlook 2016 UI in detail; using Tell me… and the Share button in application-specific detail; using Smart Lookup to get access to relevant resources.

Excel 2016:
Using various new templates as a springboard to your models; using enhanced formula creation functionality; flash fill; improved conditional formatting; using new chart types for improved data visualisation; an introduction to BI (Business Intelligence) tools; the Backstage view, and customising the ribbon.

Word 2016:
Creating a document using new templates; using the Draw tab and ribbon for document markup; use enhanced proofing tools; moving quickly around your document using the Navigation pane; the Backstage view, and customising the ribbon.

PowerPoint 2016:
Creating a presentation using new templates; using the Design Ideas task pane as an aid to creating presentations; using the new Morph transition; using new chart types for improved data visualisation; using Zoom to create dynamic, non-linear presentations; visualising data with new chart types; new and improved slide layout tools; using the Draw tab and ribbon for document markup; the Backstage view, and customising the ribbon.

Outlook 2016:
Using enhanced file attachment functionality; using @mentions in the body of an email; using a more focused inbox; using the Search tab/ribbon to refine searching your mailbox; using Clutter to prioritise emails; using Groups to create and manage groups and to share files; using Quick Steps to help manage your mailbox.

For businesses upgrading to Office 2019 (one-time purchase) or Office 365 (subscription).

Overview

The new Office 2019 is a one-time purchase that receives quality and security patches but no new feature updates after the initial purchase.

Office 365 is a subscription-based service that is powered by the Microsoft Cloud. The service receives feature updates on a regular basis. With an Office 365 subscription, you can access your applications via your browser and you can install a full desktop version of Office 2019.

This workshop is designed for users who are changing from an earlier version of Microsoft Office to Office 2019 or have a new subscription to Office 365. Office 2019 is significantly different and, although intended to be intuitive, task-based, and fluent, the new interface might be daunting at first.

The first thing you will ask is “Where is …?” or “How do I…?” It is confusing for users who suddenly find that their favourite commands have changed or been moved. This workshop will help you to transfer your skills, make the most of the new interface, and be amazed by some of the new features.

Duration

1 Day

Requirements

The course assumes that you are an experienced user of an earlier version of Office.

Objectives

• To navigate and manage the new user interface
• To locate familiar commands and explore new ones
• To understand and confidently use the enhancements in Office 2019
• To work more effectively with Office 2019/365 applications, including Outlook 2019
• To share data with colleagues safely and effectively.

Content

Office 365:*
Using Office.com; sharing a file; co-authoring and collaborating in real time on spreadsheets, viewing collaborators’ comments; opening attachments using the File> Open>Shared with me function; turning on the Coming Soon feature to control changes and when they will take effect; reviewing new features before they arrive; using the new Office 365 search.

OneDrive:
Saving to OneDrive; accessing OneDrive from a mobile device; viewing and editing Word, Excel, and PowerPoint files from a mobile device.

Exploring the new user interface:
Understanding the Ribbons and using both Simplified and Classic view; locating familiar commands quickly; reviewing the accessibility improvements.

Excel 2019:
Creating new funnel charts and 2D maps; identifying new Excel functions and connectors; publishing Excel data to Power BI for enhanced visual effects; reviewing the PowerPivot and PowerQuery developments that support data analysis when using multiple data sources.

Word 2019/365:
Working with and understanding themes, using the new black theme; using Office sounds to provide helpful feedback; using learning tools captions and audio descriptions; working with new inking functionality such as the roaming pencil case, pressure sensitivity, and tilt effects; an overview of how to work with Quick Parts and the Building Block Organiser; setting default fonts and colours; using the new text to speech functionality.

PowerPoint 2019:
Using widescreen friendly themes and colour variations; exploring Slide Master and custom slide layouts; using live drawing guides to align and arrange objects; merging common shapes and working with the Eye Dropper colour tool; applying new motion paths and using new transition features; inserting 3D models and Scalable Vector Graphics (SVG) files with support for interactivity and animation; reviewing the new zoom features to help order slides.

Outlook 2019:
Using the Focused Inbox to identify important emails; using @mentions to get someone’s attention; using @mentions as search criteria; using the quick action tools in the message list and the quick preview; creating Quick Steps to help manage your mailbox; prioritising items with the To-Do Bar; using the Search tab; reviewing the updated contact cards; using travel and delivery summary cards.

*Only relevant to users who have purchased an Office 365 subscription. Content correct as of September 2018.