<< Back to Courses

MS Upgrade to 2013 (onsite only)


Cost: Contact us for quote.   Duration: 1 day


Contact Us to book.

Overview

Microsoft Office 2013 - Upgrading provides skills and knowledge in a wide range of new features, enhancements and changes found in Microsoft Office 2013.

Learning Outcomes

At the completion of this course you should be able to:

·         understand the Office 2013 interface

·         personalise and make changes to the ribbon

·         use the help system tools available to you in Office 2013

·         work with the file formats found in Office 2013

·         use the printing settings in Office 2013

·         share your work with others using Office 2013

·         use the new features available for formatting graphics

·         insert and edit pictures

·         use the new drawing and illustrating tools in Office 2013

·         understand what has changed in Word 2013

·          understand and work with a number of the new and improved features of Excel 2013

·         understand and work with the Power View and PowerPivot tools in Excel 2013

·         use the new and enhanced features of PowerPoint 2013

·          work with many of the new features of Outlook 2013

·         work with email messages in Outlook 2013

·         work with the new People and Calendar features in Outlook 2013

 

Prerequisites

Experience and knowledge of a version of Microsoft Office prior to Office 2010 is essential for this course, Microsoft Office 2013 - Upgrading, including experience in manipulating Office files, and creating documents, workbooks, presentations and emails.

 

Duration

Scheduled classroom training (1 Day)

 

Contents

The Office 2013 Interface

  • 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

Personalising The Ribbon

  • 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

The Office 2013 Help System

  • 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

The Office 2013 File System

  • 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

Printing From Office 2013

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

Sharing From Office 2013

  • 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

Formatting Graphics In Office

  • Understanding Graphics Formatting
  • Understanding Format Panes
  • Working With The Format Pane
  • Moving The Format Pane
  • Formatting With The Layout Options Button
  • Quickly Formatting Charts

Pictures

  • 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

Drawing And Illustrating

  • 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

Microsoft Word 2013

  • 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

Microsoft Excel 2013

  • 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

Concluding Remarks


 



Zip File
Download Exercise Files