The Institute of Chartered Accountants in England and Wales (ICAEW) has just held a competition within its Excel community to come up with the best Excel tip ever.The winning entry suggested using GoTo (F5) and ‘Special’ to select blanks in order to paste in missing...

April’s newsletter challenges our readers to come up with what they think is the “Best Excel Tip Ever”, with results to be published in a couple of months. In the meantime, reader Brian Canes has drawn our attention to a new book in the pipeline from fellow Excel MVP...

For those of you working with the Power Business Intelligence (Power BI) tools in Excel, you may be interested in Power Update, a new Excel add-in for users who wish to refresh any Power Pivot / Power BI workbook from any data source and publish to any location (e.g....

Excel experts Frail Loop have announced a beta version of an exciting new add-in for Excel, A-Folio Pro. Aimed at accountants, financial modellers and analysts everywhere, this software is freely available for the time being for testing purposes only.From entering no...

On March 5, Microsoft released a Preview of Office for Mac 2016, with the full suite due to launch in the second half of the year. This preview includes an updated version of Excel.In order to install the preview, Macs purchased from 2008 onwards should work, just...

At least eight of the current Excel MVPs have now been confirmed to present at the Excel Summit in Amsterdam on April 13 and 14.SumProduct’s very own Liam Bastick will be amongst the MVPs presenting in this two-day conference covering:How to use Power Query to...

Microsoft has announced that its next operating system will be offered as a free upgrade to owners of devices running Windows 8, Windows 7 or the Windows Phone.The offer, which is limited to the operating system’s first year of release, may aid its adoption, marking...

It has been a busy time for us over the Christmas and New Year period with various meetings / discussions held around the globe in London, Los Angeles, Rome and Melbourne amongst others, to name drop a few places. Indeed, Liam Bastick caught up with fellow Excel...

SumProduct is pleased to announce that our MD, Liam Bastick, has been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel for 2015. This award recognises exceptional technical community leaders from around the world who voluntarily share their...

Further to our last post, SumProduct teams up with the Chartered Institute of Management Accountants (CIMA) to deliver a Christmas Quiz based on an Excel problem for its Insight magazine.We gave advanced notice back in late November and now we’re giving our...