Jason Howie

This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.

Use the LEN function to count characters in Excel. Use LEN and SUBSTITUTE to count specific characters in Excel.

Use the SUM function in Excel to sum a range of cells an entire column or non-contiguous cells. To create awesome SUM formulas combine the SUM function with other Excel functions.

You can find most charts on the same worksheet as the source data (embedded charts). However you can also move a chart to a separate sheet that only contains a chart (chart sheet).

This example teaches you how to create a Pareto chart in Excel. The Pareto principle states that for many events roughly 80% of the effects come from 20% of the causes.

If the size of your array increases and you don't want to fix the size of the array you can use the ReDim keyword. Excel VBA then changes the size of the array automatically.

The TRIM function in Excel removes leading spaces extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.

This example illustrates how to use the union and intersect operators in Excel (borders below for illustration only).

The Format Painter is one of the most underused features of Excel. The Format Painter copies formatting from one place and applies it to another.

To separate the contents of one Excel cell into separate columns you can use the 'Convert Text to Columns Wizard'. For example when you want to separate a list of full names into last and first names.