Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2AzPPtr
\nDownload Full Written Notes: http:\/\/ift.tt\/2yu3pNs
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (01:24) Example 1: Mixed Cell References in Multiplication Table
\n3. (04:24) Song and Excel Example in High Speed
\n4. (05:20) How Cell References Move Throughout Copy Action
\n5. (07:06) Two Questions Method for Determining Which Type of Cell Reference you need.
\n6. (13:05) Sledge Hammer Method for Determining Which Type of Cell Reference you need.
\n7. (15:23) Use Ctrl + Enter to Populate a Highlighted Range with a Formula
\n8. (16:17) Example 3: Mixed Cell References for Budget with Income Statement Accounts
\n9. (24:28) Use Ctrl + Enter to Populate a Highlighted Range with an Edited Formula
\n10. (27:26) Example 2: Mixed Cell References & Assumption Tables.
\n11. (31:40) Example 4: Mixed Cell References for Retirement Savings Table
\n12. (37:07) Example 5: Mixed Cell References & Correct Assumption Table for Dynamic Payroll Table
\n13. (41:22) Two Stories about ROUND Function examples in working world
\n14. (43:46) Summary – Conclusion<\/p>\n