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.
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.
A large retail business with 100 branches has historically experienced problems with sales over the summer months, ...