Vista Box

Office 2007Microsoft Office 2007 Training Course

Video-Based Training with Instructor Deanna Reynolds

516

Video TutorialsRunning 41 hours, 59 minutes Covering Word, Powerpoint, Excel, Outlook, & Access

Add to Cart

ELL

For Enterprise/Multi-User licensing click here Train 10 or more users across your organization.

KeyStone Live

Outline summary view a detailed outline

Microsoft Access 2007: Beginner

  • 1.0 Getting Started
  • 2.0 Working with an Existing Table
  • 3.0 Working with an Existing Form
  • 4.0 Sorting and Filtering
  • 5.0 Designing Select Queries
  • 6.0 Form Basics
  • 7.0 Report Basics
  • 8.0 Printing Database Objects

Microsoft Access 2007: Intermediate

  • 1.0 Planning and Designing a Database
  • 2.0 Building and Modifying Tables
  • 3.0 Working with Relationships
  • 4.0 Sharing Your Data
  • 5.0 Enhancing Your Forms
  • 6.0 Enhancing Your Reports

Microsoft Access 2007: Advanced

  • 1.0 Preventing Data Entry Errors
  • 2.0 Advanced Table Design
  • 3.0 Advanced Query Design
  • 4.0 Advanced Form Design
  • 5.0 Advanced Report Design
  • 6.0 Managing Databases

Microsoft Access 2007: Expert

  • 1.0 Expertly Designed Select Queries
  • 2.0 Action Queries
  • 3.0 Expertly Designed Forms
  • 4.0 Expertly Designed Reports
  • 5.0 Data Access Pages
  • 6.0 Macros
  • 7.0 Database Security

Microsoft Excel 2007: Beginner

  • 1.0 Getting Started
  • 2.0 Entering Data
  • 3.0 Changing Worksheet Layout
  • 4.0 Entering Formulas
  • 5.0 Formatting
  • 6.0 Using Themes and Styles
  • 7.0 Printing
  • 8.0 Charts

Microsoft Excel 2007: Intermediate

  • 1.0 Managing Workbooks
  • 2.0 Tables and Data Management
  • 3.0 Using Cell References
  • 4.0 Auditing
  • 5.0 Creating Web Pages from Workbooks
  • 6.0 Using Excel with Other Applications
  • 7.0 Customizing Excel
  • 8.0 Using Scenarios and Watching Cells
  • 9.0 PivotTables and PivotCharts

Microsoft Excel 2007: Advanced

  • 1.0 Collaborating
  • 2.0 Advanced Formulas and Functions
  • 3.0 Data Consolidation
  • 4.0 SmartArt
  • 5.0 Track Revisions
  • 6.0 Data Validation and Conditional Formatting
  • 7.0 Creating Templates
  • 8.0 Macros

Microsoft Outlook 2007: Beginner

  • 1.0 Getting Started
  • 2.0 Reading & Sending E-mail
  • 3.0 Replying to & Forwarding Messages
  • 4.0 Formatting Messages
  • 5.0 Working with E-mail Addresses
  • 6.0 Managing Mail
  • 7.0 Printing E-mail Messages

Microsoft Outlook 2007: Intermediate

  • 1.0 Using the Calendar
  • 2.0 Planning Meetings & Appointments
  • 3.0 Advanced Contact Options
  • 4.0 Using Tasks
  • 5.0 Using Notes
  • 6.0 Advanced Mail Message Options
  • 7.0 Working with Themes

Microsoft Outlook 2007: Advanced

  • 1.0 Filtering, Finding & Flagging Messages
  • 2.0 Archiving Outlook Data
  • 3.0 Personal File Folders
  • 4.0 Using the Journal
  • 5.0 Organizing Your Outlook Items
  • 6.0 Custom Forms
  • 7.0 Working with Pictures and Shapes
  • 8.0 Working with WordArt & SmartArt
  • 9.0 Customizing Outlook

