About this course

Course type Essentials
Course code QAOFF13EX
Duration 1 Day

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

Prerequisites

  • 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.

Delegates will learn how to

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

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

Compatibility

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

Formatting

  • 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

Essentials

1 Day

Duration
Microsoft Office
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.