Course Description
This Microsoft Office 2013: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know to the latest release of Microsoft’s productivity suite.
Target Student:
This course builds upon the foundational Microsoft Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.
You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.
Prerequisites:
· Delegates should have experience of the Windows environment.
Performance-Based Objectives:
· - Explore the Software environment of Excel, Word, Access, PowerPoint and Outlook.
· - Look at the new features inherent to Microsoft Office 2013
Course Content
Word 2013 – What’s new
· New and Improved Backstage view
· Tabs now in CAPITAL LETTERS
· Using the New Read Mode for a cleaner reading view
· Object Zoom
· Resume Reading
· Insert Online videos and pictures
· Easier manipulation of wrapping text around pictures
· Double click or double tap to
· Use the new Alignment Guides to align pictures and images
· Expand or collapse parts of a document with just a tap or click
· Save and share files in the Cloud
· Use Simple markup
· Reply to comments and mark then as done
· Open PDF’s as a fully editable Word 2013 document
· Use great new templates
· Live layout and alignment guides
Excel 2013 – What’s New
· Get Started – New and Improved Backstage view
· Tabs now in CAPITAL LETTERS
· Instant Data Analysis with Quick Analysis
· Fill out data with Flash Fill
· Create the right chart with Chart Recommendations
· Filter Table data using Slicers
· Show each Excel window in a window of its own
· New Excel functions math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories.
· Save and Share files online with SkyDrive
· Embed worksheet data in a Web Page
· Share an Excel Worksheet in an online meeting with Lync
· Save to a new file format Strict Open XML Spreadsheet (*.xlsx) file format which lets you read and write ISO8601 dates to resolve a leap year issue for the year 1900.
· New charting features with changes to the Ribbon for Charts
· Fine Tune Charts quickly
· Three new chart buttons let you quickly pick and preview changes to chart elements
· View animations in Charts
· More Powerful data analysis with PivotTables and PivotTable fields
· Use multiple tables in your data analysis with the new Excel Data Model
· Connect to new data sources to use multiple tables
· Create relationships between tables
· Use the timeline to show data for different time periods
· Use Drill Down, Drill Up, and Cross Drill to get to different levels of detail
· Create a standalone PivotChart
· Using Power View (Office Professional Plus)
· Power Pivot for Excel Add-in (Office Professional Plus)
Outlook 2013 – What’s New
· New, Cleaner look
· New Backstage View
· Tabs in Capitals
· Preview messages in the message list
· Respond faster with Inline Replies
· Use commands in the message lists for quick action
· Use the All and Unread buttons in the Inbox so you can focus on the messages you want
· View only unread messages
· Flag incoming messages for follow-up
· Delete a message quickly with the new delete icon
· Use Calendar Peek and the Task Peek on the on the Navigation bar
· Use the People Card to see all contact details in one place
· Quickly switch between the main Outlook elements
· Give everyone on your team access to a team folder, calendar, and task list to manage on the go, using the combined power of Outlook, Exchange, and SharePoint
· Add a City to the Calendar Weather Bar and see the weather forecast
PowerPoint 2013 – What’s New
· New, Cleaner look
· New Backstage View
· Tabs in Capitals
· More choices for getting started
· New, improved Presenter Tools
· Presenter view on one monitor
· Zoom in on a slide with the magnifying glass
· Jump to a slide with the Slide Navigator
· Automatic set up to sense your computer setup and choose the right monitor for Presenter View
· Now widescreen friendly
· Start an online meeting from PowerPoint using Office Presentation Service
· Better Design Tools and Theme variations
· Line up and space objects equally with Smart Guides
· Motion path improvements
· Merge common shapes
· Improved video and audio support with formats like .mp4, .mov, H.264 and Advanced Audio Coding audio.
· Use Play in Background feature to play music while people view your slide
· New eyedropper tool for colour matching
· Use PowerPoint on Touch devices
· Work together on the same presentation either with the desktop or online version of PowerPoint and see each other’s changes.
Access 2013 – What’ New
· New look and feel
· Tabs in Capitals
· Access Web Apps is a new type of database that you build in Access, then use and share with others as a SharePoint app in a web browser
· Table Templates
· Creating tables from external data
· Publish and Open Access App in a browser
· Built-in views each have an Action Bar with buttons for adding, editing, saving, and deleting items.
· Modifying the Action Bar
· Callouts for setting properties
· New controls for working with related data
· AutoComplete control
· Drill through links
