- This book is for the experienced Excel user planning to take their skills to the next level. Whether you’ve been working with Excel for many years—or you’re a new up-and-comer—this book is an essential guide to begin making advanced spreadsheets right away.
Buy this book
- About this book
-
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.
- Table of contents (9 chapters)
-
-
Introduction to Advanced Excel Essentials
Pages 3-9
-
Visual Basic for Applications for Excel, a Refresher
Pages 11-29
-
Introducing Formula Concepts
Pages 31-48
-
Advanced Formula Concepts
Pages 49-66
-
Working with Form Controls
Pages 67-92
-
Table of contents (9 chapters)
Recommended for you

Bibliographic Information
- Bibliographic Information
-
- Book Title
- Advanced Excel Essentials
- Authors
-
- Jordan Goldmeier
- Copyright
- 2014
- Publisher
- Apress
- Copyright Holder
- Jordan Goldmeier
- eBook ISBN
- 978-1-4842-0734-5
- DOI
- 10.1007/978-1-4842-0734-5
- Softcover ISBN
- 978-1-4842-0735-2
- Edition Number
- 1
- Number of Pages
- XIII, 216
- Number of Illustrations
- 246 b/w illustrations
- Topics