Excel Basics #8: Cell References Relative & Absolute

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#8 Video topics:
1)Cell references in formulas
2)F4 key to select the type of cell reference
3)Relative Cell Reference
4)Absolute Cell Reference
5)Mixed Cell Reference with column locked (Absolute Column)
6)Mixed Cell Reference with row locked (Absolute Row)
7)Fill handle double click trick for copying
8)Ctrl + Enter keyboard shortcut for entering many formulas at once
9)Formula for Percentage
10)Formula for periodic increase (increase each successive amount by 10%)
11)Formula function for Future Value

Category:

Science & Technology

Tags:

• Excel
• cell
• references
• in
• formula
• relative
• absolute
• mixed
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[amodhsinha]

great Sir thanks a toooon it was really a learning u delivered it fab

[ExcelIsFun]

@amodhsinha , I am Glad that the video helps!

[hatke159]

=82/100 should give 0.82 but how did it show 82% ????

[ExcelIsFun]

It has Percentage Number Formatting applied to the cell.

[nf255]

Thank you sssssssoooooooo much

$kiss$ u

[ExcelIsFun]

You are welcome ssssooo much!

[jefficy1]

nvm, I figured it out! THX

[jefficy1]

Hey, thank you so much!

just have a quick question, when I hold ctrl and press enter, it didnt work out for me.

It didnt show the entire numbers like you had. May I ask why?

[IWantSoundKnowledge]

great!

[Montegoman66]

Excellent! I was so confused reading this in my school text book, but you really broke it down. NOW it makes sense...Much appreciated my friend!

[ASTiGBA]

@ExcelIsFun I love you man No homo!