Excel Basics #6: Names Cell Ranges and Functions

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

Category:

Science & Technology

Tags:

• Excel
• Name
• Cell
• Range
• Functions
• function
• Formula
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[ummmomen]

Hi, I have tried something and it works. I have only 6 columns , so i highlighted the head then ctrl shift down arrow then I named the open range as I know I increase only the rows. so when ever i enter more data the min & the max changes. send me if i did right. once again thanks for your video

[ExcelIsFun]

@ummmomen , try this playlist of videos about Dynamic Ranges:

youtube [dot] com/user/ExcelIsFun#grid/user/­F6A29BD9E1CD5E6A

[ummmomen]

Hi, thanks for the video. I have a question here. we gave a name to the range to be easy when getting the min & max etc. how can i give a name for an open range. means i enter everyday more rows but i need the min & max to change according to the data i entered.

[ExcelIsFun]

@ummmomen , try this playlist of videos about Dynamic Ranges:

youtube [dot] com/user/ExcelIsFun#grid/user/­F6A29BD9E1CD5E6A

[b00gied0n]

just confused about why you used stdp instead of std in the final part. i understand it mentions population in the question but where is the population in the table. it just has observations. i used std on its own and it gave a different number

[ExcelIsFun]

@b00gied0n , it was all the sales for the month, so all - population.

[ummmomen]

@ExcelIsFun Thanks, sure I will.

[ExcelIsFun]

You are welcome!

[geoff1424]

Couldn't thank this man enough for the help!

[ExcelIsFun]

I am glad that you like it!