or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £4.04 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Learn Excel 2010 Expert Skills with the Smart Method [Paperback]

Mike Smart
4.8 out of 5 stars  See all reviews (17 customer reviews)
RRP: £15.99
Price: £12.99 & FREE Delivery in the UK. Details
You Save: £3.00 (19%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 23 Sep.? Choose Express delivery at checkout. Details
Trade In this Item for up to £4.04
Trade in Learn Excel 2010 Expert Skills with the Smart Method for an Amazon Gift Card of up to £4.04, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

19 Oct 2011

This Excel 2010 book is for users who want to upgrade their basic Excel 2010 skills to true expert level. It will teach you to master all of the Excel 2010 advanced features. If you are an absolute beginner you need our Excel 2010 Essential Skills book.

The book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to master advanced Excel 2010 features. Here’s just four of the many ways in which the book is unique:

  • This book won’t waste your time by teaching basic Excel 2010 skills that you already know. All of that material is covered already in our beginner’s Excel 2010 Essential Skills book. By assuming that you are already able to use the Excel 2010 basic features, far more ground can be covered.
  • Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
  • Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
  • Each lesson has a sample file that models a real-world business problem. You’ll immediately appreciate the value and relevance of each skill you learn.

Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way. No matter what your background is, this book will enable you to master Excel 2010's most advanced features.

Amongst other things you'll learn how to:

  • Visually filter data using Excel 2010's new Slicers
  • Master dynamic tables and structured table references
  • 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 advanced formula auditing tools
  • Create intuitive user interfaces using form controls
  • Use Excel 2010's new ability to completely custom-design Ribbon tabs
  • 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

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.


Frequently Bought Together

Learn Excel 2010 Expert Skills with the Smart Method + Learn Excel 2010 Essential Skills with the Smart Method + Excel 2010 Bible
Price For All Three: £43.37

Buy the selected items together


Product details

  • Paperback: 376 pages
  • Publisher: The Smart Method Ltd (19 Oct 2011)
  • Language: English
  • ISBN-10: 0955459982
  • ISBN-13: 978-0955459986
  • Product Dimensions: 29.7 x 21 x 2 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Bestsellers Rank: 61,769 in Books (See Top 100 in Books)

More About the Author

Mike Smart is the founder of The Smart Method Ltd who develop and run IT courses. Mike has trained delegates from many of the world's largest companies in England, Europe and America (see back cover of book for more details).

Mike's unique teaching method is fun, absorbing and virtually 100% effective.

Product Description

About the Author

Mike Smart is the founder of The Smart Method Ltd who develop and run IT courses. Mike has trained delegates from many of the world's largest companies in England, Europe and America (see back cover of book for more details). Mike's unique teaching method is fun, absorbing and virtually 100% effective.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars The BEST Excel book for learning 13 Feb 2013
By Kidz
Format:Paperback|Verified Purchase
I first bought the Essential skills book. At the time I had no idea how to use Excel. The book was brilliant. I found it so easy to use and so informative that I purchased this book not long after, and I am certainly not disappointed. This book is just as EXCELLENT as the last. So simple to use, with easy to follow instructions, very clear, and there is also a website where you can follow some of the lessons online - it really is easy! They think I'm a pro at work!

I only wish I could find a Word book which is as good as this one. I have had to send one back as it didn't match the quality of this one - what can I say, when you've had the best nothing else is good enough.

The Excel Smart Method books are in my opinion the best, and learning from the book is great fun! Definitely recommended.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars A good Excel book 19 July 2014
Format:Paperback|Verified Purchase
I definitely learnt new things from this book. Like anything - it will be a worthwhile purchase if you actually start incorporating things you have learnt into your day to day work. Those things I have are second nature now, but there are useful functions in here that I haven't made use of and would not be able to use without spending some time reviewing again.

One thing I liked was the authors comments on vba - he stated in his experience most of problems people approached him for that they claimed needed vba could actually be handled easily by the normal Excel functions he teaches in this book.

I have borne that in mind since reading, and it seems like good advice. I have discovered one possible exception - trying to make dynamic forms where users input information which in turn drives the subsequent choices they are presented with. I have made use of the excellent data validation section here, but have found out that people can skirt the rules by inputting data, making a subsequent choice, and then removing the original choice. Validation can stop people entering data into a cell, but it is harder to control it once it is already in there.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Brilliant! 10 July 2013
Format:Paperback|Verified Purchase
I really like this book! It goes straight to the point without having to wade through page after page of introductory material. Very clear examples with downloadable file examples to work with. I have been using Excel for many years but found so much new material in this book. An excellent purchase for anyone who wants to literally excel with Excel!
Comment | 
Was this review helpful to you?
Format:Paperback|Verified Purchase
This is a really excellent way to improve your Excel skills. I had been a user of the previous versions of Excel and always struggled with the new layouts, but now am fine with them. This book provides practical exercises with actual excel files that you can download so that you learn by doing which is always thebest way. Cannot praise this highly enough.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Taking the lessons now 16 May 2014
By J Emens
Format:Paperback|Verified Purchase
I am only thru 7 lessons and have already picked up a few tips. Easy to download the files and clear instructions. It will really help me in my work.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Very good book with online support also 27 Feb 2014
By Liz H
Format:Paperback|Verified Purchase
Very impressed with this book - good value for money, very clear and easy to use - online support also really helps
Comment | 
Was this review helpful to you?
5.0 out of 5 stars the best 19 Dec 2013
Format:Paperback|Verified Purchase
very good easy steps to learn . enough examples to practise. i was just a begineer on excel before i got these book but now expert
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excellent book, so easy to follow. 19 Dec 2013
Format:Paperback|Verified Purchase
From all the various books and courses I have used to learn excel, this book is the best, highly recommend
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback