OfficeTrainingHub

Getting Ready for Virtual Training

Register for the Virtual Sessions

How to use our Virtual Training Platform on GoToTraining

How to use this Platform

Course Manual

Your Expectations

What is Office 365?

Sign in to Office

Working from anywhere with Office.com

Update your Profile on Office 365

How to change your Office 365 Password

Getting Office 365 on your Android Phone

Getting Office 365 on your iPhones & iPads

Office 365 on Windows phones

How to Setup One Drive for Business

How to Setup a SharePoint Site

Overview of Office 365

Create, Save & Open Files

Create a File from a Template

Renaming your Files

Switch between Online and Desktop

Zoom in or out

View files in Split and multiple windows

Preview and Print Files

The Microsoft Word Interface

What is Word

Create a Document

Add and Edit Text

Add and Format Text

Create and Format a document

Creating bulleted and numbered lists in Word

Research, edit, and design in Word

Changing Line Spacing in Word

How to Apply Styles to your Document

How to Apply Themes to your Document

Inserting Headers and Footers in your Document

Inserting and Modifying Page Numbers in your Document

Working with Page Breaks

Word 2016 for Windows keyboard shortcuts

Chapter Quiz

Lab 01 - How Excel Works

What is Excel

Managing Dates, Validations & Format Styles

Excel Formatting Syntax

Reporting Framework & the 7 Golden Rules of Data

The role of the Control & Report Sheets

Using the VLOOKUP Function

Chapter Quiz

What is PowerPoint

Create and Format a Presentation in PowerPoint

Design in PowerPoint

Working with the Slide Master

Align Objects in PowerPoint

Stacking Shapes, Pictures and Objects

Add, rearrange, duplicate and delete slides

Apply a Slide Layout

Using Themes in PowerPoint

Inserting Pictures in PowerPoint

Adding a Background Picture to your slide

Add or record Audio in your slides

Chapter Quiz

Welcome to Microsoft Teams

What is Microsoft Teams?

Get your team up and running

Go-to guide for team owners

Organize your teams list

Overview of teams and channels

Work in channels

Work on a file together

Create a plan with Planner

Upload and share files

Find and filter files

Send email to a channel

Manage meetings

Create instant meetings with Meet now

Microsoft Teams Adoption Guide

What is Outlook

Setting up Outlook

Overview of your inbox

Working with Outlook

Create and send email

Create your Email Signature

Attaching documents and pictures

Get Organised with Categories, Flags, Reminders or Colours

Adding Contacts

How to create tasks and a to-do list

Intro to Calendar

Create Appointments and Meetings

Schedule an Online Meeting

Share a Calendar

Import Calendars

How to Search for Calendar Items

Get organised with Colour Categories and reminders

Introduction to Microsoft Visio

Using Visio shapes

Change the drawing scale

Choose the right view for the task

Change grid spacing size

Microsoft Power BI

Working with AI in Power BI

Creating Reports

Data Protection in Power BI

Monitor your organisation's BI

Microsoft Power Apps

AI Builder in Power Apps

Extend Power Platform with APIs

Microsoft Stream

Introduction to Yammer

Introduction to Sharepoint

Microsoft Planner

Microsoft To-Do

Microsoft Kaizala

OneDrive for Business

Microsoft Forms

Microsoft Project

What is Sway?

Microsoft Power Virtual Agent

Microsoft Power Automate

Microsoft Delve

O365: Find Out What is New in Office 365

O365: Co-author Office files

O365: Collaborate with Comments

0365: Using Icons in your documents

Excel: Live Workbook Collaboration with others

Excel: Protect an Excel File

Excel: Analyse your Data Instantly

Excel: Use Sparklines to show Data Trends

Word: Find and Replace Text in Word

Word: Improve your Grammar

Word: Automating Table of Contents

Word: Tips for working with Text and Pictures in Word

Outlook: Trick to Setup your Gmail account in Outlook

Outlook: Recall or Replace a sent email

Outlook: Quickly Cleanup your Inbox

Outlook: Get Organised with Rules and Folders

Outlook: Import Contacts from Excel

PowerPoint: Harnessing Artificial Intelligence with Design Ideas

PowerPoint: Organise slides into sections

PowerPoint: Inserting a Linked Excel Chart

PowerPoint: Using Morph Transition for special effects

Best practices for collaborating with Office 365

Work remotely with Microsoft 365

A new way to work together

Excel: Quick Start Guide

Excel: 50 Excel for Windows Shortcut Keys

Excel: All Keyboard Shortcuts

Outlook: Cheat Sheet Outlook Mobile Android

Outlook: Cheat Sheet Outlook Mobile iOS

Word: All Keyboard shortcuts

PowerPoint: All Keyboard Shortcuts

Requirements for Virtual Sessions

Download Exercise Files - Productivity Essentials with office 365

Exercise Files & Assignments

Exercise Files & Assignments

Exercise Files & Assignments

Exercise Files & Assignments

Instructions

More resources for you

Evaluate & get your Certificate

How to Attach your Certificates to your LinkedIn Profile