This week, Speed up your Spreadsheets – Your Action Required
In recent installment of Customer Service Dashboard post, our reader Salmon asked an interesting question,
I am struggling with data size with my dashboards…so many SQL data pulls and formulas to generate the Dashboard, the entire file is massive and sluggish. Perhaps a few tips from Chandoo Master for all us rookie dashboard designers regarding how to minimize file size and maximize calc speeds. #
Dan l & others chipped in and shared their ideas on speeding up Excel. But the topic is wide & has many solutions. So I am dedicating an entire week to discuss this. Welcome to Speedy Spreadsheet Week.
How would you customize Excel after installing? [poll]
Recently, I bought a new laptop, because my old Toshiba died down. After installing the OS and other necessary tools (like browser, skype etc.), I have installed Office 2010. Since Excel is my bread and butter, I like to customize it so that I can get more work done. So today,let me share how I […]
What is one area of Excel you want to learn more? [Survey]
It is almost weekend. Today we (Jo and I) are going to watch a cricket match being played in Vizag. We are pretty excited as this is the first time we are watching a match in stadium. So, let keep this light and fun. I want to know What is one area of Excel you […]
How long have you been using Excel? [poll]
This week’s poll is dead simple. Just tell me since how many years you are using Excel. I will go first: I have first started using Excel in year 2003 to keep track of my MBA entrance exam preparation. It helped me a lot in recording practice test scores, listing all the mistakes I made […]
Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit
(You can win my latest Excel Dashboard Training kit free, read this post to find out how.)
Over at Jorge’s ExcelCharts blog, he started a very good discussion on Excel Dashboards: Who needs them anyway?.
Jorge has very good experience designing, working on and teaching about dashboards. So he uses all that skill to gaze in to a crystal ball, to understand who needs excel dashboards and why. In this post, I build on his argument and ask you the big question – “If you make or use Excel Dashboards, who are you?”
Make a Christmas Card, and you can Win a $50 Gift Card
Christmas is my favorite festival. It has certain magical feel to it. This year, it is going to be even more special, because we have 2 more hilarious, lovely people to share our joy with, not to mention over 16,000 of you to celebrate it with.
So naturally, I was excited when Fred suggested that we have a contest on this in our forums. So here we go.
What is the last visible cell in your excel window? [Poll]
This is a fun and quick poll.
I want to know what is the maximum number of cells you can see when you open Excel. Do this:
- Open Excel, Maximize the window if it is not.
- Just tell me the bottom right cell that you can see completely.
- Go have a good weekend 🙂