Excel Basics #6: Names Cell Ranges and Functions

[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]

@ExcelIsFun Thanks, sure I will.

[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.

[geoff1424]

Couldn't thank this man enough for the help!

[ExcelIsFun]

You are welcome!

[MrUsman4040]

Great Work....

[ExcelIsFun]

I am glad that you like it!

[darrencornell1]

this is so much fun

[ExcelIsFun]

I am glad that you like it!

[darkwizzard70]

Love it <3 !!!

[ExcelIsFun]

I am glad that the videos are helpful!!

[skullkey123]

thank you for this information i really needed it for my ict test a day from now thanks again

[ExcelIsFun]

You are welcome!

[3brigada4]

Great video and keep up the good work.

Would you know why would cell L15 give me pound signs instead of the result.

i cant figure it out but the other number do show up

[ExcelIsFun]

Pound signs mean the column is not wide enough, or you created a time math formula backwards 9Beg time - end time).

[angelheart285]

i give u billion stars rating boddie...thank u so much

[ExcelIsFun]

Thanks for the stars!

You are welcome for the video!

[vesee]

can't post

[ExcelIsFun]

See below comments:

[vesee]

In our case what does the number 12152.89 tells me? (stdevp)

[ExcelIsFun]

Standard Deviation (SD) is a numerical measure that does these things:

1)Tells you the average deviation each data point is from the mean (AVERAGE function)

2)Is a measure of variation or dispersion

3)Tells you how clustered the data points are around the mean

4)Helps you to decide if the mean fairly represents the data points.

more...

[ExcelIsFun]

5)For comparison purposes if one data set has a small SD and another has a large SD, then the mean with the smaller SD more fairly represents its data points.

6)In loose terms, SD tells you how good your mean is.

7)In our example if the distribution of car prices is bell shaped, we could add and subtract the SD to the mean and then say that 68% of values should lie within this range.

More

[ExcelIsFun]

If explanation of SD is what you want, the complete story is in these videos:

Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)

Excel & Statistics 40: Range & Interquartile Range (Variability)

Excel & Statistics 41: Sample Standard Deviation (Variability)

Excel & Statistics 42: Coefficient of Variation

Excel & Statistics 45: Z-Score (# Standard Deviations From Mean)

Excel & Statistics 47: Empirical Rule (Bell Shaped Curve)

[fahadsaeed50]

coool good vodeo

[ExcelIsFun]

Thanks for the 5 star rating!!

[bradmorgan911]

Great video series. You go fast enough to keeps things interesting but not so fast that I can't follow what you are doing on the screen. Extremely informative and you have a great teaching style. I'm working my way through the 1st two playlists and then will go from there. I use a PC at work but a Mac at home so I'm learning Numbers 09 at the same time which gives me a headache sometimes. Thanks for your postings! Makes my life much easier.

[ExcelIsFun]

You are welcome.

To see how to best use the excelisfun channel, be sure to watch the video that auto-plays at the excelisfun channel.

[ciyajerna101]

Excellent - clear concise and easy to understand format -  ~ also, great voice keeping you engaged all the time

[ExcelIsFun]

I am glad that you liked it!

[ShedMySkin888]

I'm working in Open Office SS (similar to Excel) and entering dates which go from 2009 to 2010. However, when I get to Jan 4 which is the first Monday in 2010, the text reverts to 2009. I've been searching for the format of that cell and trying to force 2010 into it so that it automatically inputs the day and date but it keeps reverting to the day of 2009 and the date. Any suggestions? I know there's a cell format but can't find it.

[ExcelIsFun]

I don't know Open Office. Sorry.

[dymacca]

thanks you so much

[ExcelIsFun]

You are welcome!!

[dymacca]

Great job mate. This is the first ever post of mine and you deserve it. Really informative and in detail. Will endeavor to finish all the series. Could you please confirm if the order of the play list (for the first 4 play lists)arecorrect

1)excel basics

2)Highline Communty Class Advance

3)Lookup Function

4)Beauty of excel

BTW: love those in between jokes like Clean function...KEEP IT UP!!

[ExcelIsFun]

That order is correct. However, if you make it through the 1st two, you have almost everything you need (the Highline one has soooo much in it!).

[JusticeALL820]

Hey your videos r really great and informative.

Can u please also make a vidoe on ACCRINT. accrued intereset. Thank u

i will be looking forward to it

[ExcelIsFun]

Unfortunately, between the Stats class videos and the two books I am writing this year, I am booked up. I do plan do a huge Finance series, but it is not for another year...

[ExcelIsFun]

search for excelisfun, then go to the channel and watch the video that auto plays - it shows how to do everything.

[sensibilita]

Light and Blessings to you for such fun and informative stuff!! :)

[ExcelIsFun]

Thank you!

[jack40russel]

In what sequence should you follow your different classes to reap the best results (ie. a thorough understanding and expert application of Excel)?

[ExcelIsFun]

Dear jack40russel ,

Watch the Excel Basics Series and then The Highline Excel Class Series. That will keep you busy for a long time and it covers most Excel topics.

--excelisfun

[rizmy25]

thanks a lot

[ExcelIsFun]

Dear rizmy25 ,

You are welcome!

--excelisfun

[dreddph]

Excellent video again.

Thanks!

[ExcelIsFun]

Dear dreddph,

You are welcome!

Did you mean EXCELlent?

--excelisfun

[Sabryluvish]

Hi,

I'm a excel teacher and I love your videos. It gives me a lot of ideas. I love you way to teach, I hope to be as good as you someday. Wow!!!

[ExcelIsFun]

Dear Sabryluvish,

If you treat your students with love and care, let them ask any question and when you don't know the answer you say "I don't know, but I'll figure it out and get back to you", and you learn new things every day, then you are as good as me!!! Let me know if you have questions (even ones that I do not know the answer to)!!

--excelisfun

[snocamo154]

What software program do you use to copy the screen as you work on the Excel program? I use something similar called Fraps to create an .avi file while gameplaying, but Fraps won't work with Excel.

Thank you for posting your Excel knowledge. I find it very informative.

[ExcelIsFun]

Dear snocamo154,

I am glad that the videos are informative!

The program I use is called Camtasia. It is an easy program. Of course, it even comes with videos that show you how to use the program.

--excelisfun

[cidfidoutube]

Hi Astighey

I think you shouldnt degrade the work of someone if you havent even posted similar lessons yourself

I have learned loads watching all his videos and I recommend you guys to go through them... It is clear, concise and worthwile to invest some time in them if you want to improve your Excel skills.

Thanks Excelsfun for doing them and keep posting some new videos

[ExcelIsFun]

Dear cidfidoutube,

I'll keep posting, if you keep watching!

--excelisfun

[astighey]

I really dont understand why he talked like this..he put a pressure to every word he says...it is really annoying..it is not fun to listen to your teaching when you speak like that make it simple but not that o.a speaking

[ExcelIsFun]

Dear astighey,

If it is not fun, don't listen!

Remember: This is Free!

--excelisfun

[programSense]

astighey,

Maybe that is the way he talks or maybe that is the way he teaches, whatever the case if you pay attention there is much to be learned from his videos.

Your channel has one video that doesn't belong to you and he has hundreds at your disposal, not for your ungrateful comments. So please do us all a favor and only post useful comments.

Excell,

You were right about people's comments, youtube is filled with many people like the one in question.