Advanced Excel Essentials

by Jordan Goldmeier

Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you’ve been waiting for!

Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. Among other topics, he covers advanced formula concepts like array formulas and Boolean logic and provides insight into better code and formulas development. He supports that insight by showing you how to build correctly with hands-on examples.

322 pages, Kindle Edition

First published October 29, 2014

Reviews

[John · Rating 5 out of 5]

So great, this is one of the most useful books I've ever read. I'm quite good with Excel but I still picked up some great tricks and methodologies here. Also there were many tips that I knew, but had only found out for myself within the last year or so. I would recommend this to all skill levels.

Despite having read that there is "retread" and the fact that it has a co-author I'm moving straight on to his much longer "dashboard" book

[Wee Yeh Tow · Rating 5 out of 5]

Good reference guide for advanced excel users

[Vivian Nguyen · Rating 5 out of 5]

I love the examples and the no nonsense attitude from the author.

[Prashant gupta · Rating 5 out of 5]

Best book in the market. Teach excel concepts beautifully.