Home Creators Posts Import Register Favorites Logout

Content

Hello Members,

The training we have for this week that I have shared with you was about the Fitness Tracker. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Files

How To Build Your Own Excel Application - Step By Step From Scratch [+FREE Fitness Tracker Download]

🔥GET 250 OF MY BEST TEMPLATES HERE► https://bit.ly/250WKBK-Desc 📢GET YOUR FEATURE ADDED ON PATREON ► https://bit.ly/PatreonDesc 👉SELL YOUR OWN EXCEL-BASED SOFTWARE► http://bit.ly/MentorProgram_YTDesc 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc 📣LEARN VBA FROM THE GROUND UP ► https://bit.ly/VBA_YouTubeDesc 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. 📣30-HOUR VBA COURSE► https://bit.ly/VBACourseDisc ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/FitnessTrkr_WkbkDl 💬 FACEBOOK MESSENGER: https://bit.ly/FitnessTrkr_FbDld EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/VBA_YouTubeDesc EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►250 Excel Workbooks: https://bit.ly/250WKBK-Desc ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts 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 JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin

Comments

Nick Weiss

Hi Randy! Awesome training as always.

Nick Weiss

I have 3 ideas for this. (1) If it's a new exercise you're trying, maybe a pop up to show how to properly do the exercise. (2) A pop up or graph displayed showing what muscles each exercise is affecting. (3) A dashboard to show progression through the different exercises so you know if you're getting better or declining.

Excel For Freelancers

Great ideas Weiss, thanks so much. I will do my best to try and get a few of them added on this Monday. Much appreciated

Excel For Freelancers

Thanks so much. Make sure you check out the update. I added in all of your suggestions :)

Eduardo Valencia

Hi Randy, love this project, my boys and I are starting a new workout routine and this came at the right time. The only issue I see is that I have over 300 different exercises and the list is getting way to long. I thought about maybe adding a cascading list box with scrolls to pick between different body exercises. Like a list to choose from which would take you to the different groups of exercises. This would allow to shorten the lists and would make it easier to find the particular exercise your looking for without having to go all the way down through the one long list this creates. Example: Shoulder, Chest, Abdominal etc. Within each section a list of just those exercises that pertain to the muscle group you want to schedule. I also found some really neat exercise gifs that show how to execute the exercise. This would help a lot. Thanks.

Excel For Freelancers

Hi Eduardo, thanks for the comment. That makes sense. Perhaps you can add a 'Category' to each exercise, and in the exercise list up at the top, you can filter by category. Unfortunately, I already did the update on this one last week, however, if you had suggested this to me last week I would have added it in. Please make sure to suggest and comment on any new videos right here on Patreon for each release and I will try to get your feature added in. You can find the update to this video training right here: https://www.patreon.com/posts/fitness-tracker-73111760