- The Workbook
- Posts
- What most people get wrong about dashboards đ
What most people get wrong about dashboards đ
How to zap your blanks in Excel in 30 seconds
Hey! About five years ago, I launched Miss Excel with one goal: to help as many people as possible feel empowered when using Microsoft Excel.
Since then, Iâve had the honor of receiving the Microsoft MVP Award each year. Last weekâs award announcement marks five consecutive years for me as a Microsoft Most Valuable Professionalâand Iâm feeling deeply grateful. đ
To celebrate, weâre bringing back your favorite free Excel Dashboards Training, where youâll learn how to build beautiful dashboards in just one (fun!) hour!
Save your seat today!


Building a Dashboard? Fix This First. đš
This is the biggest mistake I see people make with dashboards âĄïž
They jump straight into the fun stuff (Charts! Slicers! Colors!) and completely forget the most important part: data cleanup.
A clean, structured dataset is the foundation for any great dashboard. Without it, your dashboard is basically a house built on a sinkhole. It might look great from a distance, but upon closer inspection? Itâs on the brink of collapse. đ«
The first step to cleaning your data is removing empty cells. Hereâs how to catch those sneaky blanks in 30 seconds:
Step 1) Press CTRL + G and click on Special

Excel Tip đĄ: The âSpecialâ feature is only available in the desktop version of Microsoft 365. If youâre using the web version, youâll need to download it! |
Step 2) Press K + Enter (this automatically selects Blanks) and select OK

Step 3) Press CTRL - (minus) and click Shift cells up

Thatâs all it takes for a strong foundation!
But: Cleaning up blank cells is just the beginning. Youâll also want clear headers (no âColumn1,â please! đ ) and a set of 3â5 key metrics to shape your dashboardâs design. This video will teach you the rest of the dashboard basics in two minutes.
If you could learn this much in two minutes, imagine how much you could get done in 60. đ Register to my free Excel Dashboards Training today to find out!


Our Corporate Clients Love Our Free Trainings Too! đ
Hereâs what Mandy, one of our corporate clients, had to say about our free classes:
When a Director of Accounting shares this type of feedback, you can be confident youâll be learning in-depth, relevant information thatâll actually level up your career!
Sign up for our free Excel Dashboards Training and youâll get:
The confidence to handle any visual reporting request
My proven process to build a beautiful dashboard from start to finish
Time-saving techniques that give you hours back each week


The Weirdest Life Hacks of 2025 đ
Itâs peak summer. Yes, the peaches are delicious. But the sweltering heat is focus-frying (seriouslyâproductivity decreases 0.83% for every 1°C increase in outside temps!) and inboxes are piled high with OOO responses. If your motivation is melting, youâre not alone. đ«
So, I dove into Redditâs r/productivity page to find some new tips to get me through to fall. I stumbled on a thread packed with weird (yet effective) life hacks. Out of 396 responses, here were my favorite three:
1) Hack 1: Ditch âCleaning Sundayâ for âCleaning Thursdayâ
Move your weekly cleaning from Sunday to Thursday afternoon. Set up a calendar reminder to mentally prepare and then reward yourself with Netflix or a sweet treat after.
As one commenter explained, âComing home to a clean house with food warming up on Friday after work is pretty magical. Kicks the weekend off right.â
2) Hack 2: The âOne Thingâ Rule
This Redditor said, âEvery time I leave a room, I make an attempt to leave it tidier than when I entered it. Just one tidy thing as I leave.â
That could be folding one shirt, washing one mug, or tossing one piece of junk mail. The beauty of this strategy is that youâll never feel overwhelmed, but before you know it, your place will be tidy as can be.
3) Hack 3: The âBurner Emailâ Strategy
Keep a separate âburnerâ email just for warranties, returns, and shady sign-ups. Then forward all your receipts there manually after a purchase.
Sure, itâs an extra lift. But when your printer stops working six months after you bought it? Youâll be thankful you donât have to dig through 72 Amazon shipping notifications to find your receipt. đ
Whatâs your favorite unconventional life hack? Reply and let me know!


Excelâs secret summary tool is hiding in plain sight. đ
These three skills will future-proof your career in the AI era. đ€
Did you know you can create an Excel dashboard from an image? đž
10 Excel dashboard mistakes I see way too often. đ«
Hit a plateau? This video gives you the tools to power through. đȘ


Thanks for reading! Donât forget to register for our free Excel Dashboards Training to automate reporting and save over three hours a week! Spots are limited, so be sure to save your seat today.
Stay Exceling,
Kat