- The Workbook
- Posts
- The Excel error that crushes dashboard dreams đ
The Excel error that crushes dashboard dreams đ
How to get rid of those pesky +15s in 15 seconds
Hey! The post-summer work rush is just around the corner. đ But instead of playing catch-up mode, you could come into the office this fall with indispensable Excel skills thatâll have your boss saying, âWow, you really leveled up this summer.â âď¸
Thatâs what our free Excel Dashboards Training is for! In just one power-packed hour, youâll learn how to turn your raw data into clean, dynamic visuals that update automatically and help you get back hours every week.
Save your seat today!


Donât Let Pesky +15s Zap Your Dashboard Dreams đ
Todayâs the day. The day when you build a beautiful dashboard of your customer data to make your life easier and impress your boss. Youâve got your coffee (or matcha đľ), your data, and your vision.
But wait. What are those random â+15sâ doing in your account number column?

Hereâs what happened. âĄď¸ Since youâre dealing with large numbers, Excel automatically switched the Account Number column to scientific notation so it could handle calculations more easily.
The problem? Those +15s will break your dashboard. When Excel displays scientific notation (such as 6.43589E+15), the data is stored as a combination of numbers and text. But dashboards need clean numbersâotherwise, youâll have wonky formulas, janky slicers, and a host of other issues. đŤ
Letâs get rid of these pesky â+15s,â shall we?
Step 1) Select the column
Step 2) Change Data Type to Number

Step 3) Click the Decrease Decimal button twice

Thatâs it! Now you can build that show-stopping dashboard (and start sippinâ on your caffeine â).


Laziness = Bad Brain Marketing? đ§
What if the problem isnât that you're âlazy,â but that your brain is just bad at selling you on doing things? You know you should go on a run, update that presentation, or do the dishesâŚbut when itâs go-time, your mind saysâŚ
âThatâs hard. Itâll take forever. I donât want to.â
No wonder you're not buying it! That internal voice is focused on the effort. But what if it focused on the results instead? Thatâs what author Scott Adams believes high-achievers do: They get excited about the outcome instead of dwelling on the cost.
Hereâs why this works. âĄď¸ The brain releases dopamine in anticipation of a reward. If your mental focus is on the grind (âUgh, 30 minutes of runningâ), your brain has little reason to get off the couch.
But shift your attention to anticipate the reward (âIâll feel clear-headed and proud afterâ), and dopamine starts flowing. Suddenly, taking action doesnât seem so bad.
This trick reframes âlazinessâ for what it really is: a habit of focusing on the wrong thing. But thatâs a habit you can change:
Instead of: âUgh. Cleaning that spreadsheet will be tedious.â â Try: âMy life is going to be 10X easier once I clean this!â
Instead of: âI donât want to wash the dishes.â â Try: âCanât wait to have a spotless kitchen and be done with it.â
Change your mental sales pitch, and watch your motivation follow. â¨


How to create a dynamic donut chart in Excel in 30 seconds. đŠ
Turn ChatGPT into your personal assistant by scheduling to-dos. đď¸
âJust amazing,â says a comment on my video on radio dashboards!
A $22M founder says this is the biggest red flag in a job interview. â
Everyone has an âelusive creative genius.â Hereâs how to find yours. â¨


Thanks for reading! Donât forget to sign up for our free Excel Dashboards Training! This is the last week the training will be available for the rest of the summer, so be sure to save your seat before itâs gone.
Stay Exceling,
Kat