Join the Excellers League

SKU: 34
Price:
$99.00

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

Requires Windows - not compatible with Macintosh.
For versions of Excel 2003 and earlier. For Excel 2007 training - Check out Excel 2007 Expert!

If installing in Vista, read this note.

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

Module 1 - Excel Essentials
The Excel Screen
  • Manipulating Toolbars
  • Navigation
  • Moving & Copying
  • Autofill Handle
  • General Settings
Formulas
  • Calculations vs. Functions
  • Entering Simple Calculations
  • Entering Basic Functions
  • Relative vs. Absolute
  • Cell Names
  • Paste Special
A Matter of Looks
  • Inside Looks
  • Outside Looks
  • Manipulating Text
  • Manipulating Dates
  • Conditional Formatting
  • Error Displays
  • Adding Comments
Reporting Data
  • Previewing/Printing a Workbook
  • What and Where to Print
  • Different View
  • Importing and Exporting

Module 2 - Excel Bonuses
Customizing Excel
  • Workbook Templates
  • Worksheet Templates
  • Customizing Toolbars
How to Wire Sheets
  • Validation between Worksheets
  • Formulas between Worksheets
  • Links between Books
Consolidating Several Sources
  • Consolidating Multiple Sources
  • Tracking Shared Workbooks
Charts
  • Chart Types
  • Pie Charts and Sub-Slices
  • Column Charts and Axes
  • Line and XY Charts
  • Default Charts
  • Chart Formulas
  • Trend Lines
Solving Equations
  • Using Charts
  • Goal Seek in Tables
  • Solver Tools
  • Scenarios

Module 3 - Excel Extras
Working with Outlines
  • Auto Outlines
  • Manual Outlines
  • Subtotal Outlines
Working with Databases
  • Sorting Records
  • Text Manipulation
  • Looking Up Records
  • Formatting Records Conditionally
  • Filtering Records
  • Database Functions
  • Records for Mailings
Pivot Tables
  • Pivot Table Layout
  • Pivot Table Options
  • Pivot Table Formulas
  • Grouping Data
  • Multiple Sources
Advanced Functions
  • Nested IF Functions
  • Search Functions
  • Financial Functions
  • Array Functions: Multiple
  • Array Functions: Single
  • Customized Functions

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:
Related Products
SKU: 138
$39.99
LiveLessons Power Excel 2003 DVD