CHAPTER 5
Getting Started: Thinking Outside the Cell
In this chapter, I’ll talk about some misconceptions concerning Excel development. It’s quite often heard that Visual Basic for Applications (VBA) is where all “advanced” Excel takes place. The thought is VBA can do everything, and if you want your data to be sorted, manipulated, and so forth, you’ll need VBA. But you should think of Excel formulas and VBA not as separate entities but as tools that should work in tandem to present the best result.
It’s true that many of the capabilities presented in this book will require knowledge and use of VBA, but it would inaccurate to describe everything ...
Get Dashboards for Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
