How to Use TEXT & custom number formatting in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:

1) Format cells

2) Format formula input numbers to show a label with custom number format

3) TEXT function used with text formulas to create labels

4) TEXT function to create TRUE/FALSE formulas to check whether criteria is met

5) Count number of dates in a data set that meet criteria (certain month)