Tag Archive | Microsoft Excel

A great reporting tool from Excel – PowerMap

Bull Dutch National Supercomputer

As you might know from some of my previous posts,  I really like concise presentation of information. The infographic is one of my favourites.  Graphical reporting is always great, and managers tend to really like it – it simple, conveys trends, and it’s not boring accounting numbers.

I read a piece on CIMA Insight  about a new add-in for Excel 2013 called GeoFlow, or more correctly PowerMap. You can read the full article here. The add-in uses Bing Maps (from Microsoft) and you can plot up to a million rows of data against a map. You can also plot date data, so you could for example see how sales have trended over time on a map. The data can be presented in 3D format, as bubbles, or as a heat map. This tool will certainly create really cool business reports.

Using Microsoft Excel to estimate costs with linear regression

If you have studied management accounting, you may remember the long-winded formulae to estimate values to put in a linear equation. Well, it’s a lot easier using MS Excel. Take a look at this video I have put together.

%d bloggers like this: