• Combining Excel files using Power Query for Excel

    For the information in this post I am heavily indebted to Michiel Rozema who originally figured this out. This post is an extension to my previous post on combining text (CSV) files using Power Query for Excel.…

  • Investigate Excel sheets using Inquire

    Excel sheets are notorious for their many formulas, references, cutting, pasting, macro’s, hidden columns and sheets and overall complexity. My story about Paul is an (very painful) example of what people can build using Excel and how…

  • Taking the new version of Power Map for a spin

    One of the most exciting tools in Excel has recently released a new version! Get the updated version of Power Map here: http://www.microsoft.com/en-us/download/details.aspx?id=38395 (Excel 2013 only). This update comes with a ton of new features, including some…

  • Keep macros under control

    I have been getting some feedback during the past three weeks (during which I was on vacation) on my post about macros, where I claim that macros are dead. Apart from the odd hateful mail from a…

  • Macros are dead

    Macros are dead. Or soon will be. Think about it: in Office 2003 when you opened a file with a macro the macro was automatically enabled and ready to run. Then with the arrival of Office 2007 things…

  • Power BI and why you should care

    Yesterday Microsoft announced Power BI for Office 365: a self-service Business Intelligence solution delivered through Excel and Office 365. Power BI ties together the various bits and pieces we already had (Power View, PowerPivot, GeoFlow, Data Explorer) and…