OFFICE 365
Training Centre

Access to scenario-based training, tutorials and training for Office 365 apps,
including Outlook, OneNote, Word, Excel, Powerpoint and Skype for Business.

Office 365 Training Centre

What's New with Office Training

Word Training

Find out the latest offerings in Word. Format text, create mailing lists, and track changes.

Learn how to be more productive

Improve the way you work–from editing with others at the same time, to sharing on the go.

Getting started with Office 365

Get started with training on Word, OneDrive, Skype for Business and more.

Training for all Applications

Get started with training on Word, OneDrive, Skype for Business and more.

What is Office?
Learn to use Office 365 on your PC, Mac, and mobile devices.

Sign in to Office 365
Here’s where and how to sign in to Office 365.

Get help and support
Need support for Office 365? We’re here to help. Choose the option that works best for you.

Get the most out of Office 365 on Android phones and tablets
With Office 365 on your Android phone and tablet, you can take your files on the go and be productive at work, on the road, or at home.

Get the most out of Office 365 on iPhones and iPads
With Office 365 on your iPhone and iPad, you can take your files on the go and be productive at work, on the road, or at home.

Get the most out of Office 365 on Windows 10 phones
With Office 365 on your Windows 10 phone, you can take your files on the go and be productive at work, on the road, or at home.

Find out what Excel is, how to create a workbook, add, delete, or rename sheets.

What is Excel?
Learn to use Excel on your PC, Mac, and mobile devices.

Create a Workbook
A workbook is a file that contains one or more worksheets. Create a workbook to organise all kinds of information.

Add, delete, or rename sheets
By default, Excel gives you one worksheet in a workbook, but you can add more worksheets, rename them, or delete them, as needed.

Learn to hide or unhide columns, Freeze top and left panes, Move or Copy worksheets and apply themes.

Hide or unhide columns
Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.

Freeze top and left panes
Freeze rows and columns to keep specific areas visible when you scroll in a worksheet.

Move or copy worksheets
You can move or copy a worksheet in the same workbook, or copy a worksheet to another workbook.

Apply themes to change the look of Excel
Use or customize a theme in your Excel workbook to make your data stand out.

Explore all the Excel basics including editing gata, resizing images, formatting cells, and more.

Add and edit data
Explore the basics of adding and editing data in Excel.

Resize and merge cells and align data
Excel offers a variety of number formats to display numbers as percentages, dates, currency, and more.

Format numbers in cells
Use or customize a theme in your Excel workbook to make your data stand out.

Change the look of cells
Format cells to make them stand out using fonts, font size, color, and borders.

Copy cell formatting
Copy cell formatting using the copy and paste options, Format painter, and dragging techniques.

Select cell contents
In Excel you can select your data in a number of ways on a worksheet that will help you carry out your work efficiently.

Get started on how to create formulas, name cells, ranges, locate functions, and more.

Create Formulas
Get started on how to create formulas and use built-in functions to perform calculations and solve problems.

Name cells and ranges
In Excel, you can name cells and cell ranges, and use those names in formulas. This is a useful feature that makes the formulas easier to understand and maintain.

Use Trace to fix formula errors
Checking formulas for accuracy and finding the source of an error is hard when the formula uses precedent or dependent cells.

Locate functions
Excel groups functions into many categories and you can use help to understand what each function does.

Calculations using functions
Excel provides a vast number of built-in functions to perform simple or complex calculations.

Learn the basic steps to using OneNote 2016
Get Started with Outlook, learn how to add email accounts and import accounts.

What is Outlook?
Learn to use Outlook on your PC, Mac, and mobile devices.

Add email accounts
Add email accounts when you first start Outlook.

Import Gmail into Outlook
Add a Gmail account and manage it in Outlook to have all your current and previous email messages in one place.

Everything you need to know about sending and receiving emails.

View Email
Read and organize email messages in Outlook.

Create and send email
Create and send a new email message, reply to an email message, forward an email message, and finish a draft message.

Send file attachments with email
Send a file with your email message by adding an attachment.

Reply to or forward email
Reply to or forward an email message in Outlook.

Delete and recover emails
Delete email you no longer want or need from your Inbox or mail folders, or recover those that you still wish to keep.

Open, preview, or save attachments
In Outlook, you can preview, open, and save attachments.

