L EN Downloads

This fun file gradually reveals a hidden picture using the magic of conditional formatting and a snazzy spinner button or a macro button. As a bonus, you can find out how to create your own file using a picture of your choice under videos. Have fun!

PS Thanks to Leila Gharani for the techniques used.

Studies show that spreadsheet errors are commonplace. These can cause you huge losses of money, time and reputation. On top of that, spreadsheets are often poorly designed and constructed so that users have a hard time trying to understand and use them. The consequence is, they hinder rather than help you.
Major causes are a lack of best practice training and insufficient error awareness. In this book, we address both these points.

» Buy book on Amazon

Here you can download free bonus material: Excel files with all examples from the book as well as a practical checklist to print out and refer to for your work!

Do you need to check your loan repayments, depict a loan in a financial model or calculate your IFRS16 balances? Use our flexible amortisation schedules for loans and financial leases with simple inputs, automated calculations and professional formatting in Excel. Read more details in the related blog: Loan Amortisation Schedules

It's Christmas time again, the season of cheer. You can bring a little festive merriness to your PC by downloading this file to simulate Christmas tree lights using the magic of random numbers combined with conditional formatting. Or why not create a simulation yourself? Learn how in my blog: Simulate Christmas tree lights in Excel

Heat maps can be a great way to present large amounts of data in a compact yet easily understandable way. In this file you will find a great example of a heat-map showing the number of new confirmed Corona virus cases by country and date. View an explanatory video here: Create a heat map to show Corona virus cases

On 1st April 2020 my business Knott Consulting achieved five successful years in operation. To celebrate, I created a birthday candle simulation, in Excel of course! In this file you can find the simulation ready to go, just press and hold F9. Find out how to create such a file yourself here: Simulate birthday candles

The press is full of Corona virus stories and graphs, but what is the basis of the projections? In this file you can understand the concept of exponential growth and simulate the number of Covid-19 infections. View the explanatory video here: Simulate Corona virus infection rates

Download this one-pager of the best shortcuts organised into task areas for you to print out and refer to. Set yourself the goal of learning and practicing one or two per week to make them part of your daily work.

You can work more efficiently in Excel if you can navigate effectively. With regular practice of the methods I explain, you too can become an expert in Excel navigation! If you prefer to read details online, please see my blog: Navigate efficiently in Excel

Learn and follow these golden rules to achieve valuable benefits:

• the ease of use and flexibility of your models are increased;
• the risk of error is minimised;
• your model results are more reliable for decision-making.
   

Download these two files: (i) an Excel file which creates a fun snowfall for Christmas using a macro using nested loops to carry out actions in every column and every row and (ii) an explanatory PDF. You can have fun using the Excel file and you can also learn about nested loops by reading the explanation and studying the macro code.