Tag: The Excel Club

Excel’s odd but useful – Indirect Function

The Indirect function in Excel is an odd but useful function.  On the Microsoft website, the description given is “Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.” […]

Spreadsheet Risk

Spreadsheet Risks

WARNING – SPREADSHEETS IN USE Computerized Spreadsheets have been around for many decades (way more than I have been around). And as technology evolves so do spreadsheets. The use of spreadsheets has also changed, from simple record keeping to more complex analysis and presentations.  But this increase in complexity brings its own element of risks.  […]