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