Highline Excel Class 03: Names, Cell References, Formula Inputs

[gemmation]

I'm loving all your videos, and I'm in awe of how many hours of work you've put in.

I have one small criticism of the workbooks I've downloaded so far. They aren't fully "reset" to match the condition of the workbook at the start of the video. E.g. in this one, the cell ranges are already named "Data" and "Car_Types" etc, and the assumption tables often contain the figures you end the video on. I feel very rude pointing this out, and will end by saying that I just ordered your book yesterday.

[ExcelIsFun]

@gemmation , I am sorry. I will try to do better next time.

Maybe you did not download the correct workbook. There are two for each chapter. For example:

Week1Busn214StartFile

and

Week1Busn214FinishedFile

Try the start file.

[gemmation]

@ExcelIsFun It's the start file I'm talking about. I re-downloaded it to check. But... it's not a big deal, and the fact that you've got literally hundreds of workbooks to download for free and learn from far outweighs the odd glitch. ;)

[ExcelIsFun]

@gemmation , is it the whole workbook? or just one sheet?

[ExcelIsFun]

@gemmation , I just checked the Start file for Week 1 Highline Excel Class and it looks like it is NOT completed: meaning, the start file really is a start file.

[gemmation]

@ExcelIsFun It's just a couple of things that aren't reset, not the whole workbook.

E.g. go to the name box. It lists, Car_Type, cute, Data, Price, so you have to delete these first if you want to practice naming the exact same things you do at the start of this video. The assumption table about boomerang sales in the start file matches the video at 33m, rather than at 27m40s where you first introduce it. As I said, just small things, not disasters by any stretch of the imagination!

[ExcelIsFun]

@gemmation , Thanks! I fixed it and re-posted. I hope that helps!

[hersheng18]

very intellegent. thanks for this

[ExcelIsFun]

@hersheng18 , you are welcome!

[KrystalFoshizzle]

You are amaaaaaaazing. You're like a robot, but better! o.o Cuz you repeat things and you force understanding while still making it fun. And you're really engaged in your videos, I feel like you're talking to me directly sometimes. And you're patient enough to name every move you make! So there's absolutely nothing to get confused about. Just wow.

[ExcelIsFun]

@KrystalFoshizzle , thank you for the kind words! I am glad that you like the videos!

[ExcelIsFun]

@KrystalFoshizzle , cool! I an super glad that you find the video useful!!

[Chillerbill]

has been a year since last time I watched your vids, still love you dude! btw what is the CTRL + ENTER button for excel 2004 mac? any idea?

[ExcelIsFun]

@Chillerbill , sorry, I do not know how to use a MAc...

[Ifrite]

at 08:13, you have a function called COUNTDIFF in your formula drop-down list. Where did you get that function? I dont have it in either my 2007 or 2010 excel.

[ExcelIsFun]

See this video:

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

I also have a playlist with a few videos about some of these functions.

[Ifrite]

@ExcelIsFun You are an EXPERT!

[ExcelIsFun]

I am glad to help!

[Ifrite]

@ExcelIsFun Thanks a lot.

[ExcelIsFun]

You are welcome!

[kohatian114]

Wonderful Mike,watching your videos really made excel fun to me.I watched your videos and made every student at my home to watch and learn and discuss .learned a great deal from excel but now i want more.

Could you guide me to a site where I can get exercises to do as a projects and tasks to enhance and practice what you have shown to us in videos to learn in the real manner?

Thanks Again.

[ExcelIsFun]

Currently, I do not have a site like that, but I have a new book with downloadable files for practicing, but it may be a few months before it is out...

[6rbtube]

thank you very much

we love you

[ExcelIsFun]

You are welcome very much!

[SuperRobinsont]

preparing for my vendor exam - very helpful

[ExcelIsFun]

I am glad that it helped!

[Wellingtonjr]

Very excelent Classes man, I hope i could do as good as you..

Congratulations

[ExcelIsFun]

I am glad that you like the videos! Study a lot and you will be better than me!!

[shiryu008]

Hi Mike.

As always a superb job.

Cuestion: have you a number in mind of how many excell videos are you planning to do?

And what about other MS office tools like word or Power point? that would be tremendous!. I'am an egoist right :).

Thanks, Keep Exceel-youtubing us!

[ExcelIsFun]

I do not have a number in mind. But as long as I still have ideas and it is still fun, I;ll keep making them.

Probably no other MS non-Excel videos, though.

[thrylos32]

high class videos, ty

[thuynguyenable]

Excellent lesson & Excellent Instructor.

Thank you for sharing.

[ExcelIsFun]

You are welcome!

Thanks for the EXCELlent comment!

[DeoKorneo]

Mike, your work is absolutely brilliant. Thanks for spending the time making the videos and letting us newbies access it so freely and easily.

Just a selfish question: It looks like you cover nearly everything in all your videos, could you advise if there is something that might be useful which you haven't covered, for example the vb side, or others?

Many thanks once again.

Excel is indeed lots of fun!! Well, at least you make it fun!

[ExcelIsFun]

Yes, I do not cover VBA. The best video series for VBA is by Mr Excel, but it is not free. However the 49 bucks for his VBA series is well worth it:

mrexcel[dot]com

[lexingtonlp]

Thank you very much! Awesome video.

[ExcelIsFun]

You are welcome!

[Gilllionaire]

Thank you !

[ExcelIsFun]

You are welcome!

[154song]

Mike,

I use a named table for a bank recs file. On my bank download I use VLookup to return issued cks cleared the same month from a named table (w/ck #s and $) of the GL download. Then I code the cleared checks issued the same month "a" and "e" for cleared checks issued prior months. After that, another vlookup bringing "a" from bank file to GL file to determine the outstanding list. When I sort the coded GL file the range of the NAME is shifted. Any better ways to handle it?

Thanks.

Swei

[ExcelIsFun]

That sounds great to me!!

Good work!

[thirthyest]

i have a question on countif/s

so

COUNTIF(Car_Type,F6)+COUNTIF(C­ar_Type,G6) equals 72

then why this one does not work

=COUNTIFS(Car_Type,F6,Car_Type­,G6) (equals 0)

prolbably because i did something wrong but what :))

[ExcelIsFun]

COUNTIF(Car_Type,F6)+COUNTIF(C ar_Type,G6) is saying add the F6 criteria first, then add the G6 criteria second (and separately), then add.

=COUNTIFS(Car_Type,F6,Car_Type ,G6) is saying find the records that are both F6 criteria and F6 criteria at the same time.

[thirthyest]

now i get it, thank you :))

[ExcelIsFun]

EXCELlent!! Getting it is great!

[cindywuzh]

Thank you so much for sharing your teaching with us!

[ExcelIsFun]

You are welcome!

[CHAMPAGN3SUP3ERNOVA]

oh man im using a mac and excel 08 so i can's use some of your shorcuts.

[ExcelIsFun]

Dear CHAMPAGN3SUP3ERNOVA ,

There is a setting in theOptions that will allow you to use PC shortcuts.

--excelisfun

[MmansoorM]

Great tutorial because of great teacher.

Where can I find this in your website (flightline. highline. edu/ mgirvin/ ExcelIsFun. htm) ? I mean in Xls format. Thanks again for your tutorials.

[MmansoorM]

Your website is not working....

[MmansoorM]

Now it is working.

[ExcelIsFun]

Dear MmansoorM,

Yes, YouTube has been having trouble lately...

--excelisfun