Excel Basics #3: Formulas w Cell References

[yoshiyambao]

Getting my Excel education from this, thanks!

[Sharjeelullah]

great work, its a great help to new learners!

[ExcelIsFun]

You are welcome!

[falconhero]

this is one of the best online tutorials for basic excels.

you explained it v clearly and slowly. good job dude.

spread the knowledge =)

[ExcelIsFun]

Yes, spread the knowledge to make the world a better place!! I am glad that you like the video!

[siberianfeline]

I just love your videos and the enthusiasm you have. Thank you so very much. It helps so much.

[ExcelIsFun]

You are welcome so much!

[jsvihla]

Humanity benefits from your existence.

[ExcelIsFun]

Thank you! I am glad that you like the videos!

[yasasrd1234]

this is awesome dude...

[ExcelIsFun]

I am glad that you like it!!!

[fuckstephen213]

i hate your voice

[matt61234666]

thanks this helped lots

[ExcelIsFun]

You are welcome!

[gjonesii]

Thanks a million. Super USEFUL. I really love your enthusiasm.

[ExcelIsFun]

You are welcome!

[stevedamico]

How do I reference the data which was generated via formula on one sheet to another sheet in a formula on that sheet?

[ExcelIsFun]

Try this video:

Highline Excel Class 06: Worksheet & Workbook References

[qodir]

I appreciate your dramatic help for the society!

[ExcelIsFun]

You are welcome!

[RevealUsYourLove]

so what's the shortcut key for E2:G2 to $E$2:$G$2 again?

[ExcelIsFun]

F4 key!

[RevealUsYourLove]

@ExcelIsFun Thank you.

[ExcelIsFun]

You are welcome!

[mdwaqas]

very well done mate....keep it up....

[ExcelIsFun]

I am glad that the videos help!

[TheKeira83]

these videos r great, u r a great teacher, beside u have a great voice..

[ExcelIsFun]

I am glad that the videos help!

[risingsunemployee]

i have learnt excel fundamental within 2 hours .thanks a lot...yours are the best at this subject,,,Great job man...

[ExcelIsFun]

Great - I am glad they help with the fundamentals!

[TXRider]

I'm doing this exactly like it says, but when I enter 3000, I get 2, 732.25 ..and E2 didn't change.

[ExcelIsFun]

Where are you entering 3000?

[TXRider]

@ExcelIsFun Cell B2

[ExcelIsFun]

There is a formula in cell E2, so maybe you have the calculation set to "Manual". To Change it, go to Calculation group in Formula Ribbon.

Also, check to see if formulas are in the other cells (like E2 and F2).

[atbondoc]

hey are your excel video tutorials available for download? like in torrent or something?

[ExcelIsFun]

People do download them, but I do not know how. Try a google search. I think there is something called 'YouTube Downloader".

[sheylle21]

crystal clear explanation... thanks

[ExcelIsFun]

You are welcome!

[rickxfe]

You are the best!!! Your explanation is very simple and clear, you helped a lot.Thanks

[ExcelIsFun]

You are welcome!

[WAFINIAZI]

It's great! You are doing an amazing job. I like all your short cuts.

[ExcelIsFun]

I am glad that you like them!

[ize0017]

This is a life saver! You're freakin amazing and not boring!

[ExcelIsFun]

I am glad that the video helps!

[msloveloveloveable]

i am loving this!!

these excel videos are of great help! Thank u!!

[ExcelIsFun]

You are welcome!

[OsOg16]

@ExcelIsFun

Thank You very very much Sirrrr

[ExcelIsFun]

You are welcome!

[Amarulence]

Teach a man to fish and he... you know the rest of it.

Thanks.

[ExcelIsFun]

I think the new verison is:

Teach a human Excel and they will have in easier time getting and keeping a job and will be happier...

[xdayz]

thank you! you are a big help.

[ExcelIsFun]

You are welcome!

[odoc01]

Hi!

