About this course

Course type Essentials
Course code QAW8OFF13
Duration 1 Day

Welcome to Windows 8 and the Microsoft Office 2013 suite of information productivity applications. Since you use Office in your job, you'll want to learn the new features of Windows 8 and 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.

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:

A relatively experienced end user who has used Office 2000, XP or 2003 with basic knowledge of the core applications, and needs to know the key new features of Office 2013.

Please Note: This course is not suitable for those users upgrading from Office 2007 or Office 2010, see 'Office 2013: New Features from Office 2007' 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:

  • Log on to and navigate the Windows 8 environment
  • Work with applications, files and folders
  • 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

Module 1: Introducing Microsoft Windows 8

Overview of Windows 8

  • Log On and Ease of Access Options
  • Explore the Start Screen

Working with Apps, Files and Folders

  • The Desktop as an App
  • Working with Windows and the Taskbar
  • Windows Explorer and the Contextual Ribbon

Module 2: 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

Module 3: 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

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

Module 4: 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
  • Slicers and Timelines
  • Recommended Charts and Pivot Tables
  • Quick Data Analysis

New Proofing Features

  • Flash Fill Data
  • Page Layout View

Module 5: Using the New Features of PowerPoint 2013

New General Features

  • Viewing Presentations
  • Contextual Tabs
  • Presenter View
  • Reading View

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

Module 6: 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 Desktop Operating Systems
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.