🎅🏻🎁𝗪𝐑𝐀𝐏 𝐔𝐏 𝐘𝐎𝐔𝐑 𝐘𝐄𝐀𝐑 𝗪𝐈𝐓𝐇 𝗛𝗨𝗚𝗘 𝗦𝐀𝐕𝐈𝐍𝐆𝐒 – 𝗨𝐏 𝗧𝐎 𝟱𝟱% 𝗢𝐅𝐅! 👉[ Ссылка ]
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: [ Ссылка ]
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: [ Ссылка ]
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
EXCEL COURSES:
►MENTORSHIP PROGRAM: [ Ссылка ]
►DASHBOARD MASTERCLASS: [ Ссылка ]
►BEGINNERS VBA COURSE: [ Ссылка ]
►FREELANCER ACADEMY: [ Ссылка ]
►WEB AUTOMATION COURSE WITH EXCEL VBA: [ Ссылка ]
EXCEL PRODUCTS:
►The Ultimate Schedule Organization with Excel Calendar Pro: [ Ссылка ]
►Get 350 Templates In 1 Zip File: [ Ссылка ]
►Get 500 Done-For-You Macros: [ Ссылка ]
►Get ChatGPT Into Excel With This Addin: [ Ссылка ]
►The Ultimate Excel Resource Guide: [ Ссылка ]
►Get Your Actual Employee Hourly Cost: [ Ссылка ]
►1000 Incredible Freelancing Resources: [ Ссылка ]
🧐Find the Best Excel Products & Courses Here: [ Ссылка ]
#FitnessTracker #HealthAndWellness #ExcelAutomation #FitnessJourney
