Is this the right Excel 2007 book for you?
This Excel 2007 book was written for one purpose: to provide a 100% effective way to teach Excel 2007 skills to new learners with little or no past exposure to Excel. Excel 2007 is a huge application with thousands of features. It could take months, or even years of study to master every one of them. But there's some really good news!
The big secret is that office workers who use Excel 2007 every day for a living only use a small part of Excel's huge feature set. The great news is that, in general, they tend to all use the same set of features. This book makes it easy for absolutely anybody to very rapidly learn Excel 2007 to a standard that will greatly impress most employers - because it will focus your time and energy upon learning the right features.
Mike Smart has personally taught classroom courses, all over the world, for many of the world's largest companies. Mike has run courses for bankers, engineers, accountants, teachers, broadcasters, retailers, insurance brokers, telecom workers, offshore oil workers, power companies... and for many other professions. (Click on the back book cover above to see some of the companies Mike has helped). He has a unique insight into exactly which Excel features you need to know to describe yourself as a competent Excel user. This book will teach you all of those skills.
In this Essential Skills book you'll learn to create beautiful and functional Excel workbooks that will really make you stand out above your co-workers. Click on the front book cover above to see an example of an impressive worksheet that would be beyond the ability of most Excel users. After completing this course you'll be able to create worksheets that are just as professional in a matter of moments. Use Amazon's Look Inside feature to examine the book's table of contents. You'll have all of the Excel skills listed there when you have finished this book.
Absolutely anybody can master Excel using this book
By focusing only on the skills that are commonly used in the workplace it becomes possible to teach these carefully selected, most important features in depth, and in a simple way that absolutely anybody can understand.
And you'll learn all of those skills in only 300 pages without overwhelming you with hundreds of pages of information about Excel's less used features.
Mike's Excel 2007 Expert Skills book comprehensively teaches the rarer Excel skills that less than 10% of Excel users typically master (and many office workers will not have a need for). See the Excel 2007 Expert Skills book description here on Amazon for more information about this follow-on book.
Not just a book but a professional course
It isn't possible to write a course in the same way you would write a novel. Pages cannot all flow in an endless jumble of information (though they do in many other Excel books). To teach (and to learn) effectively every teacher knows that it is necessary to carefully plan a series of lessons. Each lesson must teach a single carefully defined objective.
This book was designed from the outset as a learning resource and is the same book that Mike uses to teach his classroom courses. It is also the text book of choice for schools, colleges, universities, corporations and government departments to teach their students and employees excellent Excel skills.
The unique layout of this book makes it perfect for both self-instruction and teaching. The book presents each self-contained lesson on two facing pages. Try Amazon's Look Inside feature above to look at a typical lesson. You'll quickly appreciate the immense value of this approach.
Who is this book for?
This book provides the fastest possible route to mastering Excel 2007.
This book is for Excel 2007 users who are:
- Absolute beginners needing to quickly acquire Excel 2007 skills
- Moving to Excel 2007 from an earlier version
- Self-taught but want to learn the correct professional techniques
- Teachers who wish to run Excel 2007 training courses
Why this book is different
At The Smart Method we've trained a vast number of people, from all ability levels and backgrounds, to be thoroughly competent with Excel in a single day. Even if they have never seen Excel before!
We've used years of experience from our classroom courses to perfect our teaching method. This book uses the same teaching techniques to enable you to master Excel in a fraction of the time needed when learning from conventional text books.
This is the book we use to teach our Excel 2007 Essential Skills course. The content of the book has been carefully chosen to cover what it is reasonably possible to learn in one, intensive day's course. All of the most important skills needed in the workplace are covered.
What you will learn
Amongst other things you will learn how to:
- Master Excel 2007's new Fluent User Interface and Ribbon
- Understand the new Excel 2007 file formats and when to use them
- Create your own formulas with the new Formula AutoComplete feature
- Create cross worksheet formulas
- Understand absolute, relative and mixed cell references
- Create stunning, professional, presentation-quality charts
- Use the new Themes feature to create visually excellent worksheets
- Use Excel 2007's new Trend Line feature
- Bring your data alive with Excel 2007's stunning Visualizations
- Create custom conditional formatting rules with the new Rules Manager
- Add a professional sheen to your work with 3-D Elements
- Understand and work with three-dimensional worksheet groups
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, 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.
