O'Reilly logo

Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond by Reinhold Scheck

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Model Structures—A Practical example

In this section, we’ll bring together the explanations provided in this chapter and explore them more deeply. The focus here is on structural components and the use of specific formulas. First, though, I’ll provide some background information and some pointers on using the sample file.

On the Companion CD

On the Companion CD

Open the 0203_Analysis_01.xlsx file on the CD ROM.

The similarly named file 0202_Analysis_00.xlsx is provided for the exercises described later and largely consists of master data and source data.

Scenario

A large retail business with 100 branches has historically experienced problems with sales over the summer months, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required