Cart Contents
Categories
- New Products (16)
- Specials (50)
- Featured (29)
- Bestsellers (5)
- CDs (12)
- Books (42)
- Bundles (29)
- Utilities (10)
- Misc (4)
- DVDs (8)
- eBooks (38)
- Help With Downloads (1)
Bestsellers
VBA and Macros for Microsoft Excel
2500 Excel VBA Examples
Guerilla Data Analysis
Learn Excel from Mr Excel E-Book
DAX FORMULAS for Power Pivot: The Excel Pro's Guid...
Guerilla Data Analysis E-Book
Learn Excel 2007 through Excel 2010 from MrExcel -...
DAX FORMULAS for Power Pivot: The Excel Pro's Guid...
Excel For The CFO -Excel 2010- by P.K. Hari [ePubl...
VLOOKUP Awesome Quick - by Bill 'MrExcel' Jelen
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.




