Vista Box

Excel 2007Microsoft Excel 2007 Training Course

Video-Based Training with Instructor Deanna Reynolds

117

Video Tutorials Running 490 minutes

Add to Cart

ELL

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

KeyStone Live

Outline summary view a detailed outline

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

System Requirements

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

Summary of Excel 2007 Training

This Microsoft Office Excel 2007 Essentials Course will lead you through the new results-oriented interface of Excel 2007. You will learn how to create more professional-looking charts, share data with enhanced security with your coworkers, customers, and business partners, and manage your business information more effectively.

Highlights—Learn how to:

Excel Find the appropriate tool commands that you want, when you need them.
Sheets Import, organize, and explore data with expanded spreadsheets, with a bigger grid that supports multi-core processor platforms.
PivotTable Create and use interactive PivotTable views that enable you to retrieve data to help you answer multiple questions.
Share Share spreadsheets and ensure you and your organization work with the most current business information.
Consolodate Consolidate data using position, category, and three dimensional formulas

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."