Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: http://ift.tt/2AzPPtr
Download Full Written Notes: http://ift.tt/2yu3pNs
Class web page link: http://ift.tt/2kPyedk
Topics in this video:
1. (00:01) Introduction
2. (01:24) Example 1: Mixed Cell References in Multiplication Table
3. (04:24) Song and Excel Example in High Speed
4. (05:20) How Cell References Move Throughout Copy Action
5. (07:06) Two Questions Method for Determining Which Type of Cell Reference you need.
6. (13:05) Sledge Hammer Method for Determining Which Type of Cell Reference you need.
7. (15:23) Use Ctrl + Enter to Populate a Highlighted Range with a Formula
8. (16:17) Example 3: Mixed Cell References for Budget with Income Statement Accounts
9. (24:28) Use Ctrl + Enter to Populate a Highlighted Range with an Edited Formula
10. (27:26) Example 2: Mixed Cell References & Assumption Tables.
11. (31:40) Example 4: Mixed Cell References for Retirement Savings Table
12. (37:07) Example 5: Mixed Cell References & Correct Assumption Table for Dynamic Payroll Table
13. (41:22) Two Stories about ROUND Function examples in working world
14. (43:46) Summary – Conclusion