Excel Basics - Mixed Cell References - The Number One Trick to Creating Formulas Quickly

This course teaches mixed cell references in Microsoft Excel to create and copy formulas efficiently across tables. Examples cover multiplication tables, budgets, assumption tables, retirement savings, payroll, and rounding formulas.

Syllabus

) Introduction.
) Example 1: Mixed Cell References in Multiplication Table.
) Song and Excel Example in High Speed.
) How Cell References Move Throughout Copy Action.
) Two Questions Method for Determining Which Type of Cell Reference you need..
) F4 key as Merry-Go-Round.
) Sledge Hammer Method for Determining Which Type of Cell Reference you need..
) Use Ctrl + Enter to Populate a Highlighted Range with a Formula.
) Example 3: Mixed Cell References for Budget with Income Statement Accounts .
) Use Ctrl + Enter to Populate a Highlighted Range with an Edited Formula.
) Example 2: Mixed Cell References & Assumption Tables..
) Example 4: Mixed Cell References for Retirement Savings Table.
) Example 5: Mixed Cell References & Correct Assumption Table for Dynamic Payroll Table.
) Two Stories about ROUND Function examples in working world.
) Summary - Conclusion.