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
| View Larger Image |
Excel 2007 Expert
SKU: 111
|
Overview
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
1. Customizing
1. Specialized Functions
1. General Techniques
- Manipulating the Ribbon
- Navigation
- Moving and Copying
- Fill Handle
- Excel Options
- Formulas with Calculations
- Formulas with Functions
- Formula Hybrids
- Relative vs. Absolute
- Cell Names
- Paste Special
- Cell Looks
- Number Looks
- Manipulating Text
- Manipulating Dates
- Conditional Formatting
- Adding Comments
- Error Displays
- Preview and Print
- Printing Multiple Pages
- Different Views
- Printing Multiple Sheets
1. Customizing
- Outlines
- Subtotals
- Themes and Styles
- Templates
- Sorting Records
- Filtering Records
- Conditional Format
- Data Validation
- Database Functions
- Lookup Functions
- Table References
- Connected Sheets
- Summary Sheets
- 3-D Name References
- Multiple Books
- Exporting Data
- Importing Data
- Data Connections
- Consolidation
- Sharing Data
- Protection and Security
- SharePoint and Workspaces
1. Specialized Functions
- More Lookups
- Date and Time Functions
- Financial Functions
- Math Functions
- Statistical Functions
- Array Functions
- Custom Functions
- Scenarios
- Iterations
- Solving Problems
- Using Controls
- Types of Charts
- Pie Charts
- Column/Bar Charts
- Line and XY Charts
- Chart Templates
- Chart Formulas
- Trend Lines
- Structure
- Formulas
- Grouping Data
- Multiple Sources
Reviews
Add Your ReviewCurrently there are no reviews for this product. Share your opinion with others, be the first to write a review.




