Excel 2007 Expert

April 2008

Learn the tricks and solve the mysteries of Excel's latest version

Buy Now »

by Dr. Gerard M. Verschuuren

category: Spreadsheets

covers: Excel 2007

Product Details

1477 Slides
Publisher: Holy Macro! Books
ISBN: 978-1-9328-0231-3

Finally - visual training covering every aspect of Excel. This 1675 slide, self-paced training package is loaded with informative topics about Excel 2007. Pick and choose from the five-days of training and learn at your pace on your own schedule.

Requires Windows and PowerPoint 2007 - not compatible with Macintosh.

You get three complete modules on the CD covering 1477 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

Excel 2007 Expert

Table of Contents

Where to Buy