Shop top categories that ship internationally
EUR 9.42 with 45 percent savings
List Price: EUR 17.06
No Import Charges & EUR 9.16 Shipping to Netherlands Details

Shipping & Fee Details

Price EUR 9.42
AmazonGlobal Shipping EUR 9.16
Estimated Import Charges EUR 0.00
Total EUR 18.58

EUR 9.16 delivery Monday, May 18
Or fastest delivery Tuesday, May 12
Only 1 left in stock - order soon.
EUR EUR 9.42 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 9.42
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Amazon
Ships from
Amazon
Sold by
RatCo
RatCo
Sold by
RatCo
Returns
FREE 30-day refund/replacement
FREE 30-day refund/replacement
Quick refund
Usually issued within 24 hours. See exceptions
FREE return
At least one free return option available.
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • Learn Excel 2016 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques

Follow the author

Get new release updates & improved recommendations
Mike Smart
Follow
Something went wrong. Please try your request again later.

Learn Excel 2016 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques Paperback – March 3, 2016

by Mike Smart (Author)
4.6 out of 5 stars (297)
{"desktop_buybox_group_1":[{"displayPrice":"EUR 9.42","priceAmount":9.42,"currencySymbol":"EUR","integerValue":"9","decimalSeparator":".","fractionalValue":"42","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"AN30DQ3Du65S62SjF%2BbDMeU4oX7Bs1SaQ8MYjoYlH9p77Hl%2FG754BSjC8MtphOY8Z7YmrJttNXcKr2etg5VBVGys9T2h1D4dAwMlyAbhpWbl3yoVf6rDpD%2B7eXLgMD%2BHyh%2Fo3MeWaW7f5VoNm4qxVHeFxyaiuupj4fr%2F%2Bll4Eo73u%2BYS6VULnmBuoRW2C18%2B","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}]}

Purchase options and add-ons

If you are an Excel 365 user (the subscription version of Excel) you should purchase our book: Learn Excel 365 Expert Skills with The Smart Method. This book is only intended for Excel 2016 users. Here are some of the reasons that you should choose this book to learn Excel 2016:
  • It teaches to true Expert level. This book teaches Excel to an extremely high level of competence that is very rarely found in the workplace (even amongst top professionals). At Expert level your skills will be greater and broader than almost all other Excel users and you will understand (and be able to effectively use) absolutely every Excel feature.
  • It separates OLAP skills from mainstream Excel skills. Excel 2016 now bundles several OLAP related "Power" tools that could be regarded as separate applications. OLAP and relational modeling skills are covered in three dedicated sessions at the end of the book (covering data modeling, OLAP Pivot Tables, 3D Maps and Get & Transform) rather than being jumbled up with regular Excel lessons.
  • It won't waste your time by teaching basic Excel 2016 skills that you already know. This isn't a beginner's book. If you are an absolute beginner you need our Excel 2016 Essential Skills book. By assuming that you are already able to use Excel's basic features, far more ground can be covered.
  • Instruction is logically structured into sessions and lessons. With single, self-contained lessons, this book caters for any self-learning or teaching period. Many learners have learned Excel by setting aside just a few minutes each day to complete a single lesson. Others have worked through the entire book in a single day.
  • Smart Method® books are #1 best sellers. Every paper printed Smart Method Excel book (and there have been ten of them starting with Excel 2007) has been an Amazon #1 best seller in its category. This provides you with the confidence that you are using a best-of-breed resource to learn Excel.
  • Learning success is guaranteed.For over fifteen years, Smart Method courses have been used by large corporations, government departments and the armed forces to train their employees. The book is ideal for teaching or self-learning because it been constantly refined (during hundreds of classroom courses) by observing which skills students find difficult to understand and then developing simpler and better ways of explaining them. This has made the book effective for students of all ages and abilities.
  • It is the book of choice for teachers. As well as catering for those wishing to learn Excel by self-study, Smart Method books have long been the preferred choice for Excel teachers as they are designed to teach Excel and not as reference books. Books follow best-practice adult teaching methodology with clearly defined objectives for each learning session and an exercise to confirm skills transfer.
  • It is written in plain English. Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way.
Companies who have taken Smart Method courses include:
The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, BMW, Time Warner, Virgin, Pokerstars, Unilever, Deutsche Bank, The BBC, British Petroleum, The Foreign and Commonwealth Office, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, HBOS, Transport For London, Scottish Power, BAE Systems, RBS, The British Museum, The National Gallery, Marks & Spencer, O2... and many, many others.
Read more
Previous slide of product details
  1. Print length
    516 pages
  2. Language
    English
  3. Publication date
    March 3, 2016
  4. Dimensions
    8.27 x 1.17 x 11.69 inches
  5. ISBN-10
    190925309X
  6. ISBN-13
    978-1909253094
