Buy new:
$69.82
FREE delivery: Friday, April 26
Ships from: Amazon
Sold by: Ibook USA
List Price: $79.99 Details

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Save: $10.17 (13%)
FREE Returns
FREE delivery Friday, April 26. Order within 12 hrs 59 mins
Only 3 left in stock - order soon.
$$69.82 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$69.82
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Ships from
Amazon
Sold by
Ibook USA
Sold by
Ibook USA
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
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
Payment
Secure transaction
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
Used: Like New | Details
Sold by THE MEDIA MONKEY
Fulfilled by Amazon
Condition: Used: Like New
Comment: This item is at an Amazon warehouse waiting to be shipped to you by Amazon. We do this to provide the best shipping experience. In the very unlikely event of something goes wrong with your order, Amazon will provide service and process a return, if necessary.

Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.

If you're a seller, Fulfillment by Amazon can help you grow your business. Learn more about the program.

Access codes and supplements are not guaranteed with used items.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
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

Follow the author

Jordan Goldmeier
Follow
Something went wrong. Please try your request again later.

Advanced Excel Essentials 1st ed. Edition

by Jordan Goldmeier (Author)
4.3 4.3 out of 5 stars 38 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$69.82","priceAmount":69.82,"currencySymbol":"$","integerValue":"69","decimalSeparator":".","fractionalValue":"82","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"9sbVdPBmnzLOq7w0SoJIA5Wt1AAl27rF6GrXO50zzxC0Y%2Fk2B48p2a2He4VQxyAol4ESoJ2EJLyEzcfAaXMhaRVbZ4m7VAgMmEFwMdbnFss9kduwvhsgG%2FUkMLmQbtHi%2FRboQZZdXglMWNk3huY0%2BtLx4annmAM4ZxnTWTNoBiPZTxsK97ag3onAirePX%2B2Q","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$61.79","priceAmount":61.79,"currencySymbol":"$","integerValue":"61","decimalSeparator":".","fractionalValue":"79","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"9sbVdPBmnzLOq7w0SoJIA5Wt1AAl27rFiuHF2OxKzMWAU2ti2wN3IBKdzH7qU67%2F1qqTNhOee3ak3bOS8yQPOk7hhEm7be%2Fx%2FEyJvQOoVf0JSuvgT9EyuCWOZ2ezi0BQS5R19L%2FZ9WNogp0wyC553ux%2FXtFewgvbylXomiYZwz5zp4lwNaQ6Sg%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Advanced Excel Essentials is the only book for the experienced Excel developer. This book starts from the assumption that you are well-versed in Excel--and builds on your skills to take them to the advanced level. It will show you the building blocks of advanced development and then take you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, and engineer--this is the book you've been waiting for!
* Covers advanced formula topics like array formulas and Boolean logic
* Shows you how to build correctly with hands-on examples
* Provides insight into better code and formulas development
* Builds on a foundation of industry best practices and the author's hard won real-world experience
What you'll learn
  • How to build better, faster, and leaner spreadsheets that will make you a force to be reckoned with, in your organization
  • How to write optimized code and formulas that are easily understood even by less experienced users
  • Learn how to turn a spreadsheet into a powerhouse application that rivals commercial software
  • Learn the tools and techniques for optimal layout, data storage, and advanced analytics
Who this book is for  Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications

 Table of Contents1. Introduction
2. Visual Basic for Applications for Excel, a Refresher
3. Introducing Formula Concepts
4. Advanced Formula Concepts
5. Introduction to Controls
6. Getting Input from Users
7. Storage Patterns for User Input
8. Building for Sensitivity Analysis
9. Perfecting the Presentation
Previous page
  1. ISBN-10
    1484207351
  2. ISBN-13
    978-1484207352
  3. Edition
    1st ed.
  4. Publisher
    Apress
  5. Publication date
    November 5, 2014
  6. Language
    English
  7. Dimensions
    7.01 x 0.49 x 10 inches
  8. Print length
    229 pages
  9. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Frequently bought together

Advanced Excel Essentials
$69.82
Get it as soon as Friday, Apr 26
Only 3 left in stock - order soon.
Sold by Ibook USA and ships from Amazon Fulfillment.
+
Dashboards for Excel
$56.90
Get it as soon as Friday, Apr 26
In Stock
Ships from and sold by Amazon.com.
+
Becoming a Data Head: How to Think, Speak, and Understand Data Science, Statistics, and Machine Learning
$24.49
Get it as soon as Friday, Apr 26
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Product details

  • Publisher ‏ : ‎ Apress; 1st ed. edition (November 5, 2014)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 229 pages
  • ISBN-10 ‏ : ‎ 1484207351
  • ISBN-13 ‏ : ‎ 978-1484207352
  • Item Weight ‏ : ‎ 13.4 ounces
  • Dimensions ‏ : ‎ 7.01 x 0.49 x 10 inches
  • Customer Reviews:
    4.3 4.3 out of 5 stars 38 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Jordan Goldmeier

