Excel Magic Tricks # 1: Formulas & Cell References

[Ultimist]

Is there a way to convert the contents of a cell to a cell reference? For example, if I have a numeric 3 in column a1, is there a way I can use that 3 with the letter f to represent cell f3 in a formula? Thanks!

[ExcelIsFun]

@Ultimist , try this formula:

=INDIRECT("F"&A1)

[ThePupidarko]

Thank,thanks,thanks a LOT!!!!!!!!!!

[Fishes1971]

When i get to the F4 Bit my computer does not understand???

[55YuanYuan]

Thanks a lot, you are amazing

[ExcelIsFun]

You are welcome!

[55YuanYuan]

Where to download ？ I cannot find it. I would appreciate it if you tell me the link.

[ExcelIsFun]

people.highline.edu/mgirvin/Ex­celIsFun.htm

[alwayzsic]

why angry rabbit?

[ExcelIsFun]

Microsoft calls it the "Cross Hair" and in English cross = angry and hair = rabbit, so I was just trying to be funny.

[kannoosh69]

Is it possible to generate a serial number in excel, in a single cell that is updated/rolled on, each time the form is used?

I have got it down to rolling on by 1 digit daily, by subtracting one date from another, but I can't figure out how to generate the number more than once a day.

Basically, this form will be used for dispatching goods out through stores.

Thanks in advance.

[ExcelIsFun]

I do not know. Try THE best Excel question site:

mrexcel[dot]com/forum

[asimbaigb]

@ExcelIsFun

WOW



[ExcelIsFun]

Thanks!

[appleboycat123]

grateful from India

[ExcelIsFun]

I am glad that the video helps!

[ianubc]

Hi, your videos are awesome,

I have a question,

how can i make a list so that if i choose a specific value from that list it modifies another cell (choosing a value from another list) (from the same workbook or different)

thanks very much

[ExcelIsFun]

I do not know, Try THE best Excel site around for questions:

mrexcel[dot]com/forum

[aliakbaraidid]

Awsome presentation. Thanks a lot.

[ExcelIsFun]

You are welcome!

Try searching for excelisfun, then click on the link for the CHANNEL, then you can find over 1000 other how-to-Excel videos!

[cokeacola]

hey im still unclear what a cell references and what they do

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[ExcelIsFun]

Search and watch these video titles:

Excel Basics 3: Formulas w Cell References

Excel Basics 8: Cell References Relative & Absolute

Excel Basics 9: Mixed Cell References in Formulas

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[ExcelIsFun]

Search and watch these video titles:

Excel Basics 3: Formulas w Cell References

Excel Basics 8: Cell References Relative & Absolute

Excel Basics 9: Mixed Cell References in Formulas

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

[ExcelIsFun]

Search and watch these video titles:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative Absolute

Excel Basics #9: Mixed Cell References in Formulas

Excel Cell References 15 Examples Formulas, Conditional Formatting Data Validation



[ExcelIsFun]

Search and watch these Excel Basic videos that I made about cell references:

Excel Basics 3

Excel Basics 8

Excel Basics 9



[ExcelIsFun]

YouTube will not let me post the names of the videos I would like to suggest, so I am e-mailing you

[ExcelIsFun]

YouTube will not let me post ...

[ExcelIsFun]

YouTube will not let me post ...

[ExcelIsFun]

YouTube will not let me post ...

[ExcelIsFun]

YouTube will not let me post ...

[ExcelIsFun]

YouTube will not let me post ...

[ExcelIsFun]

Search for and watch my videos about cell references:

Excel Basics #3: Formulas w Cell References

Excel Basics #8: Cell References Relative & Absolute

Excel Basics #9: Mixed Cell References in Formulas

[MrsTuber25]

i learned a lot in no time

[ExcelIsFun]

I am glad that it helped. Search for 'Excel Basics' and "Highline Excel Class', I have those two Excel series that have even better videos than this one (I made it 2.5 years ago).

[kkavitarani]

The excel sheet is not clear to watch what is happening

[ExcelIsFun]

Yes, I am sorry about that. I made this video 2.5 years ago. Since then I have made over 1000 more and they are much better after the first few ones that I made. Search For 'Excel Basics' or 'Highline Excel Class' and you will find in those series about 70 clear Excel videos.

[allstar970]

you know, not in the spirit of hate mail, but I'm glad you subdued your unbridled enthusiasm a bit (could be subdued further still). enthusiasm is a good thing, but listening to a voice with too much of it, for a period of more than 10 seconds, is usually extremely aggravating for most people over the age of 5. great videos though!

[abraef50]

how to get to your channel to download the videos

[ExcelIsFun]

Search for and watch this video title:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

Then you can see how to find all my videos from #1 to #1218!! All about Excel!

[partylikepacman]

Dude you are awesome!!

[ExcelIsFun]

I am glad that it helped! Search for and watch this video title to learn how to find any Excel video that you want from the excelisfun channel:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[hsajid307]

Hi Sir Thank you Very much for your videos for excel this is really beneficial for hundreds of thousand poeple in the world.

My question is this how can I have these excel file? however I have videos but I like excel (Excel 2007) file kindly help me if it is possible. I searched in google but could not.

[ExcelIsFun]

Search for and watch this video title (shows how to download file):

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[dariofuentes]

Keep on going. The enthusiam along with your knowledge is what makes your videos unique. Five stars to you

[ExcelIsFun]

I am glad that you like the video. I made this video over 2 years ago. Since, I have posted over 1000 others! To see how to use this excelisfun channel and find the videos that you want, search for and watch this video title:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[MESSER8989]

