Cart Contents
Categories
- New Products (5)
- Specials (22)
- Featured (5)
- Bestsellers (5)
- CDs (12)
- Books (24)
- Bundles (18)
- Utilities (9)
- Misc (2)
- DVDs (6)
- eBooks (21)
Bestsellers
VBA and Macros for Microsoft Excel
2500 Excel VBA Examples
Learn Excel from Mr Excel E-Book
Guerilla Data Analysis
Slide Your Way Through Excel VBA
Guerilla Data Analysis E-Book
Join the Excellers League
Complete PDF - Learn Excel
Speedometer Chart Creator
Pivot Table Data Crunching
Sale Item
Currency
Product Details
|
Join the Excellers League
SKU: 34
|
Overview
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!
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
Customizing Excel
Working with Outlines
The Excel Screen
- Manipulating Toolbars
- Navigation
- Moving & Copying
- Autofill Handle
- General Settings
- Calculations vs. Functions
- Entering Simple Calculations
- Entering Basic Functions
- Relative vs. Absolute
- Cell Names
- Paste Special
- Inside Looks
- Outside Looks
- Manipulating Text
- Manipulating Dates
- Conditional Formatting
- Error Displays
- Adding Comments
- Previewing/Printing a Workbook
- What and Where to Print
- Different View
- Importing and Exporting
Customizing Excel
- Workbook Templates
- Worksheet Templates
- Customizing Toolbars
- Validation between Worksheets
- Formulas between Worksheets
- Links between Books
- Consolidating Multiple Sources
- Tracking Shared Workbooks
- Chart Types
- Pie Charts and Sub-Slices
- Column Charts and Axes
- Line and XY Charts
- Default Charts
- Chart Formulas
- Trend Lines
- Using Charts
- Goal Seek in Tables
- Solver Tools
- Scenarios
Working with Outlines
- Auto Outlines
- Manual Outlines
- Subtotal Outlines
- Sorting Records
- Text Manipulation
- Looking Up Records
- Formatting Records Conditionally
- Filtering Records
- Database Functions
- Records for Mailings
- Pivot Table Layout
- Pivot Table Options
- Pivot Table Formulas
- Grouping Data
- Multiple Sources
- Nested IF Functions
- Search Functions
- Financial Functions
- Array Functions: Multiple
- Array Functions: Single
- Customized Functions
Related Products
SKU: 138
|
|
 |
|
Reviews
Add Your ReviewCurrently there are no reviews for this product. Share your opinion with others, be the first to write a review.
Tell a Friend
