Learn Excel 2007 Essential Skills with The Smart Method: Courseware Tutorial for Self-instruction to Beginner and Intermediate Level - Softcover

Smart, Mike

Softcover

ISBN 10: 0955459915 ISBN 13: 9780955459917

Publisher: The Smart Method Ltd, 2008

Synopsis

Is this the right book for you?

This 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 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.

About this title

About the Author

Mike Smart is the founder and CEO of The Smart Method^;.  In Mike's long career as an IT consultant, Mike specified, designed and delivered IT solutions for large corporations all over the world.  In 2002 Mike decided to specialize in IT training and founded The Smart Method^;.

Mike has personally taught classroom Excel courses to delegates from many of the world's largest companies in England, Europe and America. Mike has run courses for bankers, engineers, accountants, teachers, broadcasters, retailers, insurance brokers, aircraft manufacturers, government departments, on-line gaming companies, telecom workers, oil workers, car manufacturers, power companies... and for many other professions. This has given him a unique insight into the diverse ways in which Excel is used by both large and small businesses.

By carefully observing the areas that students find the most difficult to understand, Mike has constantly refined his Smart Method teaching technique over a period of more than ten years.

In 2008 Mike realized that he could only ever teach a few thousand students in his classroom courses but could help millions of students by producing his Excel courses in book form. His first Excel books (covering Excel 2007) rapidly became best sellers and his books have topped best seller lists ever since.

In his spare time, Mike enjoys playing jazz piano, riding his motorbike and sliding down snowy mountains on two wooden sticks.

From the Back Cover

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.

Edition details

• Publisher: The Smart Method Ltd
• Publication date: 2008
• Language: English
• ISBN 10: 0955459915
• ISBN 13: 9780955459917
• Binding: Paperback
• Number of pages: 300