| Synopsis: |
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 world's 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 and backgrounds, to become advanced Excel users. Years of experience from classroom courses was used to perfect the teaching methods, and presentational techniques, used in the book. As a result, you will master Excel's 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 and skills are taught in the context of actual business problems. The course is carefully structured into sessions and lessons making it ideal for schools, colleges, universities and IT training companies to use as courseware.The unique presentational style allows you to 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 book's 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 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, eliminate errors using Excel's advanced formula auditing tools, 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, create intuitive user interfaces using form controls, and 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 and 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. |