Can you use this visualisation?

Data visualisation is one of those fantastic ideas where data is presented in a format that allows us to see what is going on. From a good visualisation we can drawn conclusions about a data set easily. We can interpret the numbers with the effort of doing any number...

If you have an error, try #IFERROR

It is not uncommon to complete a spreadsheet model for expected values only to find that some user inputs¬† are not what you expected result in errors. Depending upon the details, you simply what to stop that error behaviour cropping up in your reporting –...
Visualisation as a market

Visualisation as a market

The market for visualisation is due to grow rapidly based upon @marketmonitor24’s recent report. The value and sectors of the market are varied. People will always like to see data more than work directly with it and there seems to be no end to amount of data...
Fathoming formula

Fathoming formula

Put yourself in the position of a learner … You are following a workbook exercise using Excel. You’ve put the formula in, and entered the data. But something is wrong the number you’ve got is different to the workbook. Option 1: You put your hand up....

Spreadsheets through time …

@TimHarford’s article in the @FT shows how spreadsheets are in fact a projection of good practice from when “computers” were just people. The modern risks and issues that have been attributed to “spreadsheet error” fascinating. However...