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 (without using a Vlookup). Well, we’re going to carry on ditching the Vlookup by looking at Power...
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...
New Book “Facilitating Live Online Learning” by Colin Steed19th August 2011Returning from my summer break, this book was waiting for me in the post. I’d known that Colin was working on this book for some time and its now...
Blog
As Microsoft software evolves and new opportunities to enhance your data visualisation and integration evolve through Power BI, we like to keep you up to date. Our blog not only looks at new developments but shares consultancy news and training opportunities. Sign up to our blog to stay in touch.
