Excel Lesson 03: Cell Referencing and What-If Analyses in Microsoft Excel

This video is intended for people who want to learn about cell referencing and how to conduct a what-if analysis in Microsoft Excel. Topics covered in this lesson include relative cell references, absolute cell references, mixed cell references, the difference between functions and formulas, and conducting a what-if analysis in Excel. You may jump to any of these topics by using the links below:

1. Cell referencing: (1:07)
2. Relative cell references: (1:25)
3. Absolute cell references: (4:02)
4. Mixed cell references: (7:28)
5. Functions vs. formulas: (10:08)
6. Conducting a what-if analysis: (11:49)

[JenniferTruong]

For anyone with newer laptop models, you would have to press the FN key + F4 key at the same time for absolute/mixed cell referencing to work :)

[camilo]

I can't explain in words how wonderful this video is

[cacjuice]

What is the name of that song starting at 52 seconds?

[orfacartagena]

from where the 20 in the formula comes from?

[rahulthakrar]

Hi Dr. Soper, Thank you so much for these videos. We're using them for our class. I just have one question. I don't understand where the 20 comes from in equation that you setup for customers per night? I've been trying to figure it out for the past two days, but can't seem to figure it out.

[vanessagarza]

If I want to convert expenses from percentage to dollar amounts how is that done. I need to create a what if analysis professor provided income but expenses were giving in percentage and we need to concvert those into dollar amounts or basically just get the expense amount. I hope you can help :) Thank you Dr.

[damita]

Good Day! Dr, Soper.
Can I ask you a question? I'm gonna ask about Entrance fee how come its written by dollar signs and - I just typed all of these on excel so I don't have idea how it's gone.