Next slide of product details
The%20Amazon%20Book%20Review
The Amazon Book Review
Book recommendations, author interviews, editors' picks, and more. Read it now

Frequently bought together

This item: Learn Excel 2016 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques
EUR9.42
Get it as soon as Monday, May 18
Only 1 left in stock - order soon.
Sold by RatCo and ships from Amazon Fulfillment.
+
Business Intelligence: Practices, Technologies, and Management
EUR27.22
Get it as soon as Monday, May 18
Only 1 left in stock - order soon.
Sold by Moonson LLC and ships from Amazon Fulfillment.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
These items are shipped from and sold by different sellers.
Show details Hide details
Choose items to buy together.

Editorial Reviews

From the Author

If you haven't yet upgraded to Excel 2016 I strongly recommend that you do.  The new OLAP tools in the Excel 2016 version provide new and simpler solutions to many common Excel real-world business problems.  I know that if you also read and fully digest this book you'll be able to massively increase your productivity when working with the world's most powerful business tool.

From the Back Cover

About The Smart Method
  • The Smart Method develop and run IT courses.
  • We've trained many of the world's largest companies in England, Europe and America.
  • This book is used as the basis for The Smart Method's Excel 2016 Expert Skills course and is equally useful for self-learning.
  • Our unique teaching method is fun, absorbing and virtually 100% effective.
  • When you've tried The Smart Method you won't want to learn any other way!

Product details

  • Publisher ‏ : ‎ The Smart Method Ltd
  • Publication date ‏ : ‎ March 3, 2016
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 516 pages
  • ISBN-10 ‏ : ‎ 190925309X
  • ISBN-13 ‏ : ‎ 978-1909253094
  • Item Weight ‏ : ‎ 3.2 pounds
  • Dimensions ‏ : ‎ 8.27 x 1.17 x 11.69 inches
  • Best Sellers Rank: #3,245,000 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.6 out of 5 stars (297)

About the author

Follow authors to get new release updates, plus improved recommendations.
Mike Smart

Mike Smart

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

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.

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Shop the Store on Amazon ›
    Excel: The Easiest Way to Master Microsoft Excel in 7 Days. 200 Clear Illustrations and 100+ Exercises in This Step-by-Step Guide Designed for Absolute Newbie. Discover Formula, Charts and More
    Excel: The Easiest Way to Master Microsoft Excel in 7 Days. 200 Clear Illustrations and 100+ Exercises in This Step-by-Step Guide Designed for Absolute Newbie. Discover Formula, Charts and More
    4.34.3 out of 5 stars1,096
    EUR16.20
  2. Shop the Store on Amazon ›
    Responsive Web Design with HTML5 and CSS: Build future-proof responsive websites using the latest HTML5 and CSS techniques
    Responsive Web Design with HTML5 and CSS: Build future-proof responsive websites using the latest HTML5 and CSS techniques
    4.74.7 out of 5 stars26
    EUR29.00 List:EUR38.39
  3. Shop the Store on Amazon ›
    SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)
    SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)
    4.64.6 out of 5 stars1,845
    EUR18.14 List:EUR23.88
  4. Shop the Store on Amazon ›
    Windows 11 for Seniors Made Easy: Learn to Use Your PC with Confidence and Stay Independent. Step-by-Step Visual Instructions and No-Jargon to Make Technology Simple
    Windows 11 for Seniors Made Easy: Learn to Use Your PC with Confidence and Stay Independent. Step-by-Step Visual Instructions and No-Jargon to Make Technology Simple
    4.24.2 out of 5 stars89
    EUR15.33
  5. Shop the Store on Amazon ›
    The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
    The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
    4.44.4 out of 5 stars3,425
    EUR32.40 List:EUR52.03
Next page

Customer reviews

4.6 out of 5 stars
297 global ratings

Customers say

Customers find this Excel book to be a fantastic guide to advanced functions, praising its step-by-step approach and user-friendly exercises.
AI Generated from the text of customer reviews

Select to learn more

