Learning from books isn't for everybody. If you've tried to learn Excel from a book and given up you'll love this video course.
This isn't a beginner's course. If you are an absolute beginner you need to first complete the Essential Skills course in this series. When you've finished this video you'll have joined that tiny elite of power users who can do absolutely everything with Excel.
While the DVD has been designed as a stand-alone product, it is also available as a 356 page low-cost book (of the same name). Many learners find it useful to use the two together. The book also provides a useful indexed reference to keep by your computer once you've learned Excel.
The video is for Excel 2007 users who:
• Are already comfortable with Excel 2007's basic features
• Want to learn to use all of Excel 2007's more powerful features
• Teachers who wish to run advanced Excel 2007 training course
Amongst other things you'll learn how to:
• Master Excel 2007's new dynamic tables
• Enforce complex business rules using function-driven custom validations
• Perform What-If analysis to model and compare business scenarios
• Use advanced functions to solve real-world business problems
• Eliminate errors using Excel's formula auditing tools
• Create intuitive user interfaces using form controls
• Use Excel's three different sharing methods for efficient teamwork
• Record macros and then execute them from button controls
• Understand and use all of Excel's security features
• Design advanced Pivot Tables and Pivot Charts
• Create and use dynamic and table-based range names
