Excel 2007 Advanced Training Series

Excel 2007 Online Video Training

The Complete Excel 2007 Advanced Training Course

The fastest, easiest way to learn Excel 2007 and
it's more advanced data analysis features!

Learn how spreadsheets work | How to use Excel | And more

The hands-on, interactive, online training guide to mastering Excel

 

In this Excel 2007 advanced training course, you will learn Excel at a more advanced level, enhancing your ability in using its powerful features. This course is for anyone who has gained a basic understanding of Excel and wants to move into more in-depth features such as filtering and sorting data, using pivot tables, working with functions, using data analysis tools, VBA macros, and much more.

At the end of this course, you would have gained the practical skills needed to use Excel at a more advanced level. This course includes videos, interactive hands-on exercises, and exam questions (please call for multi-user license).

Please Note: This is an online training product. For CD or DVD training, click here.

Computer Class

Features & Benefits

  • Bring the classroom to your home or office
    This online video training course provides a classroom learning experience on a computer. Students can play, pause, or rewind the lessons.
  • Lessons are easy and fun to learn
    The lessons are designed to be easily understood. Animations and graphics keep the student’s interest.
  • Multimedia video training
    The lectures were recorded and presented in Full Motion Video, Audio, Graphics, & Animations.
  • Hands-on simulations and exams
    Simulations teach students through hands-on exercises. Interactive pre and post exam questions.
Multimedia online computer class

Complete Excel 2007 Advanced Training Series

Over 11 Hours of interactive video training
Limited-Time Special! Over 60% Off - Only $89.00

Session I Filtering and Sorting Data 2 Hrs outline
Session II Using Pivot Tables 2 Hrs outline
Session III Working with Functions 3 Hrs outline
Session IV Using Data Analysis Tools 1 Hr outline
Session V Automating with VBA Macros 2 Hrs outline
Session VI Add Connections and Import Data 2 Hrs outline

Bonus: Computer Fundamentals Training Series

Over 8 Hours of video training
Free (A $150 value)

Session I PC Hardware 3 Hrs 4 Mins outline
Session II Keyboarding 1 Hr 14 Mins outline
Session III Windows Basics (for XP, Vista, 7) 3 Hrs 10 Mins outline
Session IV Internet, Email, & Security 1 Hr 32 Mins outline

Multimedia Hands-on Labs and Exams

The Excel 2007 software is not required to use this training. This training includes built-in hands-on lab simulations for the student to perform real-world tasks in a simulated Excel 2007 environment during the lectures. Also included are pre-test questions to help assess the student's skill level. Throughout the training, the student is engaged with testing simulations including multiple choice, true and false, fill-in-the-blank questions, and multiple step software-based question simulations.

Excel 2007 Advanced Training Series

Part#: em-exc07a | Contents: 1 Year Online Access

Format

Reg: $149.00
Sale: $89.00
*No tax except for Maryland (USA) residents.

Online Training: Order now, start your training in 1 business day

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

Online based trainingMultimedia Online Training:
With online training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 1 GHz Processor (minimum), High-Speed Internet Connection, 512 MB RAM, Sound Card. Available Hard Disk 200 MB. 800x600 Minimum Screen Resolution (1024x768 or higher recommended). Browser: Internet Explorer 7, Firefox 3.6, Chrome 4.0, or Safari 4.0 or higher. Flash Player 10 or higher. Windows XP, Vista, 7, or MAC OS X 10.5 or higher.

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $149.00
Sale price: $89.00

Format

Product Details
  • Part#: em-exc07a
  • Contents: 1 Year Online Access
  • Online Training: Order now, start your training in 1 business day
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
System Requirements
  • 1 GHz Processor (minimum)
  • High-Speed Internet Connection (minimum bandwidth 350 KB/s)
  • 512 MB RAM
  • Sound Card
  • Available Hard Disk Space 200 MB
  • 800x600 Minimum Screen Resolution (1024x768 or higher recommended)
  • Internet Explorer 8, Firefox 3.6, Chrome 4.0, Safari 4.0, or Opera 10.5 or higher
  • Flash Player 10 or higher
  • Windows XP, Vista, 7, or MAC OS X 10.5 or higher
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Lesson highlights
Using filters
One-click and custom sorting
Creating Pivot Tables
Grouping and Filtering Data in Pivot Tables
Calculating with math functions
Using date and time functions
Using functions to adjust text
Making decisions with logical functions
Testing with information functions
Finding data with lookup functions
Calculating payments with financial functions
Finding relationships with statistical functions
Using What-If Analysis
Creating Analyses with Scenario Manager
Using Goal Seek
Setting VBA security
Understanding VBA Code
Writing Macros
Connecting to Data on a Web Page
Connecting to a Database
And much more...