Office 2016 28

Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!

DESCRIPTION

Topics in this video:
(00:01) Introduction
(01:24) Example 1: Mixed Cell References in Multiplication Table
(04:24) Song and Excel Example in High Speed
(05:20) How Cell References Move Throughout Copy Action
(07:06) Two Questions Method for Determining Which Type of Cell Reference you need.
(08:58) F4 key as Merry-Go-Round
(13:05) Sledge Hammer Method for Determining Which Type of Cell Reference you need.
(15:23) Use Ctrl + Enter to Populate a Highlighted Range with a Formula
(16:17) Example 3: Mixed Cell References for Budget with Income Statement Accounts
(24:28) Use Ctrl + Enter to Populate a Highlighted Range with an Edited Formula
(27:26) Example 2: Mixed Cell References & Assumption Tables.
(31:40) Example 4: Mixed Cell References for Retirement Savings Table
(37:07) Example 5: Mixed Cell References & Correct Assumption Table for Dynamic Payroll Table
(41:22) Two Stories about ROUND Function examples in working world
(43:46) Summary – Conclusion

NOTES

WORKBOOKS

Download “Office 2016 Video 28” EB16MixedCellReferences.xlsm – Downloaded 12 times – 1 MB







Be the first to comment

Leave a Reply