Microsoft PowerPoint 2007: Beginner

  • 1.0 Getting Started
  • 2.0 Creating a New Presentation
  • 3.0 Viewing Presentations
  • 4.0 Modifying an Existing Presentation
  • 5.0 Preparing a Presentation for Delivery

Microsoft PowerPoint 2007: Intermediate

  • 1.0 Outlines
  • 2.0 Working with Pictures and Shapes
  • 3.0 Working with Presentation Colors
  • 4.0 Working with Animation
  • 5.0 Organizing & Enhancing Your Presentation
  • 6.0 Managing Presentations
  • 7.0 Customizing PowerPoint

Microsoft PowerPoint 2007: Advanced

  • 1.0 Working with Tables
  • 2.0 Working with Charts
  • 3.0 WordArt & SmartArt
  • 4.0 Working with Templates, Masters & Custom Layouts
  • 5.0 Saving Presentations for the Web
  • 6.0 Collaboration
  • 7.0 Advanced Presentation Delivery Options

Microsoft Word 2007: Beginner

  • 1.0 Getting Started
  • 2.0 Creating New Documents
  • 3.0 Editing Existing Documents
  • 4.0 Essential Word 2007 Skills
  • 5.0 Formatting Text & Paragraphs
  • 6.0 Proofing Tools
  • 7.0 Changing Your Page Appearance

Microsoft Word 2007: Intermediate

  • 1.0 Managing Documents
  • 2.0 Additional Editing Tools
  • 3.0 Paragraph Formatting
  • 4.0 to Graphics
  • 5.0 Document Formatting
  • 6.0 Tables
  • 7.0 Customizing Word

Microsoft Word 2007: Advanced

  • 1.0 Working with Document Templates
  • 2.0 Mail Merge
  • 3.0 Macros
  • 4.0 Working with Themes
  • 5.0 SmartArt
  • 6.0 Long or Complex Documents
  • 7.0 Collaborating
  • 8.0 Using Word with Other Programs
  • 9.0 Using XML

System Requirements

This title is part of Keystone's Desktop Learning Library (DLL) which requires:

Summary Office 2007 Training

This Microsoft Office course teaches you how to effectively use the Office 2007 Suite through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the new office interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2007 edition. These courses will train you how to best meet your needs through the use of Word, Outlook, Excel, Powerpoint, and/or Access.

Highlights—Learn how to:

Office Navigate through the new easy-to-use interface, ribbon, office button, contextual tabs, and galleries.
Word Create and share documents through the new, easy-to-use interface.
Powerpoint Create presentations with pictures, shapes, animation, and advanced delivery options.
Excel Prepare professional charts and share data with coworkers, customers, and business partners.
Outlook Follow basic and advanced functions of e-mail, planning/scheduling features, and customizing the interface.
Access Track and report information with ease, modify pre-built applications, and share database information.

KeyStone Video-Based Training Offers the User:

Overview Overview: KeyStone training includes a complete overview of the instructor, product, and what to expect from the training.
Controls Controls: Users can move throughout the training with their own controls. Play, Pause, Stop, or check their time while the product bar illuminates as they advance through a topic.
Map Course Map: Choosing which topic the user wants to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users have the ability to pick up where they left off.
Bookmarks Bookmarks: KeyStone's training tracks which topics the user has completed - displaying their progress through the course outline.
Quizes Quizzes: Multiple-choice quizzes for each section covered allow the user to track their progress as they learn. Proficiency can be assessed at any time throughout the training.
Deanna Reynolds

Your Personal Instructor: Deanna Reynolds

Deanna Reynolds has worked as a technical trainer for more than ten years teaching in both the corporate and technical college environments. Throughout her teaching career, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs including the entire Microsoft Office Suite, Web Design, Desktop Publishing, and Database Development. Deanna specializes in delivering instructor-led training and writing custom courseware that helps her students quickly become "power-users."