Discover R1C1 referencing in Excel and how it is useful.
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.
Cash we receive in the future is worth less than cash now. Find out how to calculate the Present Value of future cash.We will use this in future videos to understand Net Present Value and IRR.
See how IRR is calculated in an excel demo.
An overview of using the protection feature in Excel with Stephen Aldridge of Numeritas
Excel’s NPV function may give a different value than you intend – here’s why.
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.
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.
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.
A brief example of how to format numbers in Excel