Jordan Goldmeier

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

Contact: +1 614-397-8832, jordan@anarchydata.com

Jordan Goldmeier is an internationally recognized data scientist and data visualization expert, author, speaker, and CEO. His clients include H&M, Principal Financial, and Stony Brook University.

Customer reviews

4.3 out of 5 stars
4.3 out of 5
38 global ratings
Concise, clear delivery of advanced Excel concepts
5 Stars
Concise, clear delivery of advanced Excel concepts
Excellent book because it's concise and delivers on the promise of advanced essentials. This is for the person who know IF, CHOOSE and VLOOKUP but, what about that double-negative thing that shows up in formulas? And are there more appropriate alternatives to nesting a bunch of IF statements?Advanced Excel Essentials will help get you past intermediate functionality. It is also focused on how you can think better about getting the most from Excel.
Hide
Thank you for your feedback
Sorry, there was an error
Sorry we couldn't load the review

Top reviews from the United States

Excel Campus
5.0 out of 5 stars Think Outside of the Cell
Reviewed in the United States on December 14, 2014
Verified Purchase
This book will change how you approach building models and applications in Excel. Jordan (the author) forces you to think outside the box, and makes some strong arguments against "standard" spreadsheet development practices.

He covers a lot of different areas including alternatives to nested IF statements, database modeling techniques, and sensitivity analysis. The second part shows you how to create a real world example of a model using all the concepts presented in the first part of the book. Sample Excel files are provided so you can follow along with the book, and also use them in your own models.

The content is great, but I gave this a 5 star rating because I do NOT agree with every concept Jordan presents. He makes some arguments for a different approach to developing Excel models with VBA applications. This includes things like naming conventions, how to store your macros and modules, and more. These theories made me think about my own development practices, and how I do things because "I've always done them a certain way". Even though I might not adopt all the practices presented in the book, it forced me to take a step back and think about things from a higher level. Forcing yourself to think outside the box spurs creativity and can really help you grow.
15 people found this helpful
Helpful
 Report
Kelyn
5.0 out of 5 stars Great read! Very thought provoking and not mundane like many Excel books I have read before.
Reviewed in the United States on May 14, 2015
Verified Purchase
This book provides a fun new perspective on data modeling and user interface. It has transformed my idea of what spreadsheets should look like, as well as the structure of the data and all naming conventions that are behind them. The title doesn't lie that this book is an advanced level Excel book, but what I like most about it is that it provides a big picture look at many topics, rather than just throwing some code and functions in front of you. It really helps transform the way you look at spreadsheets and all that goes into them, and makes you think about many things that you can do differently while modeling data.

As an accounting analyst, Jordan's ideas have me immensely in my career. His principles and the other ideas in this book will save both me and the users of my work countless hours of trying to sort through excel and VBA code, and the logic that goes behind it. I would recommend this book to anyone, and already have recommended it to many of my coworkers.
4 people found this helpful
Helpful
 Report
Meagan T.
4.0 out of 5 stars Great resource with a little room for improvement
Reviewed in the United States on February 1, 2017
Verified Purchase
This book is great! It goes into detail on how to create different things that I hadn't seen elsewhere (i.e. a worksheet-based form wizard, storing/editing the information stored by the wizard via a worksheet database, web link tutorials on how to create a mouseover event in Excel, etc.). Be forewarned, though, that I'm about 85% of the way through the book and it doesn't seem to address the frustration of having the undo stack being disabled with each macro run (if you're familiar with Excel, you know this is common when using macros - and for a good reason - but the author doesn't seem to call attention to it happening nor how he would handle it).

I personally feel the book could have used a little better editing as the writing feels clunky at times. This doesn't detract from the reader's understanding 98% of the time, but it held me up a couple times. For example, I felt that style consistency was lacking in areas, causing me to have to flip back and forth across a couple pages to reference a figure many different times. Sometimes the figure was before the explanation of it, and other times it was after. For me this was frustrating simply because when I'm attempting to use a book in a walkthrough manner, all the flipping around can get you "lost" at times. Perhaps this is nitpicking, but it was something of which I was constantly aware, which grew to be a major nuisance for me.

