• PowerPivot “Publish to Web” Test
    11th February 2016
    Microsoft 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 2
    18th May 2015
    In 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 2015
    If 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 preview
    2nd February 2015
    Last 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 2015
    As 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 Spreadsheet
    1st January 2015
    Microsoft 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 Provider
    10th January 2012
    So, you’ve decided to get some onsite computer training for your staff, great. Onsite training in Microsoft Applications can really enhance...