Course Length: 6hrs (1 Day)
Office 2010 Transition is a course designed for people currently using previous versions of Microsoft Office software (MS Office 2003 or 2007) and who want to discover the new time saving and efficient features in Office 2010.
Learning Objectives:
In this course, you will:
- Customize the User Interface using the new Quick Access Toolbar and Customize Ribbon Commands
- Save Files in Multiple Formats Using Updated Programs
- Add SmartArt Graphics in Word, Excel and PowerPoint
- Insert Screenshots in a Document in Word, Excel and PowerPoint
- Learn How to Use Quick Parts in Word
- Work with Excel and utilize new features such as, Sparkline's, Slicers, and improved Pivot Table and Chart Formats and Options
- Create Dynamic Presentations Using Microsoft PowerPoint's new features such as Themes, Picture Effects, New Animations and Transitions
- Save Your PowerPoint presentation as a Videos
- Create Sections to Organize Your Presentation Better
- Create and Use New Databases with Access using updated Table, Query, Form, Report and Macro objects
- Import and Export External Data between Excel, Word and other programs
- Design a Database for the Web
- Managing Information with Microsoft Outlook's New Email, Calendar, Task, Contacts and Notes Features
- Share Information
- Add RSS Feeds
- Share and Protect Microsoft Office 2010 Files
Target Student:
This course is designed for people who currently use a previous version of Microsoft Office, 2003 or 2007 and want to know how to improve their productivity by utilizing time saving features.
Course Outline:
Section 1: Getting Started with Microsoft Office 2010
Customize the User Interface
Work with Ribbon Tabs
Save Files in Different Formats
Print Files
Section 2: Modifying Documents Using Microsoft Word 2010
Navigate and Find Information
Apply Text Styles
Add SmartArt Graphics
Insert Screenshots in a Document
Compare Reviewed Documents
Overview of Quick Parts
Section 3: Working with Spreadsheets Using Microsoft Excel 2010
Work with Tables
Apply a Formula
Apply Enhanced Conditional Formatting
Create Charts
Create Sparklines
Work with PivotTables and PivotCharts
Section 4: Creating Dynamic Presentations Using Microsoft PowerPoint 2010
Apply Themes
Apply Picture Effects
Apply Animation and Transition Effects
Add Videos
Divide a Presentation into Sections
Section 5: Working with Databases Using Microsoft Access 2010
Work with Tables
Work with Queries and Macros
Create Forms
Create Reports
Work with External Data
Design a Database for the Web
Section 6: Managing Information at Work with Microsoft Outlook 2010
Manage Email Messages
Locate Information Quickly
Share Calendar Information
Share Contact Information
Add RSS Feeds
Section 7: Sharing Microsoft Office 2010 Files
Protect Files
Share Files