Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond

Chapter 2. New Approaches—Getting Started

Now that we’ve covered the most important basic principles of using Excel 2007 in Chapter 1, we can start to get our hands dirty. However, we’ll continue to work with an example for the time being, in order to clarify rules and lay a solid foundation for future work.

I’ll start by describing the working and structural model that provides a basis for many of the examples in this book. Next, I’ll explain the key formulas that play dynamic roles in such models, and which are of particular importance in this book. I’ll then introduce an example based on these, which I’ll first outline and then guide you through with step-by-step instructions that will let you reproduce it for yourself. You’ll get the most of ...