PART I

image

Core Advanced Excel Concepts

In this part, I’ll review the core concepts that make up the essentials of advanced Excel.

Chapter 1 explains what is meant by advanced Excel development, and how this book differs from many others. For instance, several books place significant emphasis on Visual Basic for Applications code, believing macros to be the most important feature of Excel development. This chapter will challenge that notion and present advanced concepts as a product of many different Excel features, including code. Additionally, I discuss the most important required skill—creativity.

Chapter 2 provides a brief Visual Basic for Applications ...

Get Advanced Excel Essentials 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.