Please note javascript is required for full website functionality.
MVP

Blog

Blog

Final Friday Fix: May Challenge

26 May 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 Summary Taster

24 May 2017

At the end of that article, I had made some changes to a query of mine, ‘ACCT_Order_Charges_with_Group’. I will be making more changes, but to avoid causing problems to the grouping query, I will create a copy of the query.

Read more


A to Z of Excel Functions: the CHIINV Function

22 May 2017

In probability theory and statistics, the chi-squared distribution (also chi-square or ?2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables.

Read more


Speeding up the Pace of Running Your Macros

19 May 2017

Macros can run pretty slowly when you start working with large files. There are a couple of tricks to improve the speed that your macro runs, relating to a) calculation time, and b) screen updates.

Read more


Power Query: Group and Conquer

17 May 2017

Grouping in Power Query is not intended to replace the excellent tools available in Excel spreadsheets to group and summarise data. Power Query’s talent is its ability to manipulate very large data sets, and it can be useful to group data before uploading to an...

Read more


A to Z of Excel Functions: the CHIINV Function

15 May 2017

In probability theory and statistics, the chi-squared distribution (also chi-square or ?2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables.

Read more


Handling VBA Errors

12 May 2017

Last time we were here, we talked about a macro you could use to loop through all of the sheets in a file and unhide them and unprotect them. This presents problems when there are passwords that you're not aware of...

Read more


Power Query: Unlimited Importing of Non-Delimited Text Files

10 May 2017

As a programmer, I was often asked to produce delimited versions of reports which could easily be picked up by Excel. Whilst it is possible to clean non-delimited files in Excel, it’s a laborious and repetitive process, which is why it made more sense to pay for a...

Read more


A to Z of Excel Functions: the CHIDIST Function

8 May 2017

In probability theory and statistics, the chi-squared distribution (also chi-square or ?2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables.

Read more


A to Z of Excel Functions: the CHAR Function

5 May 2017

Cup of tea? Well a cup of CHAR won’t help you…

Read more


Newsletter