Blog & Excel Tips

We have recently completed a number of IFRS Excel Calculators relating to assessing the possible impact of IFRS 15 and 16 on the financials of a listed entity.

But when it comes to dates and times, you may have created some sort of tracking spreadsheet that needs to warn you once a certain date/ time is approaching. Is there a trick to auto refresh Excel every minute (with no VBA)?

A problem with the existing settings in Excel is that you cannot change more than 6 default chart colours. You can set up your own customised colours to use for each series but only up to series 6. This shows some workarounds.

Our 2018 Rugby Six Nations Predictions Spreadsheet enables up to 50 participants to predict the round robin and final winners (overall, grand slam, triple crown and wooden spoon)  and compete to see who can be closest in predicting the overall result and the scores of each team.

We are hosting another Financial Modelling in Excel meetup on the 24th Jan 2018 in Johannesburg.

If you are having problems with the online Excel training login (asks you to repurchase the course) please read this

If you know the answer but want the input from Excel without you having to try incremental numbers until you get close to the answer you want.