32 customers mention content, 32 positive, 0 negative
Customers find the book to be a fantastic guide to Excel's advanced functions and appreciate its step-by-step approach to learning.
...Overall a great book.Read more
Best book I've found on acquiring the skills for the Excel Expert exam. I've got several others, but this one is the only one I really need.Read more
This is a very thorough, detailed way of learning what you can do on the "Expert" level with Microsoft Excel....Read more
Well written, good helps and hints. Can be used to walk you through setting up databases and utilizing the powerful functions.Read more
5 customers mention ease of use, 5 positive, 0 negative
Customers find the book easy to follow, with user-friendly exercises, and one customer notes that each lesson is clearly laid out with click-by-click instructions.
...Each Lesson is short and easy to follow and are on two facing pages, which makes it easy to follow and complete....Read more
Fantastic guide to excels advanced functions. The exercises are very user friendly and will consistently improve you skills as you work your way...Read more
...No wasting time on basics, just straightforward, useful functions that I will be using every day. Thanks!Read more
...but rather references to previous lessons where repeated procedures are fully explained. Step by step, click by click instructions....Read more

Top reviews from the United States

  • Where_Am_I
    5.0 out of 5 stars This book will help you a lot if you use Excel on a daily basis.
    Reviewed in the United States on September 14, 2016
    Format: PaperbackVerified Purchase
    As far as "textbook" style books go this one is excellent. It takes a hands-on approach walking you through the steps of whatever feature the book is introducing. You'll never find yourself flipping the pages because you're wondering when it's going to get to the point.Itt explains so many useful things that will make your life easier. I'm only on section 2 and already I've learned a few things I wish I had known before. I'm embarrased about how much extra work I used to do because I didn't know any better. Some highlights for me were sorting by columns, printing only the currently visible data after a filter has been applied, filtering by multiple criteria at once, highlighting a range without having to scroll .all the way down or selecting everything on the worksheet, etc. Overall a great book.
    2 people found this helpful
    Helpful
     Report
  • Dan’s Opinion
    5.0 out of 5 stars EXCEL-lent upgrade to an already great book!
    Reviewed in the United States on March 8, 2016
    Format: PaperbackVerified Purchase
    This is an excellent upgrade to Essentials/Expert series Mike has been writing for years. His method is clear cut and every lesson is laid out with a mind towards progressing as you go through the book. He even rearranged the chapters a little, I assume his feedback dictated this. Some might ask why there is no Kindle version but I think that would greatly take away from the style of learning Mike has created for these books.

    Chapter eleven (Create Get and Transform Queries) is a new addition to the book for Excel 2016. I look forward to getting the team up and running with this feature before moving them onto more advanced books.

    The chapters are not described as of this writing so here you go:

    Session One: Table and ranges

    Session Two: Data integration, subtotals and integration

    Session Three: Advanced functions

    Session Four: Using names and the formula auditing tools

    Session Five: What if analysis and security

    Session Six: Working with hyperlinks, other applications and workgroups

    Session Seven: Forms and macros

    Session Eight: Pivot Tables

    Session Nine: Data Modeling, OLAP, and business intelligence

    Session Ten: 3D maps

    Session Eleven: Create get and transform queries
    37 people found this helpful
    Helpful
     Report
  • Bryan F Casey
    4.0 out of 5 stars Getting ahead with this book
    Reviewed in the United States on June 2, 2018
    Format: PaperbackVerified Purchase
    I consider myself in the top 10% of power users. I buy these books to find new cool tips. This book did not disappoint. Some real gems and good examples.
    3 people found this helpful
    Helpful
     Report
  • Michael Bruck
    5.0 out of 5 stars Who knew Excel could do so much? Highly recommended!
    Reviewed in the United States on June 26, 2018
    Format: PaperbackVerified Purchase
    I've been using Excel since it first became available. I've learned more from 4 hours with this book than I have in all of those previous years. Very clearly written and illustrated. Very few repetitions, but rather references to previous lessons where repeated procedures are fully explained. Step by step, click by click instructions. This is the closest I've ever come with a book to actually having a knowledgeable, patient instructor sitting next to me. I never knew that Excel was capable of the things Mike demonstrates in this book. For any prospective computer topic authors out there. read this book first to see how it's done. Very highly recommended.
    9 people found this helpful
    Helpful
     Report
  • Rob W
    5.0 out of 5 stars Great book on Excel and I thought I knew a ...
    Reviewed in the United States on July 28, 2016
    Format: PaperbackVerified Purchase
    Great book on Excel and I thought I knew a lot, but apparently nothing compared to Mike Smart. Each Lesson is short and easy to follow and are on two facing pages, which makes it easy to follow and complete. It treats the reader with respect by providing a clear instruction of what to do followed by how to do it, if you need it with optional material in the margin. It also avoids repetition. The material is divided into Lessons and Sessions, which makes it easy to take a break after each session and Mike explains why this is important for learning. The exercises are easy to follow and build on existing Excel skills.
    17 people found this helpful
    Helpful
     Report
  • Alanna Caribbean
    5.0 out of 5 stars Love it - over and over
    Reviewed in the United States on May 22, 2019
    Format: PaperbackVerified Purchase
    I use this book since 2015 for an Advanced Excel course and recommend it to everyone wherever I teach Excel.
    (1) The price is unmatched - an academic book will cost a LOT more.
    (2) The author provides access to all the practice files without access codes/cards.
    (3) The short-lesson format is great. Most every lesson takes two pages. Two pages - and you learned something new!
    Want to go on? Next two pages. Don't have a lot of time? In 15 minutes you accomplished something.
    THE BEST BOOK!
    2 people found this helpful
    Helpful
     Report
  • Customer
    4.0 out of 5 stars Nice lesson presentations
    Reviewed in the United States on February 24, 2017
    Format: PaperbackVerified Purchase
    Excelente for self teaching! Nice lesson presentations! Iit's not overwhelming! Interesting facts along side and windows keep the reader hooked with the program. And in my opinion, makes me trust even more in the importance of managing the program. The author is very enthusiastic about the program but at the same time, tells you the pros and cons in few themes...
    5 people found this helpful
    Helpful
     Report
  • SoCal Mom
    5.0 out of 5 stars Mind blown...
    Reviewed in the United States on November 9, 2018
    Format: PaperbackVerified Purchase
    I have been using Excel for years, and considered myself proficient. I am learning something new in every single lesson. No wasting time on basics, just straightforward, useful functions that I will be using every day. Thanks!
    One person found this helpful
    Helpful
     Report

