Please note javascript is required for full website functionality.
MVP

Blog

Blog

Cleaning Up Recorded Macros

17 February 2017

We’re going to finish off discussion on recording macros by teaching you to clean them up and make them look more professional.


Power Query - Two (Queries) Become One

15 February 2017

Welcome to our new Power Query blog. I have previously shown how to extract a database table and load it into the Excel data model. Today I create a query for a second table and show how queries can be merged.


A to Z of Excel Functions: the BITAND Function

13 February 2017

Now this is more like it. Finally, we get to functions used all of the time by your typical Excel user. Not.


Adapting recorded macros – Range Names

10 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 how you can adapt those recorded macros, without relying on specific cell references.


Power Query – Models Have Relationship Issues Too

8 February 2017

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


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!

 


Newsletter