Please note javascript is required for full website functionality.
MVP

Blog

Blog

Monday Morning Mulling: February Challenge

27 February 2017

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

Read more


Final Friday Fix: February Challenge

24 February 2017

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

Read more


Power Query – a World (Wide Web) of Possibilities

22 February 2017

Welcome to our new Power Query blog. I have already shown how to extract and transform data from CSV files, folders and Access database tables. Today, I look at a potentially huge source of data – extracting data from the web…

Read more


A to Z of Excel Functions: the BITLSHIFT Function

20 February 2017

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the BITLSHIFT function.

Read more


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.

Read more


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.

Read more


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.

Read more


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.

Read more


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

Read more


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

Read more


Newsletter