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

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

ExcelIsFun via YouTube Direct link

) Song and Excel Example in High Speed

3 of 15

3 of 15

) Song and Excel Example in High Speed

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

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

Automatically move to the next video in the Classroom when playback concludes

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.