Course Overview
You will work with the new and updated features of Microsoft Office 2010. In Word, students will learn to use the Navigation pane and apply new text effects. In Excel they will use sparklines, filter data with slicers, and create a PivotChart. In PowerPoint they will organize slides into sections, edit movie clips, apply animation effects, and learn how to broadcast slide shows. In Outlook they will manage e-mail conversations, create Quick Steps, and use the People Pane. In Access, they will learn how to use the tabbed document window, create Lookup list fields, and use the data type gallery. In addition, students will learn about ribbon customization and Backstage view, and save a file as a PDF.
Course Outline
Unit 1: The Office 2010 interface
Topic A: Office interface elements
- A-1: Using the Ribbon
- A-2: Using Live Preview
- A-3: Using the Dialog Box Launcher
- A-4: Adding a command to the Quick Access toolbar
- A-5: Using the status bar
Topic B: New Ribbon features
- B-1: Hiding and showing the Ribbon
- B-2: Rearranging Ribbon tabs
- B-3: Hiding and removing tabs and groups
- B-4: Creating a tab
- B-5: Resetting the Ribbon
Topic C: Microsoft Office Backstage view
- C-1: Viewing and editing document properties
- C-2: Specifying print settings
- C-3: Recovering a draft of a previously saved file
- C-4: Finishing a document
- C-5: Saving a file as a static document
Unit 2: New Word features
Topic A: Formatting options
- A-1: Applying text effects
- A-2: Adjusting a picture’s color
Topic B: The Navigation pane
- B-1: Using the Navigation pane to search for text
- B-2: Organizing an outline
Unit 3: New Excel features
Topic A: Sparklines
- A-1: Inserting sparklines
Topic B: PivotTables and slicers
- B-1: Creating a PivotTable
- B-2: Adding fields to a PivotTable
- B-3: Using slicers to filter PivotTable data
Topic C: PivotCharts
- C-1: Creating a PivotChart
Unit 4: New PowerPoint features
Topic A: Reading view
- A-1: Previewing and running a presentation
Topic B: Sections
- B-1: Adding sections
- B-2: Renaming sections
- B-3: Moving sections
- B-4: Printing a section
Topic C: Media clips
- C-1: Adding a video clip
- C-2: Formatting a video clip
- C-3: Specifying video playback options
Topic D: Animations
- D-1: Animating text and objects
- D-2: Using the Animation Painter
Topic E: Broadcasting a slide show online
- E-1: Discussing the Broadcast Slide Show feature
Unit 5: New Outlook features
Topic A: The Outlook interface
- A-1: Exploring the Outlook window
- A-2: Examining tabs
Topic B: Conversation management
- B-1: Creating and sending a message
- B-2: Replying to a message
- B-3: Exploring conversations
- B-4: Managing conversations
Topic C: Quick Steps
- C-1: Using Quick Steps
- C-2: Configuring Quick Steps
- C-3: Creating a Quick Step
Topic D: The People Pane
- D-1: Examining the People Pane
- D-2: Viewing custom photos in the People Pane
- D-3: Viewing contact details
Unit 6: New Access features
Topic A: The Access 2010 environment
- A-1: Using the document window
Topic B: Data features
- B-1: Preparing to use the Lookup Wizard
- B-2: Creating a lookup list
- B-3: Using the Attachment data type
- B-4: Using the Data Type gallery
Prerequisites
To be successful in this course, you should be familiar with prior versions of the Microsoft Office suite of products (Excel, PPT, Word, Access, and Outlook).