Excel Links of the Week - The Mt. Rainier edition
on 13 Oct, 2008 in excel links | 2 Comments
We drove down to one of the Washington’s best attractions. The Mt. Rainier National Park. It is one of the best natural attractions I have ever seen. The mountain, the greenery and the drive are totally awesome. The mountain looked breathtakingly beautiful and the whole park looked awesome with fall colors. Do visit Mt. Rainier [...]
Read More >>11 very useful excel keyboard shortcuts you may not know
on 29 Jul, 2008 in Excel Tips | 15 Comments
- During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
+ - Inserts current date
+ - Copies value from cell above to current cell
+ - Edits a cell comment
+ - Opens macro dialog box
+ - Auto sum selected cells and places value in cell [...]
Read More >>Improve productivity by opening same excel sheet in 2 windows - quick tip
on 30 May, 2008 in Excel Tips, hacks, technology | 1 Comment
Often we work with large data sheets and it becomes tedious if you want to compare data / formulas etc. You can try split (menu > window > split or alt+w+s) to break the sheet in to two. But there is another cool thing you can do, open a new window for the spreadsheet. Just [...]
Read More >>3 excel keyboard shortcuts that can save a lot of time for you
on 15 Mar, 2008 in Excel Tips | 7 Comments
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?
Read More >>
