Welcome to Microsoft Office 2013, the newest suite of information productivity applications. Since you use Office in your job, you'll want to learn the new features of Office 2013 that will help you to streamline your work. In this course, you'll learn the key new features of Word, Excel, PowerPoint and Outlook. You'll also take a look at the general changes that are familiar to all of the core applications, such as the new look and feel of the interface and the new file formats.

Further detailed training is available at various levels on all Office 2013 applications, including: Access, InfoPath, Project, Publisher, SharePoint, SharePoint Designer and Visio.

Target Audience

Please Note: This course is not suitable for those users upgrading from Office 2007 or Office 2010. For Office 2007 users, see 'Office 2013: New Features from Office 2007' www.qa.com/QAOFF13NF for more details


  • Before attending this course, delegates should be existing Microsoft Office users who will be required to use Microsoft Office 2013. They should have basic knowledge of the core applications: Word, Excel, PowerPoint and Outlook. Delegates should be able to use a keyboard and mouse and be able to navigate the Windows operating system including using Windows Explorer.
  • It should be noted that little or no time can be allocated during the course to demonstrate or provide training on existing features of Office, that are not deemed to be improved or new features of the product. For example, time cannot be given to demonstrate creating formulas in Excel, merely showing any new or improved features that impact on formula creation.

Learning Outcomes

At the end of this course you will be able to:

  • Explore the general environment of Office 2013
  • Save files in a variety of formats to aid business continuity
  • Use the key new features of Word, Excel, PowerPoint and Outlook 2013

Course Outline

Lesson 1: Using the Office 2013 Environment

General Environment

  • The Ribbon
  • Tabs, Groups and Commands
  • Dialog Box Launchers
  • Quick Access Toolbar
  • Personalise the Ribbon
  • Office 2013 and 'The Cloud'
  • Live Previews
  • Apps for Office
  • Developer Tab
  • Office Backstage View


  • File Formats
  • Document Inspector
  • Integration
  • Views and Zooming
  • Keyboard Shortcuts


  • Mini Toolbar
  • Themes
  • Screenshot Tool
  • Screen Clipping Tool
  • SmartArt Graphics
  • Charting

Lesson 2: Using the New Features of Word 2013

New Formatting Features

  • Inline Text Effects
  • Paste Special
  • Quick Styles
  • Typography

New Content Features

  • Quick Parts and Building Blocks
  • Search and Navigation
  • New Easy Table Features
  • Inserting Content from the Web
  • Expand and Collapse Paragraphs
  • Equation Builder
  • Citations and References

New Proofing Features

  • PDF Reflow
  • Zooming
  • Reading Mode and Resume Reading
  • Live Layout
  • Improved Commenting and Track Changes
  • Word Count
  • Contextual Spell Checking
  • Word Definition Checker

Lesson 3: Using the New Features of Excel 2013

New General Features

  • Increased Capacity
  • File Types

New Formatting Features

  • Galleries
  • Conditional Formatting

New Formula Features

  • Resizable Formula Bar
  • Function AutoComplete
  • Name Manager

New Analysis Features

  • Excel Tables
  • Filtering and Sorting
  • Sparklines
  • PivotTable Enhancements
  • Slicers and Timelines
  • Recommended Charts and Pivot Tables
  • Quick Data Analysis

New Proofing Features

  • Flash Fill Data
  • Page Layout View

Lesson 4: Using the New Features of PowerPoint 2013

New General Features

  • Viewing Presentations
  • Wide Screen Support
  • Contextual Tabs
  • Presenter View
  • Reading View
  • Presentation Sharing

New Formatting Features

  • Eyedropper Tool
  • Merge Shapes
  • Custom Slide Layouts
  • Slide Sections
  • Graphics Effects
  • Themes and Variants
  • Smart Guides

New Content Features

  • Online Content
  • Convert Bullets to SmartArt Graphics
  • Embedding and Editing Video
  • Enhanced Animations and Transitions

Lesson 5: Using the New Features of Outlook 2013

New General Features

  • File Tab (Backstage View)
  • Navigation Bar
  • To-Do Bar
  • Color Categorize
  • Instant Search
  • Weather Bar

New Email Features

  • Mail Icons
  • Message Notification Window
  • Attachment Reminder
  • Instant Inbox Filters
  • Inline Reply
  • Calendar Snapshots
  • Out of Office
  • Quick Steps
  • Folder Tab and Pane
  • People Cards and Pane

New Calendar Features

  • Enhanced Views
  • Tasks Area
  • Overlay Calendars
  • Meeting Recommendations

New Task Features

  • Task Area

Sorry, we don't have any available dates! Please complete this form to be notified about new dates

Hide form
Please type in a preferred location or region...

Your course has been added to your basket

Proceed to checkout Continue shopping