Please note javascript is required for full website functionality.
MVP

Blog

Blog

London Trip Update

12 December 2016

Penultimate trip of the year over! SumProduct’s Liam Bastick has been on the road for the past four months and may be looking forward to the Christmas break, but he still had work to do in London setting up training courses and conferences for 2017 (more on that...


A to Z of Excel Functions: the BETAINV Function (Part 2?)

9 December 2016

Almost the same as last time’s function (BETA.INV), here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show...


Power Query – A Refreshing Approach to ETL (get it?)

7 December 2016

Welcome our new Power Query blog. Today we introduce Power Query...


Newsletter Turns Four

5 December 2016

Who would have thought? December 1 2012 we published our first monthly newsletter. It was only two pages – what a con!! Four years later, the newsletter has ballooned ten-fold to be a 20-page epic with the MD not having aged a day (yeah right – isn’t it time you...


A to Z of Excel Functions: the BETA.INV Function

2 December 2016

In probability theory and statistics, the beta distribution is a family of continuous probability distributions defined on the interval [0, 1] parametrised by two positive shape parameters, denoted by ? (alpha) and ? (beta), that appear as exponents of the random...


Out and About in London

30 November 2016

Early December sees us in London for client meetings, presentations on Power BI and Excel Tricks & Tips (5 and 6 December) for Microsoft at the Global Training Camp and possibly taking in the finals of ModelOff as well (we’re still waiting on our invite there…)...


Monday Morning Mulling: November Challenge

28 November 2016

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us...


Final Friday Fix: November Challenge

25 November 2016

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights...


November MVP Summit Update

23 November 2016

As long as our own Liam Bastick remains an Excel Most Valuable Professional (MVP), November means a trip to the hallowed halls of Redmond (Washington State) for five days to go and liaise with the Excel product team about what’s coming in the near future and what’s...


A to Z of Excel Functions: the BETADIST Function (Part 2?)

21 November 2016

In probability theory and statistics, the beta distribution is a family of continuous probability distributions defined on the interval [0, 1] parametrised by two positive shape parameters, denoted by ? (alpha) and ? (beta), that appear as exponents of the random...


Newsletter