Home - Software
Learn Excel 2007 Expert Skills with The Smart Method: Coureware Tutorial teaching Advanced Techniques (DVD-ROM Video Course)
Price: $29.99
& 2-Day * Free Nationwide Shipping! (* details)
Availability: Usually ship in 24 hours if sold by Amazon.com
Product Details
| Binding: | DVD-ROM |
|---|---|
| EAN: | 9780955459955 |
| Label: | The Smart Method Ltd |
| Feature: | Run Time 13 Hours 8 Sessions 144 Videos |
| Publisher: | The Smart Method Ltd |
| Studio: | The Smart Method Ltd |
Editorial Reviews
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
Customer Reviews
Rosemarie Wood @ 2011-08-21 Its Great.
Rose Wood
Perky @ 2011-07-06 Excel Expert Skills
Now having worked through some of the exercises I have found my basic knowledge lacking in some areas. Therefore I have ordered the Essential Skills series so that I can fill in the knowledge gaps and better understand the explanations. I thought that as I had worked with Excel for years I would be able to progress to the Expert Skills programme without working through the Essential Skills but I needed a better base knowledge to progress in a more structured way.
I recommend that if you are a regular user of Excel and want to grow your knowledge then start with the Essential Skills first and enjoy the Expert Skills programm as a follow on.
M. Hyght "mhyght" @ 2011-05-23 Excellent!! Worth every penny!!
Aside from being very thorough and professional, Mr. Smart has included exercises (with answers) in PDF format to accompany each of the major sessions. That makes the entire process stick! You do the tasks as he does, while watching and listening, then you close the tutorial and try it on your own with new scenarios. There's no better way to learn in a short time.
The only way Mike Smart's instructional DVD's could be better is if there were more of them.
Mike, PLEASE tackle Microsoft Access the same way! I'll be the first to order, and I'll tell all my co-workers!
:-)
jim @ 2011-02-17 Learn Excel 2007 Expert
Answered all questions quickly.
Best training video or DVD that I have tried!!!!
Create your own review