𝗪𝗜𝗟𝗗𝗘𝗦𝗧 𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗙 𝗧𝗛𝗘 𝗬𝗘𝗔𝗥 - 𝟲𝟱% 𝗦𝗔𝗩𝗜𝗡𝗚𝗦 𝗙𝗢𝗥 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬 https://www.excelforfreelancers.com/BFSale2024_YTDesc


In this week’s training, I will show you how to create your own fitness tracker in Excel as I create one right in front of you, starting with a blank workbook.


𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:
USING YOUR EMAIL: http://bit.ly/FitnessTrkr_WkbkDl


GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Display Instruction Pictures On Exercise Selection & Detail
• Added Monthly Progress Graph
• Set Completion % With Conditional Formatting
• Added Select All/None Option
• Clear Exercise From Schedule

FIND THIS UPDATE ON PATREON HERE: https://www.patreon.com/posts/fitness-tracker-73111760


TIMESTAMPS:
0:00 - Introduction
1:48 - Overview of the Fitness Tracker Dashboard
2:55 - Creating & Designing Brand New Workbook for Fitness Tracker Sheet
17:10 - Setting up a Conditional Format for User Data with Alternative Rows
21:30 - Adding Checkable Boxes using Wingdings Symbols
27:25 - Inserting Workable Pictures into the Dashboard
32:40 - Formatting the Data Mapping
40:05 - Setting up Exercise Sheet & Creating Criteria for Dates & Results
46:50 - Adding Macro Module for Exercise & Schedule Macs
50:39 - Creating Exercise Load Macro for Fitness, Exercise and Schedule
57:35 - Adding Macro for New Exercise
59:00 - Adding Macro for Clearing the Contents
1:05:40 - Setting up Saved Exercise Macro and Adding Message Box
1:08:45 - Assigning Macro for Save and Update Button
1:16:35 - Run Macro for Exercise_ShowPic
1:25:59 - Adding Macro for Loading New Exercise
1:30:03 - Adding Macro for Deleting Exercise
1:44:20 - Setting Up Macro for Loading a New Day Schedule
1:53:30 - Adding Macro for Adding Exercises to the Schedule
1:58:09 - Assigning Macro for Call Pop Up Calendar to Display Date Picker
2:00:10 - Assigning Macro for Next and Previous Day
2:06:30 - Changes in the Worksheet to Update Changes Automatically


#FitnessTracker #HealthAndWellness #ExcelAutomation #FitnessJourney