At A Glance
Total Combined Length 8 Hours
Level Beginner to Advanced
Format Online & DVD
Instructor Deanna Reynolds
Course Outline View
System Requirements Online Broadband connection • 512MB RAM • Web Browser with Flash Player 9 | DVDWindows 2000/XP/Vista/7 • DVD-ROM drive • Pentium III, 128MB RAM or greater
Pricing
Multi-user Starting at /user
Single-user Online | DVD
View Pricing & Purchase
Upgrade to 2010 FREE

Delivered in KeyStone OnDemand, Our SAAS Learning Platform

  • Rapidly deploy to thousands of users
  • Easily customize course with screencams & articles
  • Robust and easy to use reporting
  • Single sign-on integration available
  • Custom development services available
  • Learn more about KeyStone OnDemand...

Why Choose KeyStone?

  • KeyStone instructors are Microsoft Certified Trainers (MCT)
  • Fully hosted: no software to download or maintain
  • Supplimental Keynotes provide text version of training
  • Engaging Video Content

KeyStone News

Highlights

  • Quickly find old features within the new results-oriented user interface and Ribbon.
  • Learn to write advanced formulas and use functions such as IF, HLOOKUP and DSUM.
  • Collaborate with team members using Excel’s comments, security and data validation options.
  • Save time with Excel’s table and list management features, including AutoFilter and Automatic Subtotals.
  • Create and use interactive PivotTables to summarize and retrieve sets of data on the fly.

Course Summary

This Microsoft Office Excel 2007 Essentials Training Course contains three levels of instruction to walk you through performing many time-saving tasks in Excel, beginning with an introduction to the new results-oriented interface. The course topics appeal to all Excel users – beginner through advanced. You will learn everything from creating professional-looking charts to sharing data with enhanced security and managing your spreadsheets more effectively.

In this course, you’ll learn from a combination of quick tips and detailed instruction on using Excel for team collaboration and creating templates to work smarter, not harder. You will learn how to create professional-looking spreadsheets through modifying the worksheet layout and formatting.

And, of course, you will learn about harnessing the power of Excel formulas with an entire section devoted to the anatomy of formula. To really understand formulas, there are additional lessons on advanced functions (such as Nested IF Statements, HLOOKUP, VLOOKUP and DSUM) and data consolidation using three dimensional formulas, position and category.

There are over 100 lessons in this Excel course – all designed to increase your productivity.

Instructor

Instructor Photo

Deanna Reynolds

MCTS, Technical Trainer, Published Author

Deanna Reynolds (MCTS) is an author and technical instructor living in Suffolk, Virginia. Since 1993, 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, project management, desktop publishing, and database development. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.

Most recently, Deanna’s technical training has extended beyond the classroom to include more than 10 DVD-ROM courses for KeyStone Learning Systems and two published books: Word 2007 Pocket Book (Prentice Hall) and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).

Related Courses

Upgrade Offer

FREE Office 2010 Upgrade

Buy any Office 2007 product today and get the Office 2010 version for free.

If you purchase a qualifying Microsoft Office 2007 product between 1/1/10 - 10/1/10, you are eligible to receive the equivalent Office 2010 product at no additional cost during your license term. This offer applies to online delivery only.

Pricing & Purchase Options

Users 1 10 25 50 100 250 500 1000+
Pricing /user /user /user /user -- -- --
Order Order Order Order Order Order Contact Contact Contact

Looking for DVD? Single-user: (Add To Cart) | Lending-License: (Add To Cart)