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 your skills to take them to the advanced level. This book 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 engineerthis is the youve 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 authors hard won real-world experience
"