Source Code

...........\chapter 01

...........\..........\worksheet controls.xlsx

...........\chapter 05

...........\..........\character set.xlsm

...........\..........\text formula examples.xlsx

...........\..........\text histogram.xlsx

...........\chapter 06

...........\..........\day of the week count.xlsx

...........\..........\gmt conversion.xlsx

...........\..........\holidays.xlsx

...........\..........\jogging log.xlsx

...........\..........\ordinal dates.xlsx

...........\..........\time sheet.xlsm

...........\..........\work days.xlsx

...........\chapter 07

...........\..........\adjustable bins.xlsx

...........\..........\basic counting.xlsx

...........\..........\conditional summing.xlsx

...........\..........\count unique.xlsx

...........\..........\counting text in a range.xlsx

...........\..........\cumulative sum.xlsx

...........\..........\frequency distribution.xlsx

...........\..........\multiple criteria counting.xlsx

...........\chapter 08

...........\..........\basic lookup examples.xlsx

...........\..........\specialized lookup examples.xlsx

...........\chapter 09

...........\..........\database formulas.xlsx

...........\..........\nested subtotals.xlsx

...........\..........\real estate database.xlsx

...........\..........\real estate table.xlsx

...........\..........\table formulas.xlsx

...........\chapter 10

...........\..........\simultaneous equations.xlsx

...........\..........\solve right triangle.xlsm

...........\..........\unit conversion tables.xlsx

...........\chapter 11

...........\..........\basic financial formulas.xlsx

...........\..........\bond calculations.xlsx

...........\..........\extending basic functions.xlsx

...........\..........\payment components.xlsx

...........\..........\rate conversion.xlsx

...........\chapter 12

...........\..........\county data.xlsx

...........\..........\depreciation.xlsx

...........\..........\fvschedule.xlsx

...........\..........\internal rate of return.xlsx

...........\..........\irregular cash flows.xlsx

...........\..........\multiple irr.xlsx

...........\..........\net present value.xlsx

...........\chapter 13

...........\..........\amortization.xlsx

...........\..........\financial statements.xlsx

...........\..........\indices.xlsx

...........\..........\loan data tables.xlsx

...........\chapter 15

...........\..........\array formula calendar.xlsx

...........\..........\logical functions.xlsx

...........\..........\multi-cell array formulas.xlsx

...........\..........\single-cell array formulas.xlsx

...........\chapter 16

...........\..........\iterative chart animation.xlsx

...........\..........\net profit (circular).xlsm

...........\..........\net profit (not circular).xlsx

...........\..........\recursive equations.xlsx

...........\..........\simultaneous equations.xlsx

...........\..........\unique random integers.xlsx

...........\chapter 17

...........\..........\box plot.xlsx

...........\..........\chart from combo box.xlsx

...........\..........\clock chart.xlsm

...........\..........\comparative histogram.xlsx

...........\..........\conditional colors.xlsx

...........\..........\function plot 2D.xlsx

...........\..........\function plot 3D.xlsm

...........\..........\gantt chart.xlsx

...........\..........\gauge chart.xlsx

...........\..........\hypocycloid - animated.xlsm

...........\..........\hypocycloid chart.xlsx

...........\..........\linear trendline.xlsx

...........\..........\nonlinear trendlines.xlsx

...........\..........\plot circles.xlsx

...........\..........\plot every nth data point.xlsx

...........\..........\plot last n data points.xlsx

...........\..........\thermometer chart.xlsx

...........\chapter 18

...........\..........\bank accounts.xlsx

...........\..........\calculated fields and items.xlsx

...........\..........\county data.xlsx

...........\..........\employee list.xlsx

...........\..........\hourly readings.xlsx

...........\..........\income and expense.xlsx

...........\..........\music list.xlsx

...........\..........\sales by date.xlsx

...........\..........\test scores.xlsx

...........\chapter 1