<< Back to Courses

Upgrade to Office 2010 (onsite only)


Cost: Contact us for quote.   Duration: 1 day


Contact Us to book.

Overview
This course aims to provide the necessary skills and knowledge required to use the new features and enhancements found in the
major applications of Microsoft Office 2010.

Learning Outcomes
At the completion of this course you should be able to:
• use the more convenient printing settings in Office 2010
• use the new formatting features found in Office 2010
• understand what has changed in Microsoft Word 2010
• find the standard page layout features of Word 2010
• create a mail merge operation in Word 2010
• use the formatting features of Microsoft Excel 2010
• work with Excel 2010’s formulas and functions
• use the charting features in Excel 2010
• create effective presentations using the new and enhanced features of PowerPoint 2010
• work with many of the new features of Outlook 2010
• create and read email messages in Outlook 2010
• use the Calendar feature in Outlook 2010
• work with Contacts in Outlook 2010

Duration
Scheduled classroom training (1 Day)

Prerequisites
This course is for experienced users Microsoft Office users who need to know how to use the key new features and
enhancements in the major applications, Word, Excel, PowerPoint, and Outlook, of Microsoft Office 2010. It is assumed the
participant can create and modify basic documents, workbooks and presentations. 

Course Topics

The Office 2010 Interface
• Understanding the Office 2010
Interface
• Starting an Office 2010 Application
• Understanding the Ribbon
• Using The Ribbon
• Using Ribbon Key Tips
• Minimising The Ribbon
• Understanding the Quick Access
Toolbar
• Launching Dialog Boxes
• Understanding the Status Bar
• Understanding the Backstage View
• Accessing the Backstage View

Printing From Office 2010
• Print Previewing in Office 2010
• Choosing a Printer
• Specifying Print Settings
• Specifying Page Layout Settings
• Changing Printer Properties

Formatting in Office 2010
• Understanding Formatting in Office
2010
• Using Home Tab Commands
• Applying Styles in Office 2010
• Applying a Different Style Set
• Applying Table Styles
• Applying Themes

Pictures
• Understanding Pictures
• Inserting a Picture
• Changing the Picture
• Removing a Picture Background
• Correcting Pictures
• Changing Picture Colouring
• Applying Artistic Effects
• Changing Picture Styles
• Changing Picture Effects
• Repositioning Pictures
• The Picture Format Short Cut Menu
• Changing the Picture Layout

Microsoft Word 2010
• What’s New in Word 2010
• Where Are They Now in Word 2010?
• The Word 2010 Screen
• Word 2010 File Formats
• Creating Building Blocks
• Organising Building Blocks
• Deleting Building Blocks
• Spell Checking in Word 2010
• Working With the Navigation Pane
• Locating Non Textual items
• Applying Styles in Word 2010
• Modifying Styles in Word 2010
• Other Style Tricks in Word 2010
• Enabling Actions
• Clever Tricks Using Actions

Page Layout in Word 2010
• The Page Layout Tabs
• Changing Standard Page Setup
• Inserting Section Breaks
• Quick Headers and Footers
• Saving a Header to the Gallery
• Working With the Custom Headers
• Inserting Page Numbering
• Inserting a Blank Page
• Inserting a Cover Page
• Watermarks and Page Colours

 

 

Merging in Word 2010
• Understanding Merging in Word
2010
• Merging Using the Wizard
• Writing the Merging Letter
• Completing the Merge
• Creating Merges From the Ribbon
• Running Merges From the Ribbon
• Opening an Existing Merge
• Working With Recipient Lists

Microsoft Excel 2010
• What’s New in Excel 2010
• Where Are They Now in Excel 2010?
• The Excel 2010 Screen
• Excel 2010 File Formats
• Headings and Gridlines
• Views of the Worksheet
• Print Options From the Ribbon
• Spell Checking in Excel 2010

Formatting in Excel 2010
• Simple Formatting
• Clearing Cells
• Applying Cell Styles
• Modifying Styles
• Applying Themes to Styled Cells
• Understanding Conditional
Formatting
• Formatting Cells Containing Values
• Top Ten Items
• Working With Data Bars
• Working With Colour Scales
• Working With Icon Sets
• Creating Your Own Rules
• Understanding Sparklines
• Creating Sparklines
• Editing Sparklines

Working With Formulas
• Using the Formula Bar Box
• Function Changes
• The Formulas Tab On the Ribbon
• Using the Formulas Tab
• Using Range Names in Excel 2010
• Creating Formulas With
AutoComplete
• Useful Statistical Functions
• Working With the Name Manager
• Using the Watch Window

Charting in Excel 2010
• Creating a New Chart
• Changing the Chart Type
• Changing the Chart Layout
• Changing the Chart Style
• Formatting Chart Elements
• Relocating a Chart
• Saving a Chart Template

Microsoft PowerPoint 2010
• What’s New in PowerPoint 2010
• Where Are They Now in PowerPoint
2010?
• The PowerPoint 2010 Screen
• PowerPoint 2010 File Formats
• PowerPoint 2010 Preferences and
Settings
• Creating a Presentation
• Cropping a Picture
• Aligning Objects
• Building Equations
• Creating Custom Shapes
• Animating Objects
• Copying Animations
• Applying Slide Transitions
• Creating Sections

Microsoft Outlook 2010
• What’s New in Outlook 2010
• Where Are They Now in Outlook
2010?
• Common Outlook 2010 Screen
Elements
• Navigating to Outlook Features
• The Navigation Pane
• The To-Do Bar
• The Mail Screen
• The Calendar Screen
• The Contacts Screen
• The Tasks Screen
• The Notes Screen
• The Outlook Today Screen

Outlook 2010 Mail
• The Message Window
• Creating a New Message
• Checking the Spelling
• Adding an Attachment to a Message
• Adding Importance
• Requesting Message Receipts
• Opening an Outlook Data File
• Adjusting the Message View
• Arranging Messages
• Understanding Conversation View
• Navigating Messages in a
Conversation
• Replying to a Message in a
Conversation
• Finding Related Messages
• Ignoring Conversations
• Cleaning Up conversations
• Automating Common Tasks With
Quick Steps
• Customising a Default Quick Step
• Creating a Quick Step
• Using Quick Steps
• Spamming and Junk Email
• Phishing and Junk Email

Outlook 2010 Calendar
• Accessing the Calendar
• Changing the Calendar Arrangement
• Displaying Specific Dates
• Navigating Within a Calendar
• Changing the Current View
• Sharing Calendars
• Working With Multiple Calendars
• Scheduling an Appointment Using
Click to Add
• Scheduling Using the Appointment
Window
• Scheduling an Event
• Scheduling Free and Busy Time
• Categorising Activities
• Meeting Response Options
• Responding to Meeting Requests

Outlook 2010 Contacts
• Understanding the Contact Form
• Understanding Electronic Business
Cards
• Viewing Your Contacts
• Creating a New Contact
• Entering Contact Details
• Inserting a Contact Picture
• Changing a Business Card Layou

Concluding Remarks

 


 

 



Zip File
Download Exercise Files