What is the coolest Excel trick you have learned this year?
We are almost at the end of 2013. Time to review how much more awesome we became this year. Today let me ask you a very simple question.
What is the coolest Excel trick you have learned this year?
Go ahead and post your answers using comments.
What do you use Tables for? [poll]
What do you use Excel Tables for?
I will go first, I use them for,
1) Maintaining all my raw data, so that I can use structural references
2) Maintaining various trackers, for example I am tracking all our expenses in USA in a table.
3) For quick formatting of data (zebra lining, filters, sorting etc.)
What about you? What kinds of data are you holding in tables and how are you using them. Please share using comments
Excel Salary Survey Dashboards – Choose the winner [poll]
Recently, we published 66 dashboards visualizing Excel salaries around the world. Each of the contestants have put in great effort and hand-crafted these beauties. Now its time we picked a winner.
How does the voting work?
The voting has 2 components
- Readers (that is you) pick a winner and runner-up using online voting.
- Judges (2 of them) will also pick winners. Judges vote carries 20% weight.
How do you explain Excel to a small kid? [poll]
When I was in Perth, I visited Hui’s house one day. Lovely, Hui’s daughter (who is about 14) asked Hui how he knew me. So Hui told that we both share a passion for Excel and that;s how we got to know each other. Then she asked, What is Excel?
At this point, we both tried to explain what Excel is to her in a few ways with no success. Later Hui came up with a brilliant explanation.
He said, Excel has lots of small calculators all interconnected, so that you can do any sort of calculation.
So here is a challenge for you. How would you explain Excel to a small kid (computer literate, but not yet in college).
Do you use Pivot Tables? What do you use them for & where do you struggle [Survey]
If you like to analyze data, then you would fall in love with Pivot Tables on first sight. Pivot tables are a powerful, dead-simple & lovely way to play with your data, automate your reports and save time. That said, not all of us know how to use them or how to get them to […]
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 […]
We Want Your Ideas – Results
Two weeks ago we asked you what you wanted to see at Chandoo.org and you responded.
We have had 71 responses giving us 101 ideas to date.
Here are the results…