Blog & Excel Tips

If you build financial models, you may need to answer a question like when is the first time we go positive, or when was the first non zero value in a MS Excel list.

Below is a link to a simple Compound Annual Growth Rate (CAGR) calculator built in MS Excel with a proof to give you comfort that the number is correct.

When working with MS Excel's Power Query/ Get&Transform you may find that you want to change the Load format. However you may find yourself asking why Power Query close and load to is greyed out

... problem relates to the Data Table number formats not working. If you try and custom format the numbers it ignores it and if you have numbers in millions it seems to only differentiate the first thousand.

MS Excel Training dates for 2019 including the prices and venues in Johannesburg, Pretoria and Cape Town.

If you build charts in MS Excel you may discover that some charts (especially ones that have positive and negative numbers) don't look great as the axis labels overlap the data. As shown below, the April label overlaps the data for the first bill.

Together with Lance Rubin, we have scheduled a free Meetup covering the The Future of Financial Modelling: Innovation, AI and Disruption. The MeetUp will occur on the 25th Oct 2018.

How to insert a row between each row in Excel when you don't want to manually go to each row and click insert.