I must ask what your job is. Your expertise is excel surely extends past YouTube. What kinds of benefits do you receive from knowing the buisness world's most popular tool? It must be high paying.

[ExcelIsFun]

I am a teacher.

This video you watched is the first YouTube video that I made - since then I have made 1100 more!

I am glad that the videos are helpful!

[MESSER8989]

I've noticed. I learned a lot from your videos, such as the countif function. Because of your videos I can confidently say that I am an expert at excel. One of your videos helped me with my statistics course. I would have never have found the data anyalsis tool w/out that video. So thank you. By the way, what happened to your enthusiasum in the later videos. It was entertaining.

[ExcelIsFun]

The enthusiasm should still be there, it is just more subdued. I got too much hate mail and so I toned it down!

[liuqibat]

This is great. i have learnt something from you. I think I will watch the rest of the videos of yours. :-)

[ExcelIsFun]

Search for and watch this video to see how to use the excelisfun channel:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

This video shows playlist. If you like the videos the best two playlist series are:

Excel Basics

Highline Excel Class

[Jman9800]

4:13 LOL!

[ExcelIsFun]

I hadn't seen this video at 4:13 in about 2 years. That noise is funny.

I just tried it on my computer and it did not work! ;)

[Keydo7]

Thanks a lot. This really helped.

[ExcelIsFun]

You are welcome!

[sumittailong]

hello Sir,

I want to download your excel function file can u please give me your website address so that i can download it from there.

[ExcelIsFun]

Search YouTube for "excelisfun", then look for the channel link, then go to the excelisfun channel, then a video will automatically play at the excelisfun channel that shows how to download the files.

YouTube does not let us post web addresses in the comment section.

[Mynotoar]

Wow. The beginning of the Excel magic :). The dawn of a new era that brought Excel to YouTube in a glorified MikeGirvinesque way.

Good old Excelisfun :). A service to YouTube. I assume you're a YouTube partner? I'd be surprised if you weren't, you have all the hallmarks of an eligible partner.

[ExcelIsFun]

Yes, I am a partner, but I have no ads and take no ad revenue (to keep it pure).

Be careful of Excel magic tricks 30 - 80 and YouTubers Love Excel 1 - 20, because I was a little over the top in terms of enthusiasm - I got lots of hate mail during those, and so I toned it down since then...

[Mynotoar]

You got hate mail?! Blimey! I'd have to check those vids to see what it is that made anybody do such a thing.

[ExcelIsFun]

Yes, people called me some pretty bad things and some funny things like:

a hip-hop chipmunk

a first grade teacher that talks down to people

an unprofessional teacher...

[Mynotoar]

Blimey, who could do such a thing! Are we not even allowed to be enthusiastic anymore? Has YouTube become such a war zone for trolls, political and religious flamers, spammers and haters that nobody allows a positive attitude to go by anymore? What has YouTube come to ...

[ExcelIsFun]

Ananimity makes the human pattern of meanness worse online.

Meanness is usually learned (not always).

Kindness is innate in humans (just because we all just want to be loved).

[shiryu008]

hi mike, To much time i've seen you videos! i was in holidays and i traveled to differents cities!. But now i'm back. one cuestion: ALT+F1 inserts the defaults chart. ?how can i change the default chart to another new one?.

Thanks.

[ExcelIsFun]

Dear shiryu008,

I'll make a video later in th week. There are two ways, and the best way takes a bunch of clicks and saving as a template.

More later...

--ExcelIsFun

[wangansel]

could you give the link of downloading those sheets? thank you

[ExcelIsFun]

Dear wangansel,

I would if I could, but YouTube does not allow you to paste a link in the comment section.

If you want to download the workbooks, click on the "ExcelIsFun" blue link on the right side of any one of the videos. Then scroll down the ExcelIsFun channel web page, and near the bottom is a blue link that gets to the web page where you can download the workbooks.

Also, watch the How To video at the channel - it will show you!

If you still have trouble, let me know!

--ExcelIsFun

[shiryu008]

ok, my last video for this night. 17 videos its a record!. Lookup functions where very usefull. I want to realy understand how excel works and thanks to your videos, i'm sure i'm gona make it.

good night Mike.

[ExcelIsFun]

Dear shiryu008,

New world record!!!!

--ExcelIsFun

[itsmesajjad]

Dear your all vedios are really helpful and have no words to thank you.... keep comming....

[ExcelIsFun]

Dear itsmesajjad,

I am glad that they help!! You can say thank you each time you watch by rating the videos how you see them!!!

I'll keep them coming!

--ExcelIsFun

[poeticlinds]

You are the best. Somedays I dont know what I would do without you. It is so easy to learn from your video and hands on down loads keep em coming. Thanks again

[ExcelIsFun]

Dear poeticlinds,

I am glad that this helps - that is why I do this! If you keep watching and rating, I'll "keep em coming"!!!!

Does this help with your work, or with stuff at home?

--ExcelIsFun

[LiDeBe]

You are great!!!!!!

You explain it very well and I have learned sooo much from you. Thanks you!!!!

[ExcelIsFun]

Dear LiDeBe,

You are welcome! If you keep watching, I'll keep making videos!!!

--ExcelIsFun

[yazz1985]

dude i LOVE YOU! you have helped me soooo much dude...i HONESTLY appreciate it, you are my HERO! thank u sooooo much!

[ExcelIsFun]

Dear yazz1985,

I'll keeping making more videos!!

--ExcelIsFun