IMPORTANT
This template will only work with the Office 365 version of Microsoft Excel.
In this video, I teach you how to create a fullfledged habit tracker in Microsoft Excel! That way, you can track any number of habits over the course of the entire year.
And what's really amazing about this template is that it comes with a fullyautomated dynamic dashboard that operates without the use of any macros or pivot tables.
Are you ready to push your Microsoft Excel skills to the test and build this incredible template all the way from scratch? If so, then get ready because this is going to be quite a ride!
LINK TO TEMPLATE
If you don't want to build it, you can purchase this template instead!
https://spreadsheetlife.com/templates...
RESOURCES
Spreadsheet Templates: https://spreadsheetlife.com/templates/
The Spreadsheet Life Blog: https://spreadsheetlife.com/blog/
LEARN EXCEL OR GOOGLE SHEETS
https://spreadsheetlife.com/allcourses/
MUSIC TRACK
Track: Ikson Balance [Official]
Music provided by Ikson™
Listen: • #122 Balance (Official)
TIMESTAMPS
00:00 Intro
01:43 Setup the Worksheet Structure
02:56 Create the Worksheet Copies
03:45 The Habit List
05:45 Build the Month Worksheets
14:55 Complete the Habit List
19:03 The Calculations Worksheet
28:19 The Dashboard Worksheet
34:53 Complete the Calculations
43:55 Complete the Dashboard
52:20 Conclusion
52:55 Outro