Blog & Excel Tips

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.

Creating a variable moving average formula in Excel without having to manually change the period, or building complex nested IF functions.

In MS Excel there is a tool called Goalseek that lets Excel search for a solution you are looking for. If you already use it you may want to improve the Goalseek precision for cases where Excel gets close to but not exactly the correct number.

However, we highly recommend that you DON'T use merge cells in MS Excel and rather use the alternate in this post.

... the key planning areas is how many resources you may need given a specific workload, and more specifically how many 'full time equivalent' staff you may need. In order to do full time equivalent calculations in Excel there are some functions that would be useful to master.

From Excel 2016, there is a convenient Forecasting tool in Excel which allows you to show Excel some historical data (say 24 months worth of sales) and Excel will, taking growth and seasonality into account, forecast for up to 50 months into the future.