Claritix Insights

How to Speed Up Excel Financial Models by Fixing Bottlenecks & Excel Volatile Functions excel financial modelling performance & optimisation

Slow spreadsheets can be frustrating, especially when they are critical financial models relied upon to support key business decisions or forecasts. If a CFO is asking for an updated scenario by lunch...

Continue Reading...
How Finance Teams can Analyse Big Data in Excel PivotTables using Power Query big data excel power pivot power query

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...

Continue Reading...
The 6 Stages of Creating a Financial Model excel financial modelling

 

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, ...

Continue Reading...
Transforming Financial Reporting with Power BI and Excel excel power bi power pivot

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...

Continue Reading...
Financial Modelling Advice - Keep It Simple excel financial modelling
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...

Continue Reading...