Skip to main content
AmigoFish

Build an Excel Mini Dashboard with One Function (yes, it’s real)

From MyOnlineTrainingHub · · 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Build a mini Excel dashboard with bar charts, progress bars, and star ratings inside your cells, using the REPT function and no chart objects. 👩‍🏫 Learn more Excel functions and formulas with my course: https://bit.ly/rept26course ⬇️ Download the example file here and follow along: https://bit.ly/rept26file

LEARN MORE ===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS ============== 0:00 The Excel function that builds charts inside cells 0:34 How REPT works (and the one quirk to watch for) 1:05 Build in-cell bar charts from your sales data 2:30 Color-code your bars by value automatically 4:28 Turn completion rates into clean progress bars 7:21 Why bar width controls how much detail you see 8:25 Build star ratings out of 5 for any score 10:45 If you want to build an interactive dashboard

#Excel #ExcelFunctions #ExcelDashboard

Back to MyOnlineTrainingHub · Report a problem