Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 


Click here to order the CD!

 

  The resource to own
for training on Excel 2007

Excel 2007 Expert CD

Completely Visualized in Full Color


Visual training covering Excel 2007. This 1675 slide, self-paced training package is loaded with informative topics. Pick and choose from the training and learn at your pace on your own schedule.

Completely Visualized!


Learn Excel 2007 in full color. Every slide has rich illustrations to demonstrate the concept.

Self-Paced with Self-Checks!

Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschuuren's Excel Seminars. If you can't schedule Gerry at your office, then the next best thing is to buy this CD!

Click here to order the CD!

Look at everything you will learn!

You get three complete modules on the CD covering 1675 slides.

Module 1 - (550 slides)

1. General Techniques

  • Manipulating the Ribbon
  • Navigation
  • Moving and Copying
  • Fill Handle
  • Excel Options
2. Formulas
  • Formulas with Calculations
  • Formulas with Functions
  • Formula Hybrids
  • Relative vs. Absolute
  • Cell Names
  • Paste Special
3. A Matter of Looks
  • Cell Looks
  • Number Looks
  • Manipulating Text
  • Manipulating Dates
  • Conditional Formatting
  • Adding Comments
  • Error Displays
4. Reporting Data
  • Preview and Print
  • Printing Multiple Pages
  • Different Views
  • Printing Multiple Sheets
Module 2 - (550 slides)

1. Customizing

  • Outlines
  • Subtotals
  • Themes and Styles
  • Templates
2. Data Tables
  • Sorting Records
  • Filtering Records
  • Conditional Format
  • Data Validation
  • Database Functions
  • Lookup Functions
  • Table References
3. Wiring Data
  • Connected Sheets
  • Summary Sheets
  • 3-D Name References
  • Multiple Books
  • Exporting Data
  • Importing Data
  • Data Connections
4. Working with Others
  • Consolidation
  • Sharing Data
  • Protection and Security
  • SharePoint and Workspaces
Module 3 - (575 slides)

1. Specialized Functions

  • More Lookups
  • Date and Time Functions
  • Financial Functions
  • Math Functions
  • Statistical Functions
  • Array Functions
  • Custom Functions
2. What-If
  • Scenarios
  • Iterations
  • Solving Problems
  • Using Controls
3. Charts or Graphs
  • Types of Charts
  • Pie Charts
  • Column/Bar Charts
  • Line and XY Charts
  • Chart Templates
  • Chart Formulas
  • Trend Lines
4. Pivot Tables
  • Structure
  • Formulas
  • Grouping Data
  • Multiple Sources


Click here to order the CD!

An Incredible Bargain!
Compare this course to anything else. You could visit a training center at a local computer chain and pay $225 for a one-day course. Once that course is over, it is over. With the CD-ROM, you can play the course over and over, reviewing just the items that you need to review. Rather than be out of the office for an entire day, you can insert the CD and get training on a certain section on an as-needed basis. Pass the CD around your department and train everyone for one low price. With 1675 slides, this course runs circles around any other training.

About the Author
Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He is the author of many textbooks and has more than 20 years of experience in teaching at colleges and corporations. He holds master's degrees in Biology and in Philosophy, plus a Doctorate in the Philosophy of Science from Universities in Europe. He is author of Slide Your Way Through Excel VBA, Excel for Scientists, and Join the Excellers League CD-ROM.

Product Details
CD-ROM: 1675 Slides
ISBN 978-1-932802-31-3
System Requirements: PowerPoint 2007
Publisher: Holy Macro! Books;
Price: $99

If installing in Vista, read this note.


Click here to order the CD!

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.