Budget Template for Google Sheets. In this tutorial we'll create a budget template that can be used for monthly, annual, weekly, daily, planned vs actual budget spreadsheet.
Make a copy here https://docs.google.com/spreadsheets/d/1tTMa1FJSFSqYBbVqdPtHMQWYBKn90Ae7ye3M-h23GOs/edit?usp=sharing
00:00 How this Google Sheets Budget Template Works
04:25 Setup Main Layout of Our Budget Template
08:00 Start Building the Dashboard
08:15 Date Range Picker
10:55 Actual vs Planned Block Design
12:40 Sparkline Graph
16:50 Formulas & Custom Formats for Actual vs Planned Block
26:15 Design Changes
30:20 Total Section
33:15 Conditional Sums
41:08 Sections for Main Categories in the Budget
52:04 Detail Sheets & Links from Budget Dashboard
Patreon: https://www.patreon.com/chicagocomputerclasses
One Time Donations: http://www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/
#budget #googlesheets #template