Learn how to create a yearly weight tracker in Microsoft Excel. The final spreadsheet includes the ability to set a goal weight, track the daily change amounts, shows how much to reach the goal and even includes a dynamic line chart to display your daily progress.
And, it’s super fun and easy to build!
FORMATTING CODE
▲ 0.0;▼ 00;-;@
SPREADSHEET LINK
https://spreadsheetlife.myflodesk.com/omusntdv9l
COURSES
https://spreadsheetlife.com/all-courses/
OTHER
Templates: https://spreadsheetlife.com/templates/
Blog: https://spreadsheetlife.com/blog/
VIDEO CHAPTERS
00:00 - Overview
00:35 - Worksheet Structure
02:29 - Setup Worksheet
05:15 - Weight Log Worksheet
07:50 - Formulas
11:23 - Special Formatting
13:05 - Line Chart
15:27 - Final Touches
Music by Epidemic Sound