Why does Excel’s calculation mode keep changing?

You’re probably already aware that Excel has two main calculation modes: automatic and manual. Automatic calculation – calculates when a value changes or based on specific actions (inserting, deleting, hiding rows/columns, or renaming a worksheet, etc.). Manual calculation – only calculates when explicitly requested by the user: From the ribbon, click Formulas > Calculate Now Read More

How to split cells in Excel

There are many circumstances where we receive information with multiple data points inside a single cell.  This often occurs when the data’s original intention is slightly different from how we intend to use it.  In these circumstances, we often need to split the cell into its constituent parts.  This post will look at solving this Read More

Spreadsheet Day 2018

Happy Spreadsheet Day! 17th of October is Spreadsheet Day, the day each year when we celebrate… you guessed it… spreadsheets. VisiCalc, the first spreadsheet application, shipped on 17 October 1979. Originally it was only compatible with the Apple II and cost $99. I don’t know if VisiCalc had formulas and functions. Sometimes I wonder what Read More

Excel Tables – Absolute cell & column references

One of the first things we learn in Excel is the magic of the $ symbol.  It freezes the row or column, so when copying a formula, the cell reference does not change.  With the introduction of Tables came a different (and more semantic) way to reference cells, called structured references.  However, structured references don’t Read More

Create a running total in an Excel Table

Excel Tables are one of the best features of Excel.  Tables were originally introduced as part of Excel 2003, under the name of Lists, but were expanded and renamed to Tables in Excel 2007.  Whilst it is possible to use the standard cell referencing with a Table, they have their own referencing style.  Using this Read More