79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Upgrade

Let's Make a Progress Bar

4 Tutorials

34 minutes

In this mini course from Better Sheets, we're gonna make a Progress Bar. Sounds simple right? Not so simple for everyone. Progress Bars aren't just for Democrats to drink at. They serve as a visual aid to our data. They can bring gamification to your sheets. And make your data look neat. In 33 minutes across 4 videos, walk with me as we create Progress Bars both horizontally and vertically.

4Tutorials

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.

Make Vertical Bars - Make Progress Bars with Sparkline: Part 3

we're gonna go through what does it take to make a vertical progress bar.

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Intermediate