Please note javascript is required for full website functionality.
MVP

Blog

Blog

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


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


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


A to Z of Excel Functions: the CELL Function

24 April 2017

With our A t Z of Excel Functions series, you could argue we have been trying to make a soft CELL (get it?).


Newsletter