Send automatic reply email
Set an automatic out-of-office reply to let people know that you cannot respond to email messages right away. When you’re ready, you can turn off the automatic replies.

Retract or replace a sent email
If you and your recipients are all on Microsoft Exchange and in the same organization, you can recall or replace an email message that you sent.

Everything you need to know about formatting and editing emails.

Add signatures to emails
Create, edit, and attach a signature to email messages you send, reply to, and forward.

Add attachments and hyperlinks to emails
Add or remove an attachment or hyperlink from an email message.

Design personal stationary
Create and use personal stationery in an email message.

Save and reuse email content
You can create a Quick Part to save and reuse a block of text that you frequently send instead of retyping it each time. You can also edit and delete Quick Parts.

Learn how to keep your inbox organised.

Clean up your Inbox
Use the Clean Up tool to remove redundant email messages from your email folders.

Block unwanted mail
Use the Block Sender filter to block unwanted email messages in Outlook.

Set an email flag, reminder, or colour
Adding a flag to an email message works as a visual reminder for handling the email message later. Learn how to add a flag, set a reminder for a flagged email message, and assign a color category to an email message

Organise email by using folders
Create folders to organize emails, move messages, and add folders to your Favorites folder for easy access.

Search and filter email
Search is a powerful tool to help find email messages anywhere in Outlook.

Organise your Inbox with rules
Create rules based on senders or recipients of messages, use rule templates, and delete a rule to help organize your email.

Get started with everything you need to know about PowerPoint.

What is PowerPoint
Learn to use PowerPoint on your PC, Mac, and mobile devices.

Change Views
Although the Normal view is probably the most common one used, there are other views that come in handy for different tasks and preferences.

Learn how to create presentations

Build presentations from templates
Get off to a fast start by using PowerPoint themes, that provide ready-made designs with built-in graphics, borders, fonts, and content placeholders.

Create presentations from scratch
You can always do it your way when it comes to creating a presentation.

Add and delete styles
Here are the common ways to add, rearrange, and delete slides in your presentation.

Select and apply slide layouts
Arrange slide content with different slide layouts to suit your taste and preference, or to improve the clarity and readability of the content.

Everything you need to know about adding and formatting text

Add text to slides
In PowerPoint, you can add text to your PowerPoint slides with text boxes and shapes.

Format text on slides
Change the size, font, and text style in your PowerPoint presentation to add emphasis and to highlight content.

Format lists on slides
Bulleted lists focus your message to your audience, and help them follow along with your key talking points.

Check spelling in your presentation
As you work on a presentation, PowerPoint automatically checks spelling and basic grammar and you can check the spelling of an entire presentation with ease.

Add math to slides
If you’ve already jotted down an outline of your presentation in Word and now need a quick way to add it to your slides, you can import a Word outline into PowerPoint.

Import a Word outline into PowerPoint
Add or remove an attachment or hyperlink from an email message.

Add hyperlinks to slides
Add links to your presentation to show related information on the web, quickly get to a different slide, or start an email message.

Add SmartArt to a slide
Add SmartArt to your PowerPoint slides to create visual impact to your text and bullets.

Add WordArt to a slide
Insert WordArt to visually transform your text and slides.

Add and format images

Add images to slides
In PowerPoint, add pictures to your presentations to complement and bring your text to life.

Add screenshots to slides
With a screenshot in your PowerPoint presentation, you can create powerful visuals for your slides.

Format images on slides
Once you add a photo, graphic, or picture, you have many ways to enhance the picture, such as backgrounds, shadows, and effects, to get your message across even better.

Learn everything there is to know about designing your presentations

Apply themes to presentations
A fast way to give your slides an attractive, professional look is to apply a theme. You can apply a theme to all slides, or specific slides, for a unique impact.

Create, merge, and group objects on a slide
PowerPoint has many standard shapes to add to your presentation. Or you can merge and group objects to make your own.

Align and arrange objects on slides
If you have several objects on a PowerPoint slide, you can align and arrange your elements using guides to give your presentation a neat and polished look.

Layer objects on slides
When you add pictures, shapes, or other objects, they can overlap. But you can change the stacking order.

Change slide masters
Use a slide master to add consistency to your colors, fonts, headings, logos, and other styles, and to help unify the form of your presentation.

