Microsoft® Office 2010: Transition from Office 2003

Course Specifications

Course number: 084574 Course length: 1.0 day(s)

Course Description

Course Objective: You will work with the new and updated features of Microsoft Office 2010. Target Student: Users with prior experience of previous versions of the Microsoft Office suite, who are looking to transition to 2010 and want to know what the new features of Office 2010 are. Course Objectives

Upon successful completion of this course, students will be able to:

  • identify the new and enhanced features that are common to all applications in the Microsoft Office suite.
  • modify documents using Microsoft Word 2010.
  • present worksheet data using Microsoft Excel 2010.
  • create Microsoft PowerPoint 2010 presentations.
  • work with databases using Microsoft Access 2010.
  • manage tasks using the new features in Microsoft Outlook 2010.
  • share files using Microsoft Office 2010.

Course Content

Lesson 1: Getting Started with Microsoft Office 2010

Topic 1A: Customize the User Interface

Topic 1B: Work with Ribbon Tabs

Topic 1C: Save Files in Different Formats

Topic 1D: Print Files

Lesson 2: Modifying Documents Using Microsoft Word 2010

Topic 2A: Navigate and Find Information

Topic 2B: Apply Text Styles

Topic 2C: Add SmartArt Graphics

Topic 2D: Insert Screenshots in a Document

Topic 2E: Compare Reviewed Documents

Lesson 3: Working with Spreadsheets Using Microsoft Excel 2010

Topic 3A: Work with Tables

Topic 3B: Apply a Formula

Topic 3C: Apply Enhanced Conditional Formatting

Topic 3D: Create Charts

Topic 3E: Create Sparklines

Topic 3F: Work with PivotTables and PivotCharts

Lesson 4: Creating Dynamic Presentations Using Microsoft PowerPoint 2010

Topic 4A: Apply Themes

Topic 4B: Apply Picture Effects

Topic 4C: Apply Animation and Transition Effects

Topic 4D: Add Videos

Topic 4E: Divide a Presentation into Sections

Lesson 5: Working with Databases Using Microsoft Access 2010

Topic 5A: Work with Tables

Topic 5B: Work with Queries and Macros

Topic 5C: Create Forms

Topic 5D: Create Reports

Topic 5E: Work with External Data

Topic 5F: Design a Database for the Web

Lesson 6: Managing Information at Work with Microsoft Outlook 2010

Topic 6A: Manage Email Messages

Topic 6B: Locate Information Quickly

Topic 6C: Share Calendar Information

Topic 6D: Share Contact Information

Topic 6E: Add RSS Feeds

Lesson 7: Sharing Microsoft Office 2010 Files

Topic 7A: Protect Files

Topic 7B: Share Files