IRR – Internal Rate of Return
See how IRR is calculated in an excel demo.
Protection on Excel Sheets
An overview of using the protection feature in Excel with Stephen Aldridge of Numeritas
Why the NPV function may not behave as you expect
Excel’s NPV function may give a different value than you intend – here’s why.
R1C1 referencing in Excel
Discover R1C1 referencing in Excel and how it is useful.
Merging Cells in Excel (should not be allowed!)
It is possible to merge cells in Excel, but there is a better way to achieve the same appearance, without the problems caused by merged cells.
R1C1 Part 2 – Finding different formulae
Following up from last week. R1C1 helps identify which formulae are copied from other cells. This micro lesson shows how to find formulae that are different in a row or column. Such rogue formulae can be the source of errors.
The Monty Hall Problem
A slight change this week, and a slightly longer video. We explore the ‘Monty Hall Problem’, a deceptively simple probability problem which most people get wrong. This involves a game show with a game of chance to win a car. We built a simulation of the probabilities to prove the correct solution.
How a pivot table hid data – and cost Blackpool NHS £185k
Blackpool Teaching Hospitals NHS Foundation Trust has been fined £185k for leaking personal data published in a spreadsheet. This video shows you how easy it is to find the detailed data from a pivot table.
Number formatting in Excel
A brief example of how to format numbers in Excel
Getting context sensitive help for functions in Excel
Tired of getting every entry on the internet when all you want is help on a specific function? Here are two ways to go straight to the help you want.
