I just created this...

@digifull

9.4K followers · usually 1.1K views a post

Views

44.7K

Likes

1.7K

Comments

13

Shares

454

SoundTikTok sound · original sound - digifull

Promoted product

Scribe

Automatically capture, improve, and scale how work gets done. Give your teams and AI agents the context to do their best work. Trusted by 94% of the Fortune 500.

5 videos2 creators

Why it worked

The video provides a practical and visually appealing solution to a common productivity problem (tracking goals) using readily available tools (Excel and Scribe). The step-by-step demonstration and the promise of a shareable guide make it highly valuable and easy to follow.

Summary

The video demonstrates how to create a goal tracker in Excel using formulas and charts. It then shows how to use Scribe to record the process and generate a shareable step-by-step guide.

Structure

1Create a goal tracker in Excel
2Use formulas to calculate completion percentages
3Add charts to visualize data
4

Original caption

Turn a simple checklist into a smart Excel dashboard! No VBA. No complicated formulas. Just clean automation. Would you use this Goal Tracker? #Excel #MicrosoftExcel #ExcelTips #ExcelDashboard #Productivity

More from @digifull

Product placement

Scribe ACTS - it records screen activity and generates a step-by-step guide. Removing it would change what happens in the video. Excel ACTS - it is used to create a goal tracker, with formulas and charts. Removing it would change what happens in the video.

On-screen text

I just created this... Goal Tracker in Excel!! Here's how to do that! Let's start a Scribe to capture all the steps Now select this range and press Alt N C B to add the checkboxes Enter this CountIf formula Pick our checkboxes and then enter the condition TRUE So we can get the Completed checkboxes Now use the same formula but instead of TRUE... Use FALSE the missing checkboxes To get the Completed % Select the Completed checkboxes by all the checkboxes in our range! Copy and paste the formula Then go here Enter the Average function to calculate the average of the Completed % To get the Missing % Use 1 minus the Completed % To visualize our data Select this Completed % range Go to "Insert" and add a line chart and adjust it! Let's remove the fill color and the border and then adjust the text Change the color of the gridlines and then the color Make it smoother and then add markers Finally... Click on our axis and put 0 as minimum number 1 as maximum and then 0.2 as "Unit" We can also add a donut chart for the Total % We can style it Our Goal Tracker in Excel Now let's stop our Scribe So we can get a step-by-step guide that we can share with our team or boss! The best part?! Scribe will create an interactive walkthrough of the process Start sharing your knowledge

Transcript

I just created this... Goal Tracker in Excel!! Here's how to do that! Let's start a Scribe to capture all the steps Now select this range and press Alt N C B to add the checkboxes Enter this CountIf formula Pick our checkboxes and then enter the condition TRUE So we can get the Completed checkboxes Now use the same formula but instead of TRUE... Use FALSE the missing checkboxes To get the Completed % Select the Completed checkboxes by all the checkboxes in our range! Copy and paste the formula Then go here Enter the Average function to calculate the average of the Completed % To get the Missing % Use 1 minus the Completed % To visualize our data Select this Completed % range Go to "Insert" and add a line chart and adjust it! Let's remove the fill color and the border and then adjust the text Change the color of the gridlines and then the color Make it smoother and then add markers Finally... Click on our axis and put 0 as minimum number 1 as maximum and then 0.2 as "Unit" We can also add a donut chart for the Total % We can style it Our Goal Tracker in Excel Now let's stop our Scribe So we can get a step-by-step guide that we can share with our team or boss! The best part?! Scribe will create an interactive walkthrough of the process Start sharing your knowledge

Tired of juggling multiple apps and planners? 📅💰🎯 The Ultimate Life Planner S