Course duration: 1 Day
Cost: £195 + VAT
Overview
Office 2010 is a software suite containing MS Word, Excel, PowerPoint, and Outlook along with other familiar applications as well as some new ones. With this release, the common interfaces have radically changed, now organising commands around specific scenarios or objects. The course is intended to allow delegates to become familiar and comfortable with this new approach.
Who will the course benefit?
Current users of Office 2003, who are intending to upgrade to Office 2010. It is also intended for people who need to know what is new, or has changed and how to use the new version efficiently.
Course Objectives
The course covers the new interface and introduces the new context-based tools, new formats and ways of achieving integration between applications. This course will focus on Excel, Word, Outlook and PowerPoint. Starting with the new Interface, users will be shown how to find the buttons they are looking for easily and guided throughout the new menu locations.
Also included in the course are the two new toolbars; the Quick Access Toolbar and the Mini Toolbar. Formatting on the fly or Live Preview as it is also known is a completely new feature in this 2010 version of Microsoft Office Word and will be discussed throughout the course.
Skills Gained
Familiarity with the way the new interfaces work – updating knowledge from earlier menu-based procedures, and new features. Delegates will be able to work quicker and smarter in their daily routine after the course, and they will feel more comfortable working with this completely new Interface.
Pre-Requisites
Prior familiarity with an earlier version of MS Office is essential.
MICROSOFT OFFICE EXCEL 2010 – NEW USER INTERFACE
THE RIBBON
Hide or Redisplay the Ribbon
Show Screen Tips
THE FILE TAB
The File Tab (Backstage View)
Recent
Convert
New Option
Open
Save
Save As
Print
Save & Send
Info – Compatibility Mode
Info – Permissions
Info -Prepare for Sharing
Info- Versions
Help
Close
Exit
THE HOME TAB
Home – Clipboard Tools
Font Tools
Alignment Tools
Number Tools
Styles Tools
Cells Tools
Editing Tools
AutoSum
Fill
Clear
Sort & Filter
Find & Select
THE INSERT TAB
Tables
PivotTable
Illustrations
THE PAGE LAYOUT TAB
Page Setup Tools
Margins
Orientation
Size
Print Area
Page Breaks
Background
Print Titles
Scale to Fit Tools
Sheet Options
FORMULAS TAB
Function Wizard
Function Library Tools
AutoSum
Named Cells Tools
Auditing a Named Range
Formula Auditing
Calculation Tools
DATA TAB
Get External Data Tools
Manage Group
Sort and Filter Groups
Data Tools Group
Outline Tools
REVIEW TAB
Proofing Tools
Language
Comments Tools
Changes Tools
VIEW TAB
Zoom Tools
Windows Tools
OTHER USEFUL NEW FEATURES
Mini Toolbar
Quick Access Toolbar
Document Versioning
Adding Buttons and Tabs
Drag-and-drop navigation pane
Sparklines
Charts
MICROSOFT OFFICE WORD 2010 – NEW USER INTERFACE
THE RIBBON
Hide or Redisplay the Ribbon
Show Screen Tips
THE FILE TAB (Backstage View)
New Option
Open
Save
Save As
Print
Send & Save
Info – Compatibility Mode
Info – Permissions
Info -Prepare for Sharing
Info- Versions
Recent
Help
Close
Exit
THE HOME TAB
Home – Clipboard Tools
Font Tools
Paragraph Tools
Styles Tools
Editing Tools
Navigation Pane
THE INSERT TAB
Page Tools
Tables Tools
Table Style Options
Table Styles
Draw Table Borders
Layout Tab
Table Tools
Rows & Columns
Merge Tools
Cell Size
Alignment
Data Tools
Illustrations Tools
Links tools
Headers & Footers
Text Tools
THE PAGE LAYOUT TAB
Themes
Page Setup Tools
Page Background
Paragraph Tools
Arrange Tools
THE REFERENCES TAB
Table of Contents
Footnotes Tools
Citations and Bibliography
Captions Tools
Index Tools
Table of Authorities
THE MAILINGS TAB
Create
Start Mail Merge
Write & Insert Fields
Preview Results
Finish
THE REVIEW TAB
Proofing
Language
Comments
Tracking Tools
Changes Tools
Compare Tools
Protect Tools
THE VIEW TAB
Document View
Show/Hide
Zoom
Window Tools
Switch Windows
Macros
USEFUL NEW WORD FEATURES
Text Effects
Typing
Live Word Count
Improved SmartArt
Document Versioning
Navigation Bar
Co-Authoring
Adding Buttons and Tabs
MICROSOFT OFFICE OUTLOOK 2010 – NEW USER INTERFACE
The File Tab (Backstage View)
Info
Open
Print
Help
Options
New
Delete
Respond
Quick Steps
Move to:?
Team Email
Reply and Delete
Done
New Quick Step
Move
Tags
Find
Send & Receive
Download
Server
Dial Up Connection
New
Actions
Clean Up
Properties
Current View
Conversations
Arrangement
Layout
People Pane
Reminders
NEW EMAIL MESSAGE INTERFACE
MICROSOFT OUTLOOK FILE TAB – NEW MESSAGE
The File Tab (Backstage View)
New Mail Message
Send
Print
Close
THE RIBBON – NEW MESSAGE
Message
Clipboard
Basic Text
Names
Include
Tags
THE RIBBON – NEW MESSAGE – INSERT TAB
Include
Tables
Illustrations
Links
Text
Symbols
THE RIBBON – NEW MESSAGE – OPTIONS TAB
Themes
Show Fields
Tracking
More Options
THE RIBBON – NEW MESSAGE – FORMAT TEXT TAB
Clipboard
Format
Font
Paragraph
Styles
THE RIBBON – NEW MESSAGE – REVIEW TAB
Proofing
Language
CALENDARS
Folder Tab
Send a Calendar through Email
Viewing Next and Previous Appointments
Navigation Pane in Calendar View
CONTACTS
New Contacts Interface
Contact Tab
Show
Communicate
Options & Tags
TASKS AND THE TO DO LIST
Home Tab
View Tab
MICROSOFT OFFICE POWERPOINT 2010 – NEW USER INTERFACE
THE FILE TAB (Backstage View)
Recent
Convert
New Option
Save
Save As
Print
Save & Send
Info – Permissions
Info -Prepare for Sharing
Info- Versions
Help
Close
Exit
THE HOME TAB
Clipboard Tools
Slides Tools
Font Tools
Paragraph Tools
Transitions to This Slide
SLIDE SHOW TAB
Start Slide Show
Set Up Tools
Monitors
REVIEW TAB
Proofing
Comments
Compare
VIEW TAB
Presentation Views
Show
Zoom
Color/Grayscale
Window
OTHER USEFUL POWERPOINT FEATURES
Bottom of screen
Shortcuts
Mini Toolbar