Blog & Excel Tips

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.

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.