Excel Basics #11: Spreadsheet Setup & Cell References

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#11 Video topics:
1)Mixed Cell References, Assumption Table Orientation, Range Functions and Inserting columns
2)Mixed Cell References in Formulas and the orientation of the Input Values
3)Formula Input Value setup is critical for efficient formula creation
4)The beauty of Excel is illustrated in this video: Amazing Efficiency example
5)Spreadsheet set up leads to time saved

Category:

Science & Technology

Tags:

• Excel
• Mixed
• Cell
• References
• spreadsheet
• setup
• Range
• Functions
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Darienbeagle]

great video, as always

[ExcelIsFun]

I am glad that you liked it!

[ExcelIsFun]

It's tax. Gross*TaxRate.

[Mitsu2040]

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

[ExcelIsFun]

Yes.

[Mitsu2040]

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

[ExcelIsFun]

* is multiplication.

[Mitsu2040]

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

[ExcelIsFun]

It looks for numbers.

[Mitsu2040]

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