Excel 2007 Expert

SKU: 111
Price:
$99.00

Qty: - +
   - OR -   
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.

If installing in Vista, read this note.

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
Screenshots and more information is available here.
Currently there are no reviews for this product. Share your opinion with others, be the first to write a review.

Add Your Review


Your Name:
Email Address:
Review:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Verification:
Your Name:
Your Email:
Friends Name:
Friends Email:
Message:
Verification: