Excel Basics #11: Spreadsheet Setup & Cell References

[Darienbeagle]

great video, as always

[ExcelIsFun]

I am glad that you liked it!

[Mitsu2040]

at 7:45: how does it know to grab all the numbers above and not the ones on the left?

[ExcelIsFun]

It looks for numbers.

[Mitsu2040]

@ExcelIsFun another question: at 2:18, why is it a " * " in the formula instead of " - " or " / "?

[ExcelIsFun]

* is multiplication.

[Mitsu2040]

@ExcelIsFun so you multipli the gross pay to the deduction?

[ExcelIsFun]

Yes.

[Mitsu2040]

@ExcelIsFun Ok, thanks for clarifying that, I would've thought you had to use minus instead.

[ExcelIsFun]

It's tax. Gross*TaxRate.

[marcoholic22]

this is great! :)

[ExcelIsFun]

I am gld that you liked it!

[QQQQQman]

Brilliant - thank you - these are perfect!

[ExcelIsFun]

You are welcome!

[soconnie]

My teacher played all videos in the basic series to us twice 'cause he can't explain Excel as clearly

[ExcelIsFun]

Cool!

I am glad that the videos help!!

[ExcelIsFun]

Cool! I am glad that the videos help!

[douginamerica]

Great video. Thanks!

[ExcelIsFun]

You are welcome!

[hoosni]

Hi, ExcelIsFun. Thank you very much for the good you are doing. Very useful, learning much from the basic series. Regards from Tokyo.

[ExcelIsFun]

You are welcome!

[chinchonchinchon]

Excelfun, you are indeed the greatest FUN teacher I've ever come across!

Thanks for posting these series which makes learning fun, which is something it ought to be FUN, and also explaining difficult things and helping many of us overcome fear which is something that incredibly keeps many of us from learning new things.-

Again, thanks! :-)

[ExcelIsFun]

You are welcome!!!

[ExcelIsFun]

Are you talking about the keyboard shortcut for ther SUM function:

Alt + =

[acon1907]

@ExcelIsFun

I was consistently trying use the function by pressing + instead of =. Now I got rid of the problem. Thanks again for your great exertion.

[acon1907]

Thanks again, this is the second time I am watching this series. I realized again that this is a very useful series. Unfortunately, this time I had some difficulties about applying the things explained. I changed my computer and I installed excel again, but now I can't use the alt equals function. (alt+shift+4) What can be the reason of it?

[sermex2002]

Great videos!!!

I have a question, is there a way to prepare a spreadsheet when you get the information vertical, like this

Jan

Feb

Mar

But you need it orizontal?What is the easiest way to change it? is there a formula that can help me to relocate or change from vertical to orizontal?

Thanks

great videos!!!

[ExcelIsFun]

3 ways to transpose:

1) Function, see this video:

Excel Array Formula Series #2: TRANSPOSE function

2) Formula, see:

Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

30 For copy / paste special see 14:00 minute mark of this video:

Highline Excel Class 28: More Excel Basics Review

[sermex2002]

Hey!!! great!!! I saw the Excel Array Formula Series #2: TRANSPOSE function

video and it works perfect!!!

Thanks a lot for your help!!!

[gastonytHQ]

don't forget u can select a range and overlook at the lower status bar and you'll automatically see the sum (if option is selected and being used. Right click, on status bar, to open 'selection prompt')

[chrisiane05]

thank you for this video. my boss really dropped his jaw! haha!

[ExcelIsFun]

You are welcome!

[briggs9187]

f'ing amazing, I always thought my self as Excel proficient but you made me feel like a newbie...lol....thank you, i am following along with all your lesons

[ExcelIsFun]

EXCELlent!!! I am glad that this Excel videos Series helps! After this Series, you should watch the Highline Excel Class Series - it has 5 times the content of the Basics Series!

[thirthyest]

i loved this one a lot

thank you so much again for posting these:)

doina

[ExcelIsFun]

You are welcome so much!!

[lubenitza2004]

I am learning excel from you:D Thanks aloooot!!!!

[ExcelIsFun]

Dear lubenitza2004,

You are welcome alooottt!!

--excelisfun

[slaves2sin]

yeah Crtl enter is hard getting used to.

sum function with range. right. gotit.

[ExcelIsFun]

Dear slaves2sin,

Great! As you accumulate more Excel Efficiency Tricks, you will be able to do more stuff done faster!

--excelisfun

[chippendails]

super!!!!!

[ExcelIsFun]

Dear chippendails,

I am glad that you liked it!

--excelisfun