Write Better Excel Formulas with Cell Referencing & Locking

Learn how cell referencing and cell locking can make writing formulas in Excel faster and more efficient. In this video, I break down the various cell locking techniques and explain the various types of cell referencing in Excel in a simple practical way so you can build better formulas with confidence. Aside learning how to do this, you will also be learning additional knowledge on how excel works. Enjoy! Download the sample file used in the video here: https://docs.google.com/spreadsheets/d/1ucMFku0vEKkPDUchZFb8JKXo3Zvuqwvy/edit?usp=sharing&ouid=109573521158191918654&rtpof=true&sd=true -----------Timecodes 0:00 - Intro and overview 2:03 - Unlocking the Row and the Column 8:45 - Locking the Row and the Column 11:54 - Unlocking the Row and Locking the Column 15:30 - Locking the Row and the Column 20:53 - Practice Example 1 24:56 - Practice Example 2 29:49 - Practice Example 3 33:52 - How to toggle the lock easily 37:14 - Hardcoding Values 39:25 - Bonus: Calculate Running Total with Cell-Locking 43:40 - Outro --------------------------------