All articles with 'hacks' Tag

Track / share your goals using Google Spreadsheet Gadgets

Published on Mar 20, 2008 in blogging, Charts and Graphs, gadgets, ideas, Learn Excel, technology

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 […]

Continue »

3 excel keyboard shortcuts that can save a lot of time for you

Published on Mar 15, 2008 in Learn Excel

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?

Continue »

Custom Cell Formatting in Excel – Few Tips & Tricks

Published on Feb 25, 2008 in Charts and Graphs, Featured, hacks, Learn Excel

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 […]

Continue »