Claritix Insights

When we think of “big data,” Excel likely isn’t the first tool that comes to mind. It’s often seen as suited to smaller-scale analysis - and with good reason. Excel worksheets max out at just over a m...

Financial models underpin some of an organisation’s most important decisions. Their development can be complex, involve many stakeholders, and take considerable time. They are often serious tools, ...

In our previous financial reporting insights (see end of article), we covered how to use Power Query to automate the extraction, cleaning, and consolidation of data, and how data models in Power BI or...

Why overly complex Excel financial models are a problem. Advice on how to keep Excel financial models simple. 

For all the financial modelling rules, guidelines, best practices and advice out ther...

Identifying the common causes of slow Excel spreadsheets. Advice on how to diagnose and resolve problems through understanding how Excel works. Tips on functions to avoid in your spreadsheet.

Carb...