Book description
"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
"Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
-
Part I: Core Advanced Excel Concepts
- Chapter 1: Introduction to Advanced Excel Essentials
- Chapter 2: Visual Basic for Applications for Excel, a Refresher
- Chapter 3: Introducing Formula Concepts
- Chapter 4: Advanced Formula Concepts
- Chapter 5: Working with Form Controls
-
Part II: A Real World Example
- Chapter 6: Getting Input from Users
- Chapter 7: Storage Patterns for User Input
- Chapter 8: Building for Sensitivity Analysis
- Chapter 9: Perfecting the Presentation
- Index
Product information
- Title: Advanced Excel Essentials
- Author(s):
- Release date: November 2014
- Publisher(s): Apress
- ISBN: 9781484207345
You might also like
book
Advanced Excel Success: A Practical Guide to Mastering Excel
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase …
video
Microsoft Excel - Advanced Formulas And Functions
In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you …
video
Advanced Microsoft Excel 2013
In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond …
book
Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 …