I'm trying to create a formula in which I'm finding the sum of the previous value + a given constant. Say my given constant is on E3. What would my formula be?

Thanks!

[ExcelIsFun]

Try this video:

Excel Basics #8: Cell References Relative & Absolute

That should help you to build your formula!

[odoc01]

@ExcelIsFun awesome thanks!

[ExcelIsFun]

You are welcome!

[impatientp]

I take it back... it must just be how you speak

[ExcelIsFun]

Sorry about that! I'll try to do better next time!

[icemantet]

thank you very much.you help a lot lof people on doing this.keep up the good work

[ExcelIsFun]

You are welcome very much!! Helping people is good.

[fahadsaeed50]

good job thanks for uploading

[ExcelIsFun]

You are welcome!!

[amycecillau]

by the way, dancing ants, LOL! you took the excel phobia out of all of us. Thanks.

[ExcelIsFun]

I am glad that the dancing ants can take the Excel phobia and throw it out the door!

[gastonytHQ]

Ctrl + D

and

Ctrl + R

also help as quick Formula Copy.

[ExcelIsFun]

Those are awesome keyboard tricks for when the range is highlighted!

[thirthyest]

how about =SUM(-E2,B2)

instead of =B2-E2

:)

[ExcelIsFun]

Both do work, but it takes more keys to enter:

=SUM(-E2,B2)

than it does to enter:

=B2-E2

Fewer keys = saved time.

But if you learned spreadsheets back in the days of Lotus and VisiCalc, you probably learned to do all formulas inside the SUM function.

[jelu95]

Hi could you tell me please how can I append properties to a cell. If I have a formula in a cell which will make the word WARNING appear, how can I make that word appear in a different cell colour, font and size) How can the formula be instructed that these changes appear on the word when its suppose to pop up. Thank you

[ExcelIsFun]

Watch this video title for how Conditional Formatting works:

Highline Excel Class 21: Conditional Formatting 12 Examples

Then if warning is in cell A1, the TRUE/FALSE formula you want in the Conditional Formatting dialog box is:

=A1="WARNING"

[slaves2sin]

great i learned the shift + enter to go up

[ExcelIsFun]

Dear slaves2sin,

Yes, Shift + Enter is a great one, if you like keyboard shortcuts!

--excelisfun

[maesbrit]

Wow, I think I get it now, lol. Thanks! The downloadable worksheets made the difference. I will be passing this page on the other students!

[ExcelIsFun]

Dear maesbrit ,

EXCELlent! I am glad that it helped. Did you download my free book too? It has some great pages about cell references and formulas.

--excelisfun

[coolshit28]

Thanks dude - very helpful!!

[ExcelIsFun]

Dear coolshit28 ,

I am glad that they are helpful!

--excekisfun

[Indierkgrl]

thank YOU, this was amazing :)

[ExcelIsFun]

Dear Indierkgrl,

You are welcome!

--excelisfun

[klmukesh]

thank you very much for sharing it with all of us

[ExcelIsFun]

Dear klmukesh ,

You are welcome!

--excelisfun

[Baobao531]

Bravo.

I like it.

[ExcelIsFun]

Dear Baobao531,

I am glad that you like it!

It saves a lot of time (compared to a calculator), if you know some Excel!

--excelisfun

[macyomi]

i must show appraciation for the amount of work you have put into providing valuable knowledge for us. many thanks.

[ExcelIsFun]

Dear macyomi,

You are welcome! I am glad that you find the knowledge valuable (and hopefully fun)!

--excelisfun

[Accountant2009ca]

Before I found your videos, I had little to no knowledge of Excel. Now my confidence is growing with each video. This is precious information-uncomparable to other video tutorials on YouTube.

[ExcelIsFun]

Dear Accountant2009ca,

Thank you! I am happy that the videos are helpful!

--excelisfun

[islamic22flower22ksa]

many thanks

[ExcelIsFun]

Dear islamic22flower22ksa,

Many "no problems"!

--excelisfun