Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
This video is the first in the Budget Makeover series, where we take a simple budget template and make it more robust.
The series will teach you how to create a budget template that has dropdowns, locked cells, formulas, and an interactive dashboard with pivot tables and pivot charts for your personal or workplace budgeting needs.
This first video details how to lock particular cells on a worksheet and protect the entire worksheet so that unwanted changes cannot be made.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/tips/budget-makeover-1-lock-cells/
Related Videos:
How to Lock Cells for Editing and Protect Formulas: https://www.excelcampus.com/tips/lock-cells/
Actual vs Targets Chart in Excel: https://www.youtube.com/watch?v=E5JTaRJ9VpY&t=52s
Running Totals in Excel Tables - The Easy Way: https://www.youtube.com/watch?v=PGlBfr5SeEA
#MsExcel #excelcampus
00:00 Intro
01:44 Lock Cells for Editing
05:30 Bonus Tip