Loading...

Highline Excel Class 27: Custom Number Format & TEXT function

40,505 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Apr 27, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

See how to use Custom Number Format for Cells and the TEXT function:
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)

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...