Tag Archives: Excel

Spatial analysis with Bing Maps & Excel

After months of BI work in the office I finally got the opportunity to take a break and get out of the office to see the field sales end of the business. Additionally, in the last couple of months I’ve … Continue reading

Posted in Spatial Analysis | Tagged , , | 12 Comments

Pivot Table Sort

In Excel 2010 we are able to apply our own custom sort to Pivot Tables. This is particularly useful when you want to report on financial periods such as Jan, Feb, Mar. If your financial year begins on Apr, you … Continue reading

Posted in Power Pivot | Tagged , , | Leave a comment