Microsoft Office Advantage

Office Advantage Subscription Overview

• Do you know all the ways Microsoft Office can make your life easier?
• Do you sometimes wonder how to do pivot charts in excel, add animation to a PowerPoint presentation, or do a mail merge in Word?
• Do you see other people’s documents and wonder how they managed to make it look the way it does?
• When Microsoft launches a new version of Office, do you continue to use it in the same way as the previous version?

Office Advantage is a series of one-hour live, virtual sessions providing overviews of key topics in Microsoft Office 2007and 2010, as well as explaining new productivity tools and features in new versions. Sessions will include demonstrations from our Microsoft Office experts, as well as hands-on activities for you to complete.
Your 12 months subscription will allow you to join four different sessions running every month.  Along with your booking confirmation, you will be provided with your full login details, which will allow you to access the virtual environment where you will be able to obtain information on the topics available and confirmed schedule timings.  
Sessions will generally run the third Wednesday of the month, at the following times:

• 09.30 – 10.30
• 11.30 – 12.30
• 13.30 – 14.30
• 15.30 – 16.30

Example sessions will include

Office 2010 – Hints and Tips

• The Office 2010 Interface, File Version Features, File Security Options, Enhanced Print Options, New Picture Tools, New Charting Tools, SmartArt Graphics, Office Themes

What’s new in Excel 2007

• New General Features, New Templates, File Types, New Formatting Features, New Formula Features, New Analysis Features, New Proofing Features

What’s new in PowerPoint 2007

• New General Features, New Formatting Features, New Content Features, New Conversion Features

What’s new in Word 2007

• New Formatting Features, New Content Features, New Proofing Features, New Conversion Features

Formula Fundamentals

• Overview of Formula Creation, Use Relative and Absolute Cell References in Calculations, Calculate with Basic Functions

Data Analysis using PivotTables and PivotChards in Excel 2007

• Build and Manipulate a PivotTable, Change the PivotTable View, Customise PivotTable Fields, Set PivotTable Options, Perform PivotTable Calculations, Create and Modify a PivotChart

Working with Data in Excel 2007

• Create and Modify Tables, Sort Data, Filter Data, Use Subtotals, Apply Table Summary Calculations

Styles and Themes in Word 2007

• Create Custom Themes, Create Custom Text Styles, Create Custom List Styles)

Track Changes in Word 2007

• Modify User Information, Modify Track Changes Options, Insert Comments, Compare and Merge Documents, Review Tracked Changes

Use Animation in PowerPoint 2007

• Add Multimedia Elements, Apply Slide Transitions, Apply Custom Animation

Working with Slide Shows in PowerPoint 2007

• Use Hyperlinks and Action Buttons, Create Custom Shows, Annotate a Presentation, Set A Slide Show to Run Automatically