Office 2010: Transition from Office 2003

COURSE OUTLINE:

Description This full-day course provides experienced Office 2003 users with an overview of the changes made between Office 2003 and 2010. Attendees will explore the new and updated features of Microsoft Office 2010 and will learn several tips and tricks that will allow them to use Microsoft Office more effeciently.

Prerequisites
To be successful in this course, you should be familiar with prior versions of the Microsoft Office suite of products (Excel, PowerPoint, Word, Access, and Outlook).

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

  • Identify the features that are common to all applications in the Microsoft Office suite.
  • Modify documents using Microsoft Office Word 2010.
  • Present spreadsheet data using Microsoft Office Excel 2010.
  • Create Microsoft Office PowerPoint 2010 presentations.
  • Work with databases using Access 2010.
  • Manage tasks using the new features in Microsoft Office Outlook 2010.
  • Share files in Microsoft Office 2010.

Course Content


LESSON 1: GETTING STARTED WITH MICROSOFT OFFICE 2010

Topic 1A: Customize the User Interface
Topic 1B: Work with Contextual Tabs
Topic 1C: Save Files
Topic 1D: Print Files

LESSON 2: MODIFYING DOCUMENTS USING MICROSOFT OFFICE WORD 2010

Topic 2A: Use the Navigation Pane
Topic 2B: Apply Text Styles
Topic 2C: Work with SmartArt Graphics
Topic 2D: Insert Screenshots in a Document
Topic 2E: Compare Reviewed Documents

LESSON 3: WORKING WITH SPREADSHEETS USING MICROSOFT OFFICE EXCEL 2010

Topic 3A: Work with Tables in Excel 2010
Topic 3B: Apply Conditional Formatting
Topic 3C: Apply a Formula
Topic 3D: Work with 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 to Presentations
Topic 4C: Applying Animation Effects
Topic 4D: Add Videos to a Presentation
Topic 4E: Divide a Presentation into Sections

LESSON 5: WORKING WITH DATABASES USING MICROSOFT OFFICE ACCESS 2010

Topic 5A: Work with Tables
Topic 5B: Work with Forms
Topic 5C: Work with Macros
Topic 5D: Work with Reports
Topic 5E: Work with External Data
Topic 5F: Designing a Database for the Web

LESSON 6: MANAGING TASKS WITH MICROSOFT OFFICE OUTLOOK 2010

Topic 6A: Manage Mail Messages
Topic 6B: Locate Information Quickly
Topic 6C: Share Calendar Information
Topic 6D: Share Information by Using an Electronic Business Card
Topic 6E: Add RSS Feeds Through Outlook 2010

LESSON 7: SHARING MICROSOFT OFFICE 2010 FILES

Topic 7A: Protect Files
Topic 7B: Share Files Using Office Web Apps