Office 2010 – Upgrading from 2003 - Course Outline

COURSE INFORMATION

Duration: One Day

Price: $400


Book: Enquire or make a course booking

TARGET AUDIENCE & PURPOSE

This course is for people who are already familiar with the basic operation of Microsoft Office 2003. This course does not show how to use Office, but rather highlights differences from the previous version.

OBJECTIVES

By the end of this course participants should be able to:

  • Locate and identify standard functionality in the new environment
  • Use the new features available in Office

PREREQUISITES

Participants should already:

  • Be competent in using a mouse and keyboard
  • Have an understanding of Windows
  • Have attended the Word, Excel, PowerPoint, Access and Outlook Introduction for either XP or 2003 versions, or Equivalent knowledge

COURSE CONTENT

Using The Office 2010 Interface
Use the Interface, File Tab & Backstage View, Quick Access Toolbar, Customize Quick Access Toolbar, Use Mini Toolbar, Ribbons, Use Ribbons & Tabs, Dialog Box Launcher, Contextual Tabs, Live Preview

WORD

Using New formatting options
Apply, Add & Remove Text Effects, Apply Picture Formatting, Add a Picture Border, Apply & Remove an Artistic effect to a picture, Remove a Picture Background

The Navigation Pane
Using the Navigation Pane, Browse by the headings in your document, Browse by pages in your document, Search for text

Using New Features In Styles
Use Quick Styles Gallery, Style Inspector, Add & Clear Styles Gallery

Formatting With Document Themes
Select a Theme, Create Theme Colours and Fonts, Theme Effects

Using Quick Parts
Create a Quick Part, Add Quick Parts to a Document, Insert Document Property Fields, Use the Building Blocks Organizer

Using New Chart Creation Features
Create a Chart, Edit Chart Data, Add a Chart Title, Change the Chart Type, Copy a Chart from Excel

Using Forms
Display the Developer Tab, Insert Form Controls, Set Properties for Content Controls, Protect a Form

Working With Revisions And Comments
Enable Balloon Options, Select Options for Show Markup, Display the Reviewing Pane, Compare Documents, Combine Multiple Revisions

Customizing Word Preferences
Set Word Options

EXCEL

Exploring New Excel Features
Insert a New Worksheet, Freeze Panes, Explore Excel Options, Customize the Status Bar, Use Page Layout View, Use the Zoom Slider

Using Sparklines
Inserting, Creating, Customizing, Removing Sparklines

Using New Conditional Formatting Features
Use Highlight Cell Rules, Manage Rules, Clear Rules, Data Bars

Using New Pivot table Features
Create PivotTable Report, Report Fields, Expand & Collapse Buttons, Add, Insert, Use, Format, Remove Slicers

Using New Table Features
Create a Table, Remove Duplicates from a Table

Using New Formula Features
Use Formula AutoComplete, View New Functions

 

Using New Sort And Filtering Features
Sort Records by Multiple Fields, Filter Data to find Above Average

Using New File Format Features
Use the Document Inspector, Mark a Workbook as Final, Save to a PDF Format, The Compatibility Checker, Convert a File to Excel 2010 Format, Save in a Binary Format

POWERPOINT

Using SmartArt
Insert, Format, Resize/Reposition a SmartArt Object, Insert Text into a SmartArt Object, Format Text Within a SmartArt Object, Add Shapes to a SmartArt Object, Group SmartArt Objects

Inserting A Photo Album
Insert Pictures from a File, Add Captions, Apply a Theme to your Album, Customize the Album Layout

Enhancing Slide Layouts
Create a Custom Layout, Apply a Theme, a Background Style, Change Slide Orientation

Enhancing Graphic Images
Apply a Picture Style, Apply a Shape, Add Effects, Add a Border

Enhancing Typography            
Select & Customize a Shape Style, Apply Effects to a Text Placeholder, Select a WordArt Style, Edit Text Outline Colour, Apply Text Effects

Enhancing Tables
Apply a Table Style, Edit the Table Colour, Add Table Effects, Format Table Text Use Quick Styles, Add Table Borders    

Sections
Organise Slides in Sections, Inserting Media Clips, Insert & Embed Videos

Sharing Your Presentation
Inspect the Document, Create a Custom Show, Encrypt the Presentation, Add a Digital Signature, Grant Permissions, Compress Pictures

OUTLOOK

Exploring The New Outlook Interface
View the Navigation Pane, To-Do Bar, Ribbon

Working With New E-Mail Features
Using Backstage View, Using the Attachment Previewer, Quick Steps, Create a Quick Step Action

Organizing Your Outlook Items
Using the To-Do Bar, Using the Instant Search, Use & Edit Colour Categories, Set a Quick Click Category, Applying a Quick Click Category

Using The New Calendar Features
Use Calendar Overlay Mode, Use the Daily Task List, E-Mail your Calendar As a Snapshot, View a Calendar Snapshot

Using The New Contact Features
Use Electronic Business Cards, E-mail an Electronic Business Card, Receive an Electronic Business Card

 

Upgrade to Office 07

Course Inclusions

COURSE FEEDBACK