- PowerPivot “Publish to Web” Test11th February 2016Microsoft have (at last) enabled a “publish to web” feature in Power BI. The feature is in “preview” at present, and – ominously – they warn that they may charge for this facility in future. But for the moment, publish to web is free. So what does it...
- Why the Excel Vlookup Function is “So Last Year, Darling” – Part 218th May 2015In my last blog, I showed you how easy it was to use Power Pivot to produce a Pivot table that pulled in data across two tables, Drinks and Categories...
- Why the Excel Vlookup Function is “So Last Year”10th February 2015If you don’t want to suffer from premature ageing, the most important thing is to move with the times and not get set in your ways. This might be a...
- Power BI preview2nd February 2015Last week Microsoft made several important announcements about Power BI, you can read the whole thing on the Microsoft Official Blog I’ve taken a look...
- Excel Power Pivot – Just how big is BIG?14th January 2015As I started working with Power Pivot and Power BI I was aware that it allowed large amounts of data to be manipulated by Excel, but just how large...
- Microsoft Power BI for Office 365, this is not your Father’s Spreadsheet1st January 2015Microsoft Power BI for Office 365 is a fusion of tools designed to provide data analysis, visualisation, ad-hoc query and sharing of Excel data and...
- 12 Questions to ask your Training Provider10th January 2012So, you’ve decided to get some onsite computer training for your staff, great. Onsite training in Microsoft Applications can really enhance...