Meet Nakshatra & Nishanth (and say Happy Birthday to PHD)
< drum roll > Welcome Nakshatra and Nishanth to their first public appearance.Nakshatra is the girl and Nishanth is the boy (for the curious, Nakshatra means star and Nishanth means moon) Here is a fun question: Can you guess which one is Nishanth and which one is Nakshatra? On more family affairs, today I am […]
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]
In our recent poll, I have asked you to tell me which buttons you have on the quick access toolbar?
Finnur, one of our readers has configured the Excel 2007 quick access toolbar to make it look like Excel 2003 toolbar.
I think this is a very cool way to max up your productivity, it takes 5 minutes to make your quick access bar look like Excel 2003 toolbar and you could save countless hours of “searching-for-that-command-in-ribbon” time.
Making a chart with dynamic range of values
We all know that to make a chart we must specify a range of values as input.
But what if our range is dynamic and keeps on growing or shrinking. You cant edit the chart input data ranges every time you add a row. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?
Well, you can do it very easily using excel formulas and named ranges. It costs just $1 per each change. 😉
Ofcourse not, there are 2 ways to do this. One is to use Excel Tables and another is to use OFFSET formula.
The Project Management Bundle for Excel is Here, Download your copy today
I have a super exciting news for all our members. During the last several weeks, I have been working on making 24 strikingly remarkable and easy to use excel templates for better project management. Finally the bundle is ready. You can get a copy of the bundle starting today.
Baby Feeding Chart using Excel
While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby’s feeding and sleeping activities on day to day basis. It would probably help you understand your baby’s needs better and may be give you some insights.
Visualization Lessons from Eiffel Tower [Chartbusters in Paris]
Ever since I was a child, I was fascinated by Paris (and Eiffel Tower). Recently, I had opportunity to visit Paris, albeit for just a few hours (I had a 12 hour lay-over in Paris between flights). I went to see the Eiffel Tower and it looked just as beautiful and majestic as it did in my imaginations.
During my visit to Eiffel tower, I took the stairs to 2nd floor and along the way they have a handful of visualizations explaining the tower. I found them quite interesting and well made. Here, I have listed down 4 simple, yet very effective visualization lessons for all of us.
Another Reason why Tables are so awesome [quick tip]
Ever since I have learned the tables feature in Excel 2007, I have fallen in love with that. They are so awesome and so user friendly.
Here is a simple, yet very effective feature of Excel Tables that will show table header row even when you scroll down. The header row is shown in the place of column headings (the place where you see A,B,C,D etc.).