Organise slides into sections
Use sections to organize your slides into meaningful groups, much like you use folders to organize files.

Add footers to slides
Add the date and time, slide number, and other information to the bottom of your slides by adding a footer.

Add transitions between slides
Slide transitions are the animation-like effects that happen when you move from one slide to the next during a presentation. Add slide transitions to bring your presentation to life.

Get design ideas for slides
With Power Designer, just insert a picture and then select the design you want. PowerPoint automatically generates great-looking design ideas, to help you create professional-looking slides.

Learn how to create presentations

Use Slide Show and Presenter View
With Presenter View, you can see your speaker notes and the next slide in your presentation on your computer, so you can focus on what you want to say, and connect with your audience.

Add speaker notes
Add speaker notes to help you remember what to say when you present. You can see your notes on your computer, but your audience only sees your slides.

Practise and time your presentation
PowerPoint has tools to record and time your presentation, so you can practice your timing before you’re actually in front of an audience.

Print Presentations
In PowerPoint, you can print your slides, your speaker notes, and create handouts for your audience.

Record Presentations
You can record your presentation, slide and animation timings, and more. Here’s how to record, play, and clear recordings.

Everything you need to know about adding and formatting text

Add and record audio
Add or record audio, such as music, narration, or sound bites, to your PowerPoint presentation.

Add and format video
With PowerPoint, you can embed an online video or a video from your PC into your presentation slides, and then format the video to your liking.

Documents and text

Get started with everything you need to know about Word.

What is Word
Learn to use Word on your PC, Mac, and mobile devices.

Use word on a mobile device
Edit or create documents from just about anywhere using the Word mobile app on your mobile device.

Learn how to create documents

Create a document, use templates and save
Word includes many professional-looking templates for you to choose from. To get started, select one and save it as a document.

Open, view, and close documents
Sometimes you only need to open and read a document. Word makes it distraction-free when you use Read Mode.

Convert a PDF to word document
When you need to revise a PDF file, there’s no need to recreate it from scratch. Instead, open the PDF in Word and edit it like you would any other document.

Everything you need to know about editing text

Add and edit text
Most of your time in Word is spent adding words, sentences, and paragraphs to your document and editing them. Use these text-editing tips to help you get it done faster.

Format text with styles

Apply Quick Styles and Themes
You can apply Quick Styles and themes to give your document a consistent, professional look. Word offers many styles and themes to choose from.

Create and change styles
Word offers a variety of styles that you can use to create a consistent look throughout your document. You can also create a new style, or modify an existing one.

OneDrive (home)

OneDrive
With OneDrive, you can store your photos, files, and folders in one place, share them with others, and get to them from anywhere.

 

 

OneDrive for Business Training

What is OneDrive for Business?
OneDrive for Business gives you one place to store, share, and sync your work or school files.

Set up your phone or tablet
With OneDrive for Business on your phone or tablet, take your files with you and work where you want, on all your devices.

OneDrive for Business basics
Use the OneDrive for Business navigation pane, file list, and toolbar to view and work with your files.

Upload files and folders
Upload files to OneDrive for Business so you can get to them from anywhere, on almost any device.

Create files and folders
With your files saved to OneDrive for Business, you can create files and folders to manage your work.

Share files and folders
With your documents in OneDrive for Business, you can share them with others, control who can view or edit them, and work together at the same time.

Me and my docs
With Office 365, you can save your file to the cloud, access it using different devices, and even share it with your team so you can all work on it together. Watch the video to see how it works, and then proceed to the first module to get started.

Save a workbook to OneDrive
When you have a file, such as a spreadsheet, that you want to access from different devices, begin by saving it to a cloud location, such as OneDrive for Business.

Open an Excel Spreadsheet
Suppose that you’ve saved a spreadsheet to OneDrive for Business and now you want to find it on your tablet.

Edit an Excel Spreadsheet on an iOS device
With Office 365 and Excel on your tablet, you can edit a spreadsheet from wherever you are. Watch the video to see how this works using Excel for iPad, and scroll down to see how to perform this task across a variety of devices.

Edit a spreadsheet using Android Devices
Suppose that you’re on the go, and you want to get some work done on an important spreadsheet. With Office 365, you’re all set to work on your file from wherever you are, using your smartphone.

