STEP by STEP Excel Habit trackers with Subcategories | Tutorial DYI
Вставка
- Опубліковано 27 сер 2024
- This video shows you how to build a powerful habit tracker in Excel! We'll walk you through step-by-step, from naming your tracker and defining habits to recording your progress and resetting for a new month.
Here's what you'll learn:
Customize Your Tracker: Name your tracker and personalize it with habit categories and subcategories.
Simple Tracking: No complex formulas needed! Simply enter a number to record your daily habit completion.
Visualize Progress: Track your progress over time and stay motivated!
Easy Reset: Effortlessly reset your tracker for a fresh start each month.
✅𝙂𝙚𝙩 𝙩𝙝𝙚 𝙩𝙚𝙢𝙥𝙡𝙖𝙩𝙚 𝙝𝙚𝙧𝙚
We all need a break sometimes so if you want to take a shortcut get the template here:
www.etsy.com/a...
✅ 𝙎𝙝𝙤𝙥
My new Etsy Shop
yourlifeyourpr...
🧑🎓 𝙊𝙣𝙡𝙞𝙣𝙚 𝘾𝙤𝙪𝙧𝙨𝙚𝙨
Use the coupon code UA-cam03 to get the best price
www.udemy.com/...
𝙈𝙮 𝙤𝙩𝙝𝙚𝙧 𝙔𝙤𝙪𝙏𝙪𝙗𝙚 𝘾𝙝𝙖𝙣𝙣𝙚𝙡𝙨
🎞️ Project Management & Excel for Work
/ @projectmanagementmastery
🎞️ Self Development
/ @yourlifeyourproject
NAMING THE TRACKER
- To name the tracker input the name directly in the top cell.
HABIT NAMES, GROUPS and SUBGROUPS
- input the Name of your habits. You can also input sub groups and groups as I have them there. For the vertical/merged cells for groups and subgroups, you can input them as for any other cell, they will turn vertical when you press Enter.
COUNTING OCCURENCES
- Directly in the Grid, input a number for the day and habit - any number including zero (0).
- If you input a character, it will not be counted.
- It does not matter if you input 0, 1 or 9, it will only count as an occurrence.
RESETTING THE TRACKER FOR A NEW MONTH
- Select all cells of the GRID where you tick habits as done. (do not include any of the F8 to AJ37 - right click and Select "Clear Contents".
habit tracker, habit categories and subcategories, excel tips, productivity, goal setting
habit tracking, excel spreadsheet, personal development, self-improvement
daily planner, routine tracker,
AMSR
#HabitTracker #ExcelTips #Productivity #GoalSetting #SelfImprovement #Motivation #PersonalDevelopment #ExcelSpreadsheet #DailyRoutine #TrackYourHabits
This is awesome man. Really aesthetically pleasing habit tracker. Been using Notion for my habit tracker but I found the databases and checkboxes quite uninspiring. This is really nice! Many thanks!
Thank you for the feedback - I appreciate it. Excel does not give us checkboxes yet (I know it's in the pipelines, but will take a while) and I find typing more satisfying than clicking sometimes anyway...