Learn Excel 2007 Expert Skills With The Smart Method

Product Description

This book is for users who are not absolute Excel beginners but want to enhance their basic skills to true expert level by mastering all of the advanced features provided by the worlds most powerful business tool. If you are an absolute beginner you should first complete our Essential Skills book. The course was developed for classroom instruction by The Smart Method who have trained a vast number of business people from all ability levels & backgrounds to become advanced Excel users. Years of experience from classroom courses was used to perfect the teaching methods & presentational techniques used in the book. As a result you will master Excels most advanced features in a fraction of the time needed when learning from conventional text books. Unlike any other Excel book each lesson is presented upon two facing A4 pages & skills are taught in the context of actual business problems. The course is carefully structured into sessions & lessons making it ideal for schools colleges universities & IT training companies to use as courseware. The unique presentational style means that you can learn only the skills you need by absorbing hands-on involvement rather than boring theory. A huge number of sample files are used (via download from the books dedicated web site) that come from the real world of business. This means that your skills are instantly useable to streamline your work. Amongst other things youll learn how to Master Excel 2007s new dynamic tables enforce complex business rules using function-driven custom validations perform What-If analysis to model & compare business scenarios use advanced functions eliminate errors using Excels advanced formula auditing tools use Excels three different sharing methods for efficient teamwork record macros & then execute them from button controls understand & use all of Excels security features design advanced Pivot Tables & Pivot Charts create & use dynamic & table-based range names create intuitive user interfaces using form controls & even publish a complete web site from a workbook using only Excel skills. Companies who have taken Smart Method courses include: AOL Time Warner Daimler Chrysler HSBC Barclays American Express Allied Irish Banks Imperial Tobacco Motorola Volvo The BBC British Petroleum The Foreign & Commonwealth Office Unilever The Institute of Chartered Accountants The Ministry of Defence The United States Army Keele University Deutsche Bank HBOS Transport For London The Performing Rights Society Scottish Power The Office of the Parliamentary Ombudsman BAE Systems RBS Marks & Spencer Virgin O2 BMW...and many many others.