Please note javascript is required for full website functionality.

Blog

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 Excel spreadsheet so that there are less rows to deal with...


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.


VBA Blogs: 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...


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.


A to Z of Excel Functions: The CHAR Function

5 May 2017

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


Power Query: Aggregating Aggravating Worksheets in Other Workbooks

3 May 2017

Though this may sound similar to last week’s blog, in many ways this method has just as much in common with One Folder, One Query...


Monday Morning Mulling: April Challenge

1 May 2017

On Friday, I stated that a positive integer (whole number) is said to be prime if only two different numbers divide it: one and itself.


Final Friday Fix: April Challenge

28 April 2017

Are You in the Prime of Your Excel Knowledge? A positive integer (whole number) is said to be prime if only two different numbers divide it: one and itself.


How do I Install Power Query?

27 April 2017

Every month we welcome new readers to our website and newsletter, so a very common question we get is, “…I see you mention a lot of useful things with Power Query. I have Excel, but don’t seem to have Power Query – how do I get it?”...


Power Query: Aggregating Aggravating Worksheets

26 April 2017

I begin in a workbook that contains three worksheets. Each of the worksheets has been populated with a table of expenses information...


Newsletter