Build an Excel KPI Dashboard!
Learn how to build a dynamic and visually appealing Excel dashboard from scratch! Discover essential techniques, such as functions, keyboard shortcuts, formatting, and visual design.
➡️ Download the Excel File here!
Infographic File: https://www.yourcfoguy.com/templates/how-i-build-dashboards
Excel File: https://www.yourcfoguy.com/templates/how-i-build-dashboard-worksheet
⏱️ TIMESTAMPS
0:00 Intro
0:18 Free assets to download
0:22 Start building this dashboard
0:57 Keyboard shortcuts
1:44 Formatting cells
3:00 Populate with dummy data
3:32 Make it pretty
6:31 Link your dashboard
8:33 Use custom formatting
10:32 Create Data validation
12:17 Add a title
14:00 Outro
ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.
⚡️ Check out my channel here: http://www.youtube.com/@yourcfoguy
Don’t forget to subscribe!
🔎 FIND ME AT
https://www.yourcfoguy.com
➡️ Subscribe to my Newsletter!
https://www.yourcfoguy.com/newsletter
🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
LinkedIn: https://www.linkedin.com/in/joshaharonoff
Twitter: https://www.twitter.com/yourcfoguy
#Dashboards #Excel #ExcelDashboards #accountingprofessionals #ExcelTutorial #DataVisualization #yourcfoguy