Last week, we talked about recording macros to let you repeat and automate sets of commands. Today, we’re going to look at how you can adapt those recorded macros, without relying on specific cell references.

Welcome to our new Power Query blog. In the last two blogs I established that Power Query is an ideal starting point to create the Excel model for use by Power Pivot, and I demonstrated how a table can be added to the Excel model and opened in Power Pivot. Today I look at whether changes to the model should be done in Power Query or Power Pivot.

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 p.

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.

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.

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.

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

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

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 p. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. ...

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.