Ready for next | ConnecTotal
PeopleForever Computer Training | ConnectTrain Business Skills
PeopleForever Computer Training | ConnectTrain Business Skills
| 1994-2010 ConnecTotal All rights reserved. |
What our customers say...
"Makes me comfortable when
questioning everything!!"
"Very on track with pace of
class."
"Fantastic class. I like the small
group and hands on."
"Very patient and clear
instruction."
"This class has been a great
help in furthering my
knowledge."
"I learned a lot and refreshed
what I already knew."
"Makes me comfortable when
questioning everything!!"
"Very on track with pace of
class."
"Fantastic class. I like the small
group and hands on."
"Very patient and clear
instruction."
"This class has been a great
help in furthering my
knowledge."
"I learned a lot and refreshed
what I already knew."
 |
| |
 |
| |
 |
| |
 |
| |
 |
ExpressLine Transition Microsoft® Office 2003 to 2010 for the following:
Word® 2010: Transition from Word 2003 (1/2 Day)
Excel® 2010: Transition from Excel 2003 (1/2 Day)
Access® 2010: Transition from Access 2003 (1/2 Day)
Outlook® 2010: Transition from Outlook 2003 (1/2 Day)
PowerPoint® 2010: Transition from PowerPoint 2003 (1/2 Day)
Scroll down for each course description.
Word 2010: Transition from Word 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Word 2010 environment.
•add images, styles, and themes to documents.
•use the advanced features to add building blocks, equations, citations, and bibliography to a document.
•finalize documents.
•work with Office Web Apps to save and access documents from the web.
Lesson 1: Identifying the Components of the Word 2010 Environment
Topic 1A: Identify the New Interface Features
Topic 1B: Work with the Ribbon
Topic 1C: Use Options on Contextual Tabs
Topic 1D: Use the Galleries
Topic 1E: Customize the Interface
Lesson 2: Adding Images, Styles, and Themes
Topic 2A: Apply Styles
Topic 2B: Apply Document Themes
Topic 2C: Add Visual Effects
Topic 2D: Work with Images
Lesson 3: Using Advanced Features
Topic 3A: Add Building Blocks
Topic 3B: Build Equations
Topic 3C: Use the Navigation Pane
Topic 3D: Add Citations and Bibliographies
Lesson 4: Finalizing Documents
Topic 4A: Compare Reviewed Documents
Topic 4B: Inspect Documents
Topic 4C: Perform a Compatibility Check
Lesson 5: Working with Office Web Apps
Topic 5A: Save Documents to the Web
Topic 5B: Access Documents from the Web
Appendix A: New Features in Microsoft® Office Word 2010
Appendix B: Secure a Document
Appendix C: Ink Formatting in Tablet PCs
Appendix D: Mobile Features
Excel 2010: Transition from Excel 2003
Upon successful completion of this course, students will be able to:
•identify the elements of the Microsoft Office Excel 2010 environment.
•organize data in Excel worksheets.
•analyze Excel data by sorting, filtering, and conditionally formatting it.
•present Excel data using charts, illustrations and PivotTables.
•use Office Web Apps.
Lesson 1: Identifying the Elements of the Excel 2010 Environment
Topic 1A: Identify the User Interface Elements
Topic 1B: Identify the Ribbon Components
Topic 1C: Use Contextual Tabs
Topic 1D: Use Excel Galleries
Topic 1E: Customize the Excel Interface
Lesson 2: Organizing Data
Topic 2A: Identify the Enhancements to Excel 2010 Spreadsheets
Topic 2B: Insert Tables
Topic 2C: Format Tables
Lesson 3: Analyzing Data
Topic 3A: Apply Conditional Formatting
Topic 3B: Sort Data in a Spreadsheet
Topic 3C: Filter Data in a Spreadsheet
Topic 3D: Apply a Formula
Lesson 4: Presenting Data
Topic 4A: Create Charts
Topic 4B: Format Charts
Topic 4C: Work with Illustrations
Topic 4D: Create PivotTables and PivotCharts
Topic 4E: Share Excel Charts
Topic 4F: Save Data in Compatible Formats
Lesson 5: Using Office Web Apps
Topic 5A: Save Excel Spreadsheets to the Web
Topic 5B: Access and Work with Spreadsheets on the Web
Appendix A: New Features in Microsoft Office Excel 2010
Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2010
Appendix C: Link Formatting in Tablet PCs
Appendix D: Mobile Features
Access 2010: Transition from Access 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Microsoft Office Access 2010 interface.
•build tables and forms and also work with macros.
•create queries and reports.
•work with external data.
•build a database for the web.
Lesson 1: Identifying the Components of the Access 2010 Environment
Topic 1A: Explore the User Interface
Topic 1B: Access Commands on the Ribbon Tabs
Topic 1C: Access the Contextual Tabs
Topic 1D: Customize the Access Environment
Lesson 2: Building Tables and Forms
Topic 2A: Create a Table
Topic 2B: Build Forms from Existing Table Data
Topic 2C: Design a Form
Topic 2D: Work with Macros
Lesson 3: Creating Queries and Reports
Topic 3A: Query a Database
Topic 3B: Generate Reports
Topic 3C: Format a Report
Lesson 4: Working with External Data
Topic 4A: Import Data
Topic 4B: Export Data to Other Applications
Lesson 5: Building a Database for the Web
Topic 5A: Create Tables and Forms in a Web Database
Topic 5B: Create Queries and Reports in a Web Database
Topic 5C: Prepare to Publish a Database to Access Services
Appendix A: New Features in Microsoft Office Access 2010
Appendix B: Enhanced File and Compatibility Features in Access
Appendix C: Publish a Database to Access Services
Outlook 2010: Transition from Outlook 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Outlook 2010 interface.
•work with email messages.
•manage calendars.
•manage email messages.
Lesson 1: Identifying the Components of the Outlook 2010 Interface
Topic 1A: Identify the Components of the Outlook Window
Topic 1B: Identify the Tabs and Groups on the Ribbon
Topic 1C: Customize the Outlook Interface
Lesson 2: Working with Email Messages
Topic 2A: Format an Email Message
Topic 2B: Insert Graphical Objects in an Email Message
Topic 2C: Manage Email Messages
Topic 2D: Share Contact Information Using Business Cards
Lesson 3: Managing Calendars in Outlook
Topic 3A: Create Tasks Using Outlook Calendar
Topic 3B: Customize the Calendar View
Topic 3C: Schedule a Meeting
Topic 3D: Share Calendar Information
Lesson 4: Managing Email Messages in Outlook
Topic 4A: Manage Junk Email Messages
Topic 4B: Search for Information in Outlook
Topic 4C: Clean Up Conversations and Folders
Topic 4D: Set Access Permissions
Topic 4E: Add RSS Feeds in Outlook 2010
Appendix A: New Features in Microsoft® Outlook® 2010
Appendix B: Out of Office Notifications in Outlook
Appendix C: Outlook and Other Office Applications and Services
PowerPoint 2010: Transition from PowerPoint 2003
Upon successful completion of this course, students will be able to:
•identify the elements of the PowerPoint environment.
•build the framework of a presentation.
•add visual elements to a presentation.
•prepare to deliver a presentation.
•work with shared presentations.
Lesson 1: Identifying the Elements of the PowerPoint Environment
Topic 1A: Identify the Components of the User Interface
Topic 1B: Use the Task-Oriented Tabs on the Ribbon
Topic 1C: Customize the PowerPoint Interface
Lesson 2: Building the Framework of a Presentation
Topic 2A: Create a Presentation
Topic 2B: Save a Presentation
Topic 2C: Create Custom Slide Layouts
Topic 2D: Create and Apply Themes
Lesson 3: Adding Visual Elements to a Presentation
Topic 3A: Apply Rich Text and Typography Effects
Topic 3B: Apply Animation Effects
Topic 3C: Work with Pictures and SmartArt Graphics
Topic 3D: Add Styles and Effects to a Table
Topic 3E: Work with Chart Tools
Topic 3F: Add and Manage Videos
Lesson 4: Preparing to Deliver a Presentation
Topic 4A: Divide a Presentation into Sections
Topic 4B: Add Transitions
Topic 4C: Print a Presentation
Topic 4D: Secure a Presentation
Lesson 5: Working with Shared Presentations
Topic 5A: Share PowerPoint Presentations
Topic 5B: Work with Presentations by Using a Web Browser
Appendix A: New Features in PowerPoint 2010
Appendix B: PowerPoint Mobile 2010
Word® 2010: Transition from Word 2003 (1/2 Day)
Excel® 2010: Transition from Excel 2003 (1/2 Day)
Access® 2010: Transition from Access 2003 (1/2 Day)
Outlook® 2010: Transition from Outlook 2003 (1/2 Day)
PowerPoint® 2010: Transition from PowerPoint 2003 (1/2 Day)
Scroll down for each course description.
Word 2010: Transition from Word 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Word 2010 environment.
•add images, styles, and themes to documents.
•use the advanced features to add building blocks, equations, citations, and bibliography to a document.
•finalize documents.
•work with Office Web Apps to save and access documents from the web.
Lesson 1: Identifying the Components of the Word 2010 Environment
Topic 1A: Identify the New Interface Features
Topic 1B: Work with the Ribbon
Topic 1C: Use Options on Contextual Tabs
Topic 1D: Use the Galleries
Topic 1E: Customize the Interface
Lesson 2: Adding Images, Styles, and Themes
Topic 2A: Apply Styles
Topic 2B: Apply Document Themes
Topic 2C: Add Visual Effects
Topic 2D: Work with Images
Lesson 3: Using Advanced Features
Topic 3A: Add Building Blocks
Topic 3B: Build Equations
Topic 3C: Use the Navigation Pane
Topic 3D: Add Citations and Bibliographies
Lesson 4: Finalizing Documents
Topic 4A: Compare Reviewed Documents
Topic 4B: Inspect Documents
Topic 4C: Perform a Compatibility Check
Lesson 5: Working with Office Web Apps
Topic 5A: Save Documents to the Web
Topic 5B: Access Documents from the Web
Appendix A: New Features in Microsoft® Office Word 2010
Appendix B: Secure a Document
Appendix C: Ink Formatting in Tablet PCs
Appendix D: Mobile Features
Excel 2010: Transition from Excel 2003
Upon successful completion of this course, students will be able to:
•identify the elements of the Microsoft Office Excel 2010 environment.
•organize data in Excel worksheets.
•analyze Excel data by sorting, filtering, and conditionally formatting it.
•present Excel data using charts, illustrations and PivotTables.
•use Office Web Apps.
Lesson 1: Identifying the Elements of the Excel 2010 Environment
Topic 1A: Identify the User Interface Elements
Topic 1B: Identify the Ribbon Components
Topic 1C: Use Contextual Tabs
Topic 1D: Use Excel Galleries
Topic 1E: Customize the Excel Interface
Lesson 2: Organizing Data
Topic 2A: Identify the Enhancements to Excel 2010 Spreadsheets
Topic 2B: Insert Tables
Topic 2C: Format Tables
Lesson 3: Analyzing Data
Topic 3A: Apply Conditional Formatting
Topic 3B: Sort Data in a Spreadsheet
Topic 3C: Filter Data in a Spreadsheet
Topic 3D: Apply a Formula
Lesson 4: Presenting Data
Topic 4A: Create Charts
Topic 4B: Format Charts
Topic 4C: Work with Illustrations
Topic 4D: Create PivotTables and PivotCharts
Topic 4E: Share Excel Charts
Topic 4F: Save Data in Compatible Formats
Lesson 5: Using Office Web Apps
Topic 5A: Save Excel Spreadsheets to the Web
Topic 5B: Access and Work with Spreadsheets on the Web
Appendix A: New Features in Microsoft Office Excel 2010
Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2010
Appendix C: Link Formatting in Tablet PCs
Appendix D: Mobile Features
Access 2010: Transition from Access 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Microsoft Office Access 2010 interface.
•build tables and forms and also work with macros.
•create queries and reports.
•work with external data.
•build a database for the web.
Lesson 1: Identifying the Components of the Access 2010 Environment
Topic 1A: Explore the User Interface
Topic 1B: Access Commands on the Ribbon Tabs
Topic 1C: Access the Contextual Tabs
Topic 1D: Customize the Access Environment
Lesson 2: Building Tables and Forms
Topic 2A: Create a Table
Topic 2B: Build Forms from Existing Table Data
Topic 2C: Design a Form
Topic 2D: Work with Macros
Lesson 3: Creating Queries and Reports
Topic 3A: Query a Database
Topic 3B: Generate Reports
Topic 3C: Format a Report
Lesson 4: Working with External Data
Topic 4A: Import Data
Topic 4B: Export Data to Other Applications
Lesson 5: Building a Database for the Web
Topic 5A: Create Tables and Forms in a Web Database
Topic 5B: Create Queries and Reports in a Web Database
Topic 5C: Prepare to Publish a Database to Access Services
Appendix A: New Features in Microsoft Office Access 2010
Appendix B: Enhanced File and Compatibility Features in Access
Appendix C: Publish a Database to Access Services
Outlook 2010: Transition from Outlook 2003
Upon successful completion of this course, students will be able to:
•identify the components of the Outlook 2010 interface.
•work with email messages.
•manage calendars.
•manage email messages.
Lesson 1: Identifying the Components of the Outlook 2010 Interface
Topic 1A: Identify the Components of the Outlook Window
Topic 1B: Identify the Tabs and Groups on the Ribbon
Topic 1C: Customize the Outlook Interface
Lesson 2: Working with Email Messages
Topic 2A: Format an Email Message
Topic 2B: Insert Graphical Objects in an Email Message
Topic 2C: Manage Email Messages
Topic 2D: Share Contact Information Using Business Cards
Lesson 3: Managing Calendars in Outlook
Topic 3A: Create Tasks Using Outlook Calendar
Topic 3B: Customize the Calendar View
Topic 3C: Schedule a Meeting
Topic 3D: Share Calendar Information
Lesson 4: Managing Email Messages in Outlook
Topic 4A: Manage Junk Email Messages
Topic 4B: Search for Information in Outlook
Topic 4C: Clean Up Conversations and Folders
Topic 4D: Set Access Permissions
Topic 4E: Add RSS Feeds in Outlook 2010
Appendix A: New Features in Microsoft® Outlook® 2010
Appendix B: Out of Office Notifications in Outlook
Appendix C: Outlook and Other Office Applications and Services
PowerPoint 2010: Transition from PowerPoint 2003
Upon successful completion of this course, students will be able to:
•identify the elements of the PowerPoint environment.
•build the framework of a presentation.
•add visual elements to a presentation.
•prepare to deliver a presentation.
•work with shared presentations.
Lesson 1: Identifying the Elements of the PowerPoint Environment
Topic 1A: Identify the Components of the User Interface
Topic 1B: Use the Task-Oriented Tabs on the Ribbon
Topic 1C: Customize the PowerPoint Interface
Lesson 2: Building the Framework of a Presentation
Topic 2A: Create a Presentation
Topic 2B: Save a Presentation
Topic 2C: Create Custom Slide Layouts
Topic 2D: Create and Apply Themes
Lesson 3: Adding Visual Elements to a Presentation
Topic 3A: Apply Rich Text and Typography Effects
Topic 3B: Apply Animation Effects
Topic 3C: Work with Pictures and SmartArt Graphics
Topic 3D: Add Styles and Effects to a Table
Topic 3E: Work with Chart Tools
Topic 3F: Add and Manage Videos
Lesson 4: Preparing to Deliver a Presentation
Topic 4A: Divide a Presentation into Sections
Topic 4B: Add Transitions
Topic 4C: Print a Presentation
Topic 4D: Secure a Presentation
Lesson 5: Working with Shared Presentations
Topic 5A: Share PowerPoint Presentations
Topic 5B: Work with Presentations by Using a Web Browser
Appendix A: New Features in PowerPoint 2010
Appendix B: PowerPoint Mobile 2010