1300 888 724

8.30am to 5:30pm AEST (Mon-Fri)

Upgrading to Office 2013 Course

(4.89 out of 5) 7 Student Reviews

About the Course

During this 2 day course participants will learn the core changes in Microsoft Office 2013 and to help them when upgrading from a previous version of Office. This course focuses on core changes in Office 2013, as well as, new features and changes in Excel 2013, Word 2013, PowerPoint 2013 and Outlook 2013.

Who should do this course?

This course is aimed at existing users of Microsoft Office who have already upgraded, or are contemplating upgrading to Microsoft Office 2013.

Prerequisites

This course has been developed for existing users of Microsoft Office to become quickly acquainted with the new features and changes in Microsoft Office 2013. It assumes therefore that users are familiar with Microsoft Office applications and work with Excel, Word, PowerPoint and Outlook at an intermediate level. Some knowledge of working with files and folders in the Windows environment is also assumed.

Course Details

Course Dates

  • Sydney Class Dates

    Book Now

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    16 - 17 Nov 17 Thu - Fri
    11 - 12 Jan 18 Thu - Fri
    28 Feb - 01 Mar 18 Wed - Thu
    09 - 10 Apr 18 Mon - Tue
    24 - 25 May 18 Thu - Fri
  • Melbourne Class Dates

    Book Now

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    23 - 24 Nov 17 Thu - Fri
    11 - 12 Jan 18 Thu - Fri
    19 - 20 Feb 18 Mon - Tue
    05 - 06 Apr 18 Thu - Fri
    15 - 16 May 18 Tue - Wed
    28 - 29 Jun 18 Thu - Fri
  • Brisbane Class Dates

    Book Now

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    30 - 31 Oct 17 Mon - Tue
    13 - 14 Dec 17 Wed - Thu
    22 - 23 Jan 18 Mon - Tue
    08 - 09 Mar 18 Thu - Fri
    16 - 17 Apr 18 Mon - Tue
    31 May - 01 Jun 18 Thu - Fri
  • Canberra Class Dates

    Level 1, 33 Ainslie Place, Canberra , ACT 2601

    Classes scheduled on demand in Canberra

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Adelaide Class Dates

    19 Young Street, Adelaide , SA 5000

    Classes scheduled on demand in Adelaide

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Perth Class Dates

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    Classes scheduled on demand in Perth

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

Course Units

Expand full topic list

Unit 1: The Office 2013 Interface

See topics

  • Understanding the Office 2013 Interface
  • Starting an Office 2013 Application
  • Understanding the Start Screen
  • Customising the Ribbon with Display Options
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Integrating with the Cloud
  • Working with Touch Mode

Unit 2: Personalising the Ribbon

See topics

  • Understanding Personalising the Ribbon
  • Showing and Hiding Ribbon Tabs
  • Modifying Ribbon Tabs
  • Creating a New Ribbon Tab
  • Placing Commands on a Tab
  • Organising Commands in a Group
  • Creating More Groups
  • Exporting Your Personalisation Settings
  • Removing a Tab from the Ribbon
  • Importing Personalisations
  • Resetting the Ribbon

Unit 3: The Office 2013 Help System

See topics

  • Understanding How Help Works
  • Knowing Your Version and Build
  • Accessing the Help Window
  • Help Getting Started with Office 2013
  • Using Quick Start Guides
  • Googling Help
  • Accessing Images and Pictures
  • Accessing Online Templates

Unit 4: The Office 2013 File System

See topics

  • Understanding Office 2013 File Types
  • The Open Place
  • Opening Files in Office 2013
  • Closing Files in Office 2013
  • Opening Recent Files and Folders
  • Recent Files from the Start Screen
  • Understanding File Saving in Office 2013
  • Saving to SkyDrive
  • Saving to a Previous Version
  • Saving as Macro Enabled
  • Creating a PDF File
  • Creating New Files in Office 2013
  • Understanding Templates in Office 2013
  • Saving Custom Templates
  • Setting a Custom Templates Location
  • Understanding Draft Versions
  • Configuring AutoSave
  • Recovering an Unsaved File
  • Managing Versions
  • Accessing File Information

Unit 5: Printing from Office 2013

See topics

  • Print Previewing
  • Choosing a Printer
  • Specifying Print Settings
  • Specifying Page Layout Settings
  • Changing Printer Properties

Unit 6: Sharing from Office 2013

See topics

  • Understanding Sharing
  • Sharing a Document Using SkyDrive
  • Sending a File as an Email Attachment
  • Sending a File as a PDF Attachment
  • Protecting Your File before Sharing
  • Checking For Issues
  • Checking File Accessibility
  • Checking File Compatibility

Unit 7: Formatting Graphics in Office

See topics

  • Understanding Graphics Formatting
  • Understanding Format Panes
  • Working with the Format Pane
  • Moving the Format Pane
  • Formatting with the Layout Options Button
  • Quickly Formatting Charts

Unit 8: Pictures

See topics

  • Inserting a Picture
  • Inserting an Online Picture
  • Removing a Picture Background
  • Applying Picture Styles
  • Repositioning Pictures
  • Applying and Changing Effects
  • Correcting Pictures
  • Changing Picture Colouring
  • Cropping Pictures Accurately
  • Changing the Picture Layout

Unit 9: Drawing and Illustrating

See topics

  • Understanding Illustrations
  • Inserting Clip Art
  • Formatting Clip Art
  • Inserting Shapes
  • Modifying Shapes
  • Inserting Text into a Shape
  • Custom Text Wrapping
  • Finding and Selecting Shapes
  • Inserting a Screenshot
  • Inserting a Screen Clip

