Learn Excel 2007 Expert Skills with The Smart Method: Coureware Tutorial teaching Advanced Techniques (DVD-ROM Video Course)

pLearning 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. /ppThis 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. /ppWhile 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./ppbThe video is for Excel 2007 users who: /b/p• Are already comfortable with Excel 2007's basic features br /• Want to learn to use all of Excel 2007's more powerful features br /• Teachers who wish to run advanced Excel 2007 training course br /pbAmongst other things you'll learn how to:/b/p• Master Excel 2007's new dynamic tables br /• Enforce complex business rules using function-driven custom validations br /• Perform What-If analysis to model and compare business scenarios br /• Use advanced functions to solve real-world business problems br /• Eliminate errors using Excel's formula auditing tools br /• Create intuitive user interfaces using form controls br /• Use Excel's three different sharing methods for efficient teamwork br /• Record macros and then execute them from button controls br /• Understand and use all of Excel's security features br /• Design advanced Pivot Tables and Pivot Charts br /• Create and use dynamic and table-based range names