Home > Resources > Page 9

Resources

Our solutions are effective and simple to use. Have a look through our wealth of modelling-related white papers, videos, brochures, articles and tips & tricks, curated for you.

excel_logo

arraycontext menu

Excel 2013 cell context menu index changed

In Excel 2013 the index of the cell context menu commandbar has changed

Antique (1907 copyright expired) map and compass

Free Excel softwareModel maps

Model maps getting to grips with a new model

When you first see an Excel workbook, does it set your head spinning, trying to understand what you are looking at? Here's how we tackle ...

Brexit blog

BrexitGeneral News

Brexit is a reality

So now we know. Britain has voted to leave the European Union and we are facing an uncertain future.

Monty Hall05

BrexitGeneral News

Light relief from the Brexit Debate

A maths problem (which, apparently, most people get wrong) caused merriment here at Numeritas and we can draw some parallels with the Brexit debate, so ...

Row of houses in suburban neighborhood

General NewsHca

New regulatory framework for social housing

The Homes and Communities Agency (HCA), the UK regulator of social housing introduced new regulations that took effect on 1 April 2015. Providers of social ...

HMRC Sign iStock_000016444516_XXXLarge

Excel - TechnicalFinance

Do you really need to model VAT

For many businesses, VAT (“Value Added Tax” ie sales tax) is a tax that has little effect on profits. “Now that’s my kind of tax” ...

iStock_000060843838_Small (Hash Values)

AuditFile Hash

Using file hashes to prove two models are the same

In the past, when signing off on the review of a model, the sign-off letter would make reference to the file name of the model ...

Hamlet Android iStock_000021858861Small

Best PracticeExcel - Technical

To rebuild or not to rebuild that is the question

If Hamlet were around today, looking at his tired spreadsheet, surely he would be asking himself this question; it comes up time and again.

Airlock sheet diagram

General News

Top tips for linking workbooks

Linking workbook files together can be risky, but the question of how to link files comes up frequently. How can you minimise the risk?

A magician holding a magic wand over a laptop with chain and padlock isolated on white background

General News

The ‘dark art of R1C1 notation

Most people who use Excel are familiar with the default A1 style of referencing, but there is another way - the dark art of R1C1....

excel-chart-for-word-powerpoint

Best PracticeExcel - Technical

Bringing Excel charts or data tables into Powerpoint or Word using Office 2010

Having built your flexible and robust model in excel, based on Numeritas’ financial modelling SCILS no doubt, you will be eager to share the key ...

Internal-rate-return

Best PracticeFinance: Excel - Technical

Problems with the IRR in Excel

Many organisations rely on the IRR as a measure of the success of a project. There are, however, some technical issues with using the IRR ...