Please note javascript is required for full website functionality.

A To Z of Excel Functions

A To Z of Excel Functions

A to Z of Excel Functions: The COMBIN Function

1 September 2017

Are you often COMBIN the Excel functions to see how many subsets you can make? This function returns the number of combinations for a given number of items (i.e. the number of distinct subsets of items where order is unimportant). You should use COMBIN to determine the total possible number of groups for a given number of items.


A to Z of Excel Functions: The COLUMNS Function

21 August 2017

This is one of the pillars of Excel’s features. Yes, the jokes get no better...


A to Z of Excel Functions: The COLUMN Function

14 August 2017

The COLUMN function Ah, it’s time for my Lord of the Rings impersonation. What do I mean? “COLUMN” (try saying it out loud if you don’t understand – this joke is precious). This function returns the column number of the given cell reference. For example, the formula =COLUMN(D10) returns the value 4, because column D represents the fourth column.


A to Z of Excel Functions: The CODE Function

7 August 2017

If you find it CODE outside, this function may assist you. CODE returns a numeric code (great dictionary definition) for the first character in a text string. The returned code corresponds to the character set used by your computer.


A to Z of Excel Functions: The CLEAN Function

24 July 2017

Need to make a CLEAN getaway? This function removes all nonprintable characters from text. And I’m not talking about expletives...


A to Z of Excel Functions: The CHOOSE Function

17 July 2017

Do you choose to use CHOOSE? This function uses index_num to return a value from the list of value arguments...


A to Z of Excel Functions: The CHITEST Function

10 July 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 CHISQ.TEST Function

26 June 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 CHISQ.INV.RT Function

19 June 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 CHISQ.INV Function

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


Newsletter