Please note javascript is required for full website functionality.
MVP

Blog

Blog

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


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


Power Query: Calendar Creation – Going for Dates

19 April 2017

As I described in Calendar Creation – Preparing for Dates building a calendar using Power Query is a collaboration between Excel and Power Query. Read this article to find out how!..


Newsletter