The course introduces the delegate the new look of Office 2010. Menus have been replaced by a Ribbon, featuring tabs with icons, dedicated to the feature that is currently used.
The course shows the main differences in using Word, Excel, PowerPoint, Outlook and Access in the new version of
Office 2010.
Duration: 7 hours
Target Group: This course is intended for delegates who have a good basic to intermediate knowledge of Word, Excel, PowerPoint and Outlook.
Prerequisites: The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills.
Method of training: Instructor led, hands-on exercises using a computer. Groups preferably not more than 12 delegates.
TOPIC 1 – NEW LOOK MENUS
Using the new Backstage View and the Menus in Office 2010
Quick Access Toolbar
TOPIC 2 - OUTLOOK
Finding Information
Instant search
Attachment Previewing
Week view changed
Default Month view
Flagging mail for follow-up
Task integration on Calendar
Improved scheduling capabilities
Account Setup
Calendar Snapshots
Calendar overlays
Electronic Business Cards
Save as PDF or XPS
Unified messaging
Remain safer and in control
Outlook E-mail Postmark
Junk e-mail filter/phising protection
Commands when you need them
Accessing icons and commands
The Print Preview
Creating an Email Signature
Previous Tools /Options
Adding a signature to new Email Messages
Import & Export
Customising the Outlook Program Window
The Out of Office Assistant
TOPIC 3 - MS WORD
Ribbon, Toolbars and Galleries
Adding formatting, graphics and styles
Building Blocks
Instantly apply a new look and feel to your documents
Easily avoid spelling errors
Print Options
Line Spacing
Adding Toolbars to a Ribbon
Keyboard Shortcuts
Share documents confidently
Quickly compare two versions of a document
Find and remove hidden metadata and personal information in documents
Convert your Word documents to PDF or XPS
Instantly detect documents that contain embedded macros
Prevent changes to a final version of a document
Reduce file sizes and improve corruption recovery
Connect your documents to business information
Program recovery
KeyTips for Word 2010
Compatibility with Previous Versions
TOPIC 4 – MS POWERPOINT
A new and intuitive user interface
Themes and Quick Styles
Custom slide layouts
Designer-quality SmartArt graphics
New and improved effects
New text options
Table and chart enhancements
Proofing Tools
Presenter view
Share information effectively
Slide Libraries
File Formats
PowerPoint XML file formats
Save as PDF or XPS
Protect and manage information
Secure your presentations
Prevent changes to a final version of a document
Find and remove hidden metadata and personal information in documents
Add a digital signature to your presentation
Information Rights Management
Manage document properties in the Document Information Panel
Program Recovery
Adding Audio to a Presentation
Excel
Introduction to Microsoft Excel 2010
Results-oriented user interface
Main Page Layout
More rows and columns, and other new limits
TOPIC 5 - MS EXCEL
Office themes and Excel styles
Rich Conditional formatting
Easy formula writing
Improved sorting and filtering
Excel table enhancements
Charts – new look
Shared charting
Easy-to-use PivotTables
New Slicer feature
Quick connections to external data
New file formats
Printing and sharing
Quick access to more templates
Enabling the Solver and other Add Inn features
TOPIC 6 – MS ACCESS
More Templates
Objects are displayed in a Pane on the left hand side of the screen
Improved Datasheet view
Showing Totals in Datasheet view for Tables and Queries
Attachment Data type for Table field
Tables and Queries in datasheet view now have Filters
Layout View
Stacked and Tabular Layout
The Tabular feature
Creating tables, queries, forms, reports and macros
Tabbed Objects
Grouping and sorting in reports
Split Forms
Calendar for picking dates (ActiveX calendars no longer supported)
Exporting or Sending reports in PDF format
Sql Export button
Data collection by using InfoPath forms and Outlook
The Database Window
Old and New Access Files
Switchboards
Other Tips