Please note javascript is required for full website functionality.

# Blog

## A to Z of Excel Functions: the BINOM.INV Function

6 February 2017

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability...

## Introduction to VBA – Reading Code

3 February 2017

Last week, we talked about recording macros to let you repeat and automate sets of commands. Today, we’re going to look at the code behind those automated commands.

## Power Query – (Data) Model Building

1 February 2017

Welcome to our new Power Query blog. Today I extract a table from an Access Database and load it into the Excel data model ready for use by Power Pivot.

## Monday Morning Mulling: January 2017

30 January 2017

If you’ve been following our VBA blog series and don’t have much experience with VBA at all, then this might go a bit over your head.

## Final Friday Fix: January 2017

27 January 2017

This month, our Final Friday Fix comes from a query that came in to us. So without further ado, let’s take a look!

## Power Query - Relationship Goals

25 January 2017

Welcome to our new Power Query blog. Today I look at the relationship between Power Query and Power Pivot.

## A to Z of Excel Functions: the BINOM.DIST.RANGE Function

23 January 2017

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability...

## Introduction to VBA: Recording Macros

20 January 2017

Every Friday, we intend to post a blog talking about VBA and highlight the benefits, the pitfalls, and cover a range of basic concepts that everyone who uses VBA should know.

## Power Query - What's in a Name?

18 January 2017

Welcome our new Power Query blog. Today I extract information from a file name.

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

16 January 2017

Almost the same as last time’s function, 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 repeats. ...