Tag: googlesheets

Posted on

Using flags in financial modelling

Image shows example of flags in financial modelling.

I was going to write a detailed guide about using flags in financial modelling. However, there’s already a really good one here, as part of the ICAEW’s financial modelling good practice guide(s).

So instead I’ll just write something more simple to explain why you might want to use flags in financial modelling. And add a specific point about dynamic arrays, which are a newish development in Excel.

Continue reading “Using flags in financial modelling”
Posted on

Five tips for using Googlesheets if you’re used to Excel

Here are five tips for using Googlesheets if you normally use Excel.

1. Check your document is actually a Google Sheet

If you’ve imported it from Excel, it might still be an Excel file that’s being read by Google in compatibility mode. You can tell because name and file type of the workbook will end in XLSX. 

This is the worst of both worlds, as you are getting neither Excel nor Google functionality. Save the file as a Google sheet (in the file menu) 

A screenshot from Googlesheets showing an xlsx file
Continue reading “Five tips for using Googlesheets if you’re used to Excel”