Download file: https://excelisfun.net/files/ExcelBasics.xls
Download file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelBasics.xls
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#6 Video topics:
1)Name a range of cells
2)Name box
3)COUNT function
4)MAX function
5)MIN function
6)SUM function
7)COUNTIF function
8)SUMIF function
9)STDEVP function
Also, see this video: Excel Name Trick #1: Names in Excel 2003 & 2007

Also see this complete Name Video Series: 04 Excel Series: Names 1-12