Share a spreadsheet
Suppose that you want to share a spreadsheet with your teammates so you can all work on it together.

Co-edit a spreadsheet
With Excel Online, you can edit an Excel spreadsheet alongside your teammates. Watch the video to see how this works in the browser on a computer, and scroll down to see how to perform this task across a variety of devices.

Work together seamlessly
With Office 365, you can collaborate on Office documents, such as PowerPoint presentations and Word documents, from where they’re saved to the cloud. And, you and your teammates can work on your documents across multiple devices, including Android phones and tablets and iOS devices.

Save a presentation to OneDrive for Business using your tablet
Suppose someone sent you a PowerPoint presentation that you’ll be working on with your teammates. You can save it to a cloud location, such as OneDrive for Business, and then access it later using a variety of devices.

Edit a presentation on a tablet
Suppose that you’re on the road, and you need to edit a PowerPoint presentation. You don’t have your computer with you, but you do have your iPad

Share a presentation
Suppose that you have a PowerPoint presentation that you want to share with others. You want to give some people editing permissions, and read-only permissions to others. With PowerPoint 2016, you can do this using the Share menu.

Collaborate on a presentation
Suppose that you’re working on a presentation that you’ve shared with your team, and you have a quick question for one of your teammates. With Office 365, you can co-edit your presentation in PowerPoint and simultaneously chat with teammates online using Skype for Business.

Find and open a Word document
Suppose that you were working on a Word document on your computer, and now you want to find that file using your tablet. With Office 365, you can find your files across all your devices

Copy a chart from Excel into Word on an Android Tablet
When you’re on the go, and you have a lot of work to get done, having Office on your mobile devices can be handy.

Share a folder in OneDrive
You can share a folder in OneDrive for Business so that your teammates can view and edit all the files in that folder.

Co-edit a Word document
When you have a document that you’re working on with your teammates, co-editing in Word Online comes in handy.

Get started with everything you need to know about Access

What is Access
Do you have an idea for a database or web app to help your team work more efficiently? With Access, you don’t have to be a developer to implement it.

Get started with databases
Databases and web apps can yield big business advantages. Database design is critical to achieving your goals, whether you want to manage employee information, provide weekly reports against data, or track customer orders. Investing the time to understand database design will help you build databases that work right the first time and that accommodate changing needs.

Get to know database objects
Access provides six database objects that, when combined, help you take full advantage of your data. Learn the role that each object plays.

Learn how to create an Access Database

Desktop database or web app?
When you open Access 2016, you see a gallery of templates. Your first step in building a database is to decide whether to create an Access web app or an Access desktop database.

Create an Access desktop database
To create a desktop database quickly, use one of the many templates provided with Access. Or, if you don’t find a template that meets your needs, create a database from scratch.

Create an Access web app
View and sort data online, using any device, in an Access web app—even if you don’t have Access. The fastest way to get started is to use a template.

Everything you need to know about adding tables

Build tables and set data types
Because they store your data, tables are the backbone of your database. Each table contains information about a specific subject. For example, a supplier table might store supplier names, e-mail addresses, and telephone numbers.

Build tables with Table Designer
When you create a table with Table Design, you can be more deliberate about designing your database, set field types, create a lookup list, and create a foreign key to pair with your primary key.

Combine fields using the calculated data type
Use calculated fields to concatenate data from separate fields, like first and last name; or to calculate dates, like order date plus five days.

How to use Relationships in Access

Get started with table relationships
The power of a relational database lies in combining data across tables. To do that, you first need to establish relationships between your tables. Then, put Access to work to combine data in queries, forms, and reports.

Create relationships with the Lookup Wizard
The Lookup Wizard establishes a relationship between tables. It creates a foreign key that refers back to the primary key of another.

Create relationships with the Relationships Pane
The Relationships pane creates relationships between tables, but requires a compatible data type between the parent/child columns and doesn’t create a lookup list.

Create many-to-many relationships
Many-to-many relationships are the most commonly used table relationships. They provide crucial information, such as which customers your salespeople have contacted and which products are in customer orders.

Create one-to-one relationships
One-to-one relationships are frequently used to indicate critical relationships so you can get the data you need to run your business.