Unit 10: Microsoft Word 2013

See topics

  • What’s New in Word 2013
  • The Word 2013 Screen
  • Spell Checking in Word 2013
  • Working with the Navigation Pane
  • Locating Non Textual Items
  • Understanding the Design Tab
  • Applying a Style Set
  • Inserting Online Videos
  • Aligning Graphical Elements
  • Opening and Editing PDFs
  • Inserting Comments
  • Working with Comments
  • Understanding Read Mode
  • Viewing a Document in Read Mode
  • Using Resume Reading
  • Inserting Columns and Rows into a Table
  • Drawing Table Borders

Unit 11: Microsoft Excel 2013

See topics

  • What’s New in Excel 2013
  • New Worksheet Functions in Excel 2013
  • The ARABIC Function
  • The DAYS Function
  • The IFNA Function
  • Functions That Test Formulas
  • The RRI Function
  • The Worksheet Information Functions
  • New Charting Features
  • Using a Recommended Chart
  • Working with the New Chart Tools
  • Working with Chart Elements
  • Working with Chart Styles
  • Filtering the Chart
  • Working with Chart Data
  • Understanding Flash Fill
  • Extracting with Flash Fill
  • More Complex Flash Fill Extractions
  • Extracting Dates and Numbers
  • Understanding Sparklines
  • Creating Sparklines
  • Editing Sparklines
  • Understanding Quick Analysis
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
  • Recommended Pivot Tables
  • Understanding Slicers
  • Creating Slicers

Unit 12: Excel 2013 Power Tools

See topics

  • Understanding Power View
  • Enabling Power View
  • Creating a Power View Sheet
  • Working with a Power View Object
  • Working with Power View Fields
  • Rearranging and Sorting Fields
  • Working with Measure Fields
  • Formatting Power View Data
  • Tiling Data in Power View
  • Filtering in Power View
  • Switching Visualisations
  • Adding More Power Views
  • Adding Titles and Images
  • Updating a Power View Report
  • Understanding PowerPivot
  • Understanding Relational Data
  • Enabling PowerPivot
  • Connecting to a Data Source
  • Working with the Data Model
  • Working with Data Model Fields
  • Changing a PowerPivot View
  • Creating a Data Model PivotTable
  • Using Related PowerPivot Fields
  • Creating a Calculated Field
  • Creating a Concatenated Field
  • Formatting Data Model Fields
  • Using Calculated Fields
  • Creating a Timeline
  • Adding Slicers

Unit 13: Microsoft PowerPoint 2013

See topics

  • What’s New in PowerPoint 2013
  • The PowerPoint 2013 Screen
  • Creating a Presentation
  • Applying Theme Variants
  • Inserting an Online Video
  • Inserting an Online Audio File
  • Aligning Objects
  • Merging Shapes
  • Selecting Colours Using the Eyedropper
  • Copying Animations
  • Inserting Comments
  • Creating Sections
  • Building Equations
  • Using Reading View
  • Looking At Presenter View in Detail
  • Using Presenter View
  • Exporting a Presentation to Video
  • Presenting Online

Unit 14: Microsoft Outlook 2013

See topics

  • What’s New in Outlook 2013
  • Where Are They Now in Outlook 2013?
  • Common Outlook 2013 Screen Elements
  • Navigating to Outlook Features
  • Sneaking a Peek
  • The Folder Pane
  • The to-Do Bar
  • The Mail Screen
  • The Calendar Screen
  • The People Screen
  • The Tasks Screen
  • The Notes Screen
  • The Outlook Today Screen

Unit 15: Outlook 2013 Mail

See topics

  • Opening an Outlook Data File
  • Previewing Messages
  • Showing Unread or All Mail
  • Using Quick Action Commands
  • Responding to Messages Using Inline Replies
  • Sending an Email without an Attachment
  • Understanding Conversation View
  • Navigating Messages in a Conversation
  • Ignoring Conversations
  • Cleaning Up Conversations
  • Automating Common Tasks with Quick Steps
  • Customising a Default Quick Step
  • Creating a Quick Step
  • Using Quick Steps

Unit 16: Other Outlook 2013 Features

See topics

  • Understanding People View
  • Viewing Your Contacts
  • Creating a New Contact
  • Editing a Contact
  • Pinning a Contact to Your Favourites
  • Contacting a Contact from the People Card
  • Contacting a Contact from the People Peek
  • The Outlook Social Connector
  • Connecting Office to a Social Network
  • Viewing the Outlook Social Connector
  • Disconnecting Office from a Social Network
  • Understanding the Weather Bar

Related Course:

Course Reviews

(5.00 out of 5) Virginia C [ 11 July, 2017 ]
The instructor was really accurate and helpful. He answered all my questions and taught me really good features of each program. I would take another course with him and recommend him to others. I really enjoyed the course and I am planning on taking another one soon. Thank you.
(5.00 out of 5) Shanyn A [ 10 March, 2017 ]
I have learned heaps with this course and Andrew has been wonderful in training and updating me on the latest in Office. He knows everything about what I needed to know; and more! I highly recommend him for your future training. Kind regards, Shanyn.
(5.00 out of 5) Georgina W [ 04 April, 2016 ]
Peter really tailored this course to meet our needs and was very knowledgeable on all aspects of MS Office.
(5.00 out of 5) Helen F [ 17 December, 2014 ]
I appreciated coming along with personal experiences & questions and having them answered very well by Martin. He explains concisely and takes the opportunity to interact with participants.

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top