The recently released November Power Pivot for Excel 2013 updates make changes to how Power Query interacts with Power Pivot as well as providing support for Key Performance Indicators (KPI).For data in Power Pivot that has been added through Power Query, the...

We’ve talked about Power Map for Excel before, but now seemed like an opportune time to provide a timely reminder (see the video demonstration below – like many TV programmes, it’s a repeat!). Power Map is a three-dimensional data visualisation tool that lets you look at information in new ways by plotting data on Bing renders of the globe – all embedded in Excel. Not only can you plot geographic and temporal data on a 3-D globe, you can also show it over time and create visual tours you can share with other people. We’ve actually used to embed informative videos in a PowerPoint display for example. You can use Power Map to:

Yes, it’s that time of year again when the Excel MVP army descends upon Redmond to talk shop with the Excel Product Team. Whilst many of the topics will have to remain confidential for the time being, we do get the opportunity to pass on ideas and comments to those...

September 30 marks Excel’s 30th birthday. Did you know Version 1.0 debuted for the Mac all those years ago? There’s probably a few financial analysts who weren’t even born back then (sigh…). Whilst Excel was neither the first spreadsheet program nor the first...

Many moons back we wrote a long article (that Tolstoy would have been impressed with) regarding which version of Office 2013 to buy. Well Obi-Wan, it’s all gone full circle and ahead of the upcoming full 2016 release we now need to inform you of what version of Excel...

Microsoft has finally announced the official launch date for the long-anticipated new version of Microsoft Office. Office 2016 will be “broadly available” (we’re not quite sure what that means) starting on September 22, whilst Office customers with volume licensing...

We know you will probably find it hard to contain yourselves, but SumProduct will have a re-vamped website coming to a theatre near you very soon. Hold on to your (construction) hats!Aside from a new look, the new website will allow access to archived articles,...

After recently having to explain some of the issues between Windows 10 and Excel 2010, it’s good to provide a more positive bulletin this time around. Microsoft has announced a whole range of informative courses and blogs on Windows 10, chiefly aimed at the IT...

Not that we normally like to promote competitor activities, for those in the UK (and maybe further afield), the ModelOff Global Training Camp (GTC), in collaboration with Microsoft, is a two-day technical training development program “…aimed at young and emerging...

Starting today, users of Office 2007 – not just Excel 2007 – who have not installed a security update released today will no longer be able to access online templates. If you haven’t ever checked out these templates, you should take some time to browse: there are...