1. Importing Dialect Topography data into Excel

This is the end result of the data import routine shown in Illustrations 8.9 to 8.13. The file is the same as in Illustration 8.12.
File name: GH All q1-different.xlsx

2. Exercise 1 – page 307

The file ex1_solution.xlsx contains the solution to Exercise 1. Note that the calculation is at the bottom of the table, so you need to scroll down, after opening the Excel file, to line 1020, or thereabouts.

3. Exercise 2 – page 308

The file ex2_solution.xlsx contains the solution to Exercise 2. Calculations are again at the bottom of the table.

4. Excel Graphing Tool

This is the data and file behind Illustration 8.23: Excel file Graphing_Tool_Example_Ill._8.23.xlsx. Use it in case you're having trouble with this function to locate the error.

5. Exercise 3 – page 311

File name: ex3_solution.xlsx

6. Exercise 4 – page 311

File name: ex4_solution.xlsx

7. Exercise 5 – page 313

File name: ex5_solution.xlsx

8. PivotTables – pages 313-317

The file behind Section 8.3.3: q1-different-Pivot.xlsx