All articles with 'tips' Tag

Here is a simple to trick to beat the 56 color limitation in excel when you are designing a chart: use picture files (jpg, gif, png etc.) to fill the chart area. You will no longer have to worry about limiting your project report / website / annual report etc. colors to the 56 that […]

Do you know that you can use excel find – replace dialog to change cell formats? Often we prepare a report or project plan and our boss or someone else in the team feels that all the red color cells need to change to blue or something similar, worry not, you can use find-replace (ctrl+h) […]

How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore? Well, I will tell you my answer, its 293049430493 times 😉 Worry not! for you can become a charting superman (or elastigirl) by using these 73 free designer quality chart templates in literally […]

Google docs team has announced gadgets, auto-fill support, formula help while typing and several other goodies yesterday. I was experimenting with these stuff and wanted to share a cool idea with you all. Tracking / Sharing your goals (or resolutions, progress) with everyone using Google Spreadsheet Gadgets: For the example purpose, let us build a […]

F2 – Edit a cell, takes the cursor to the end of the cell F4 – Repeat last action (for eg. if you have inserted a row, repeats that action again) – doent really work with paste through. Ctrl+1 – Open “Format cell dialog” What are your 3 most favorite excel key board shortcuts?

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking. Better still, you dont even need to be a guru […]

The other day I had to make an excel sheet for tracking all errors across one of the applications we are doing for our customer. The format was something like this, We wanted to use a consistent message id format [4 digits: 0001, 0002, … , 1000 etc.]. Now I do not want to type […]

Yesterday while going through my feeds, I have landed on this post about the demographics and use-figures of various social networking (2.0) tools, et al (by businessweek) on think:lab blog. When I looked at the BusinessWeek’s graphical representation of demographics and usage figures of social networks, the first thought that came to me is, “well, […]