Absolute or Relative References in Excel
A light-hearted clip explaining the use of absolute and relative references in spreadsheets. Makes the key point that constants should be located separately and not embedded in formulae.
Four basic rules for spreadsheet style, given in a light-hearted way. Identifies the different requirements between spreadsheets that are only used once by oneself versus spreadsheets that may be used more than once, by multiple users and after the passage of time. Continues the story of Helen and the Choco nutties.
Introduction to Excel Solver
A step-by-step explanation of how to use Excel Solver, with an example using children’s Lego bricks. Probably the clearest (and most amusing) explanation of linear programming there is. Demonstrates numerous positive aspects of spreadsheet style, addresses spreadsheet testing. Includes the classic statement “Make sure the spreadsheet works before using Solver”.
Understanding the p-value
A down-to-earth and light-hearted illustration of the use of the p- value in statistics.
How to draw scatter-plots and fit a line using Excel, and what they mean. Promotes the useful concept of de-cluttering graphics.
A description of how to test for the difference of two means. Continues the adventures of Helen and her Choco Nutties. Uses Excel to calculate the p-value relating to the difference between two means and provides a clear explanation. Introductory companion video to "Differences between means in Excel".
Differences between means in Excel
Teaches how to use Excel for hypothesis testing of the differences between two means. It is a follow-on companion video to "Hypothesis Testing". Illustrates the concept of checking that the output from an Excel Calculation is what you expect, and the related concept that many Excel reports are static and will not then change following changes to the underlying Excel spreadsheet.
Confidence intervals in Excel
A brief explanation of the nature of confidence intervals, followed by an example of finding a confidence interval of a mean in Excel. Demonstrates the uses of a simple check to ensure that the Excel output is as expected.