Top reviews from other countries

  • Hazelwood
    5.0 out of 5 stars Well worth the money - a must have for regular business Excel users!
    Reviewed in the United Kingdom on July 3, 2018
    Format: PaperbackVerified Purchase
    This book is an invaluable aid to anyone who has to use Excel on a regular basis. I was totally blown away by the new BI materials (Data Model and OLAP, 3D Maps, and Get & Transform. These lessons have opened up an whole new world to me that I never knew existed in Excel 2016. The book is worth buying just for these materials alone as they make otherwise seemingly difficult subject matter easily understandable and within the grasp of any savvy Excel user. Indeed, the whole book is written in an accessible style that gets to the core skills and understanding that you need in order to be a very proficient (if not expert) Excel User. In short, I am delighted with this purchase.
    Report
  • Marvin H. Knodel
    5.0 out of 5 stars A Fantastic Book of Advanced Practical Skills
    Reviewed in Canada on August 11, 2021
    Format: PaperbackVerified Purchase
    This is a fantastic book! There are so many things I had not even dreamed of that I could do with Excel 2016. I had no idea as to how many different dialog boxes there were for doing different things and how to find and open them. The best thing about this book is that there is a website connected to this book where you can download countless practice problems.
    Report
  • Amazon Customer
    5.0 out of 5 stars Most useful learning tool I have used for excel.
    Reviewed in Australia on November 7, 2018
    Format: PaperbackVerified Purchase
    I love this series of learning guides for excel. You can proceed start to end of the book to learn it all or pick and choose the function you need to brush up on.
    I now buy these as resources for my staff as well. Awesome
    Report
  • Sharon Edwards
    5.0 out of 5 stars Best Excel instruction
    Reviewed in Canada on August 16, 2019
    Format: PaperbackVerified Purchase
    This is one of the best manuals for instruction that I have ever had the pleasure of using.
    Would recommend anything Mike Smart has.
    Report
  • Amazon Customer
    5.0 out of 5 stars Fabulous book for even the fairly proficient excel user
    Reviewed in the United Kingdom on December 30, 2017
    Format: PaperbackVerified Purchase
    I consider myself quite proficient in excel having taught it at college level for advanced users for several years and as a highly successful data migration specialist . My intention was to get up to speed with the latest and greatest additional features ot excel 2016 in preparation for training with power BI and DAX. I have been properly humbled! What an absolutely awesome book! Every lesson has some hidden gem with me exclaiming "wow" or "awesome". This will certainly transform some of my work routines to be even more efficient. Highly impressed!! LOVE the step by steps and the unit tests. Just fab!!
    Report
See more reviews