With that being said, though, the book is a solid resource and the knowledge presented seems to be valuable. If you're looking to build a wizard within Excel without using a traditional userform, this may be exactly what you're looking for. I would highly recommend it for an intermediate Excel user looking to expand his or her Excel skills.
5 people found this helpful
Helpful
 Report
Chris Newman
5.0 out of 5 stars Not Your Typical Excel Book
Reviewed in the United States on January 20, 2015
Verified Purchase
First off, I must say that this is probably the shortest amount of time it's taken me to read through an Excel book (and I've read quite a few). I just couldn't seem to put it down! Advanced Excel Essentials is unlike most technical Excel texts in that it felt more like I was attending some sort of TED Talks lecture than skimming through a bunch of tutorials. Jordan Goldmeier presents some great technics in this book that are applicable to many real-world business situations and can easily be implemented. His emphasis on being able to reverse engineer other's work is spot on in today's business world. He also tells you which features of Microsoft Excel to stay away from and which will give you and your audience the best user experience. I cannot recommend this book enough and it's definitely a must for any aspiring finance or data analyst who wants to jumpstart his/her career.
8 people found this helpful
Helpful
 Report
Alex Powers
5.0 out of 5 stars This May Just Change The Way You Use Excel... I Know It Did For Me
Reviewed in the United States on May 1, 2017
Verified Purchase
It's not hard to imagine why Jordan continues to be at the forefront of the Excel community with his views, objections and application design after reading through Advanced Excel Essentials. As a devout believer in all things spreadsheet he certainly pushed my thoughts on creativity within the program and made me change several of my current practices before I even finished the chapter (see his use of Boolean). For those currently on that intermediate path trying to get to the next level this is a perfect addition to your library.
Helpful
 Report
J Michael Park
3.0 out of 5 stars A good book but his Dashboards for Excel is better
Reviewed in the United States on September 23, 2016
Verified Purchase
It's a good book, but it seemed to me to be a watered down version of his Excel Dashboards book (which I really like).
One person found this helpful
Helpful
 Report
Amazon Customer
5.0 out of 5 stars Good for intermediate Excel users looking to learn more about ...
Reviewed in the United States on May 1, 2016
Verified Purchase
Good for intermediate Excel users looking to learn more about Excel. I liked this book. I usually skim through books like these and only read the sections I'm looking for, but I actually read this book and learned a lot about Excel.
Helpful
 Report
Ryan M. Mccluskey
5.0 out of 5 stars Five Stars
Reviewed in the United States on February 21, 2015
Verified Purchase
Short but very useful techniques
2 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Anonymus
5.0 out of 5 stars Gran fuente de información
Reviewed in Mexico on March 27, 2019
Verified Purchase
Gran fuente de información
Report
C Baker
5.0 out of 5 stars Great book for learning advanced Excel techniques
Reviewed in the United Kingdom on November 19, 2015
Verified Purchase
A Data Analyst here from the UK. I found this book insightful, interesting and well written for the more advanced Excel user (or at least intermediate).

I am usually one to get a few chapters in and give up out of boredom, or skip to the relevant bits to me, but in this case I read from cover to cover, worked through the sample files and embraced the slightly out-of-the-box thinking. Some of which I'm completely on board with, other parts I'm yet to be convinced. But all of it opens up your thinking.

I will particularly take some of the user form techniques and utilise them at work.

A great read for anyone who wants to develop their Excel skills, and a really relevant book for people who work with Excel regularly in their day jobs.
Report
Miles Bennett
5.0 out of 5 stars This is a must buy for ALL Microsoft Excel developers
Reviewed in the United Kingdom on October 24, 2015
Verified Purchase
I thought I knew a lot about Excel. I even teach it to clients. However, Jordan has made me the student. One of the very few technical books that I have that I just cannot put down.
Report
QB
4.0 out of 5 stars Four Stars
Reviewed in the United Kingdom on February 3, 2015
Verified Purchase
Slightly quirky view of Excel but it's good to have a contrary opinion to the generally accepted one.
One person found this helpful
 Report
xxln3
5.0 out of 5 stars Great book.
Reviewed in the United Kingdom on July 25, 2015
Verified Purchase
I'd recommend this book to anyone who is serious about Excel development. Jordan's book is a shortcut through the period of learning which normally consists of browsing blogs, articles and collecting scraps of knowledge from Excel gurus.
Report