Excel 2007 Expert


April 2008

Excel 2007 Expert

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

Bill Jelen, MrExcel

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

Where to Buy

MrExcel Bookstore

CD-ROM from MrExcel.