Are you making these 10 rookie mistakes when creating dashboards?
Watch below to video to understand what these mistakes and how to avoid them.
10 Rookie mistakes to avoid when making dashboards [23 mins]
More resources on Excel dashboards
Excel dashboards – Information, examples & tutorials
Creating a KPI dashboard using Excel – 6 part tutorial
Sales dashboards – 32 examples & downloads
Do you make any of these mistakes?
When I made my first dashboard in Excel (a balance scorecard for our department), I made almost all of these mistakes. Today, I am more careful. But I still forget to do print settings or make small mistakes when I create dashboards.
What about you? What mistakes are you making when you construct dashboards? Please share using comments.
34 Responses to “What would you wear to an Excel themed Halloween party?”
I would go as an amoeba ... A cell!
Clippy!
Either Clippy or the Wizard.
My girlfriend and will dress up as two veals. We will carry a big heart stating our love.
It will be veal hookup
A Guantanamo bay prison guard outfit with Messi's Barcelona jersey to get across the power of discipline and creative energy.
I'd be dressed as Ross Geller, shouting "Pivot! Pivot! Pivot!":
http://24.media.tumblr.com/6b6265de049e4b4b918ec66572b2d40f/tumblr_mh5fmkj58S1rycrkjo1_500.gif
I will go with a quote on my shirt 🙂
"I love Lookup()"
Dont take the wrong meaning
I'd bring the kids and go as Pivot Table and chairs
I would dress up as the Mysterious Excel Solver!
... you could be looking for that notorious serial killer "the slicer."
Me and my wifey would wear shirts with an R and an A printed on them. We'll we an aRrAy... 😛
#N/A....
Sometimes
a t-shirt with this:
=IF(ISBLANK(QAT),"Snail Speed", "Lightning Fast")
a key! 🙂
I wonder if he would hand out Surface 3's to super heroes? I'm thinking an x(l)-men ...
http://www.jeffkoenig.com/demo/xmen.html
I just wear my expression.
I would wear a white sheet with the word "Spread" written on it.
@Pizzaguy
If there was a prize I would vote for you so far !
My T should be printed with "Excel without CHANDOO is like Computer without Inetrnet"
CH O O SE
Toga - because as large as I am, it would be a spread sheet.
Have some Rows and Columns
My t-shirt would read "I am with stupid" and point to the left while my wife's t-shirt would read "I am with stupid" and point to the right...
Guess there's nothing scarier than a circular reference..!
Happy Hallowe'en Chandoo. 🙂
I think you win, Adi! 🙂
Good one. Another indirect twist to this.
The t-shirt says "My spouse is with stupid" and both of you walk together. The circular reference breaks whenever someone joins you for a chat.
I'd put my left arm inside my shirt and go as the RIGHT function.
=vlookup(substitute(A2434," ",""), mytable$A$1:$A$100000,Match(A$1,table22:$2$.0),0)
=excel nerd
a Sum-Product Pumkin
I will have my t-shirt signed by all my relatives so I can USE RELATIVE REFERENCES to get through the bouncers at the doors
To avoid getting into any trouble at the party my T Shirt would say:
On Error Resume Next
What kind of nerd am I that I almost laughed out loud at yours Hui? 🙂
I would go with my girl and have her wear a t-shirt say =index("mr. right",match("me","all guys at party",0),1) and i would wear a shirt with two cells with one saying "me" and another saying "mr. right"
I will love to wear:
I LOVE INDEX+MATCH
“I love VLookup()”