Please note javascript is required for full website functionality.

# Blog

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

5 May 2017

## 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?).

## VBA Blogs: Unhiding and Unprotecting Sheets

21 April 2017

Today, we’re going to look at a common application of VBA involving a range of skills that we’ve gone through...