ms office
Office 2010 The Movie (Trailer)
By admin at 11 January, 2010, 2:17 pm
Microsoft seem to give an impression that the new Office 2010 will be entertaining and fun experience. That should be the reason, Microsoft Office 2010 has come up with a movie trailer for its promotion. It sure is nice movie trailer with love, tragedy, fight… Nice ad Microsoft! Here is the video: Are you throwing [...]
Read More >>Excel Filename – Copy sheets to new file
By admin at 30 August, 2009, 6:50 pm
In the previous post I posted a code to copy data and remove all external references and save as a new file. But for a simple case, I was trying to save a sheet – as it is – as a new file. But, typical to a copy-paste code; a strange error occurred while I [...]
Read More >>Excel VBA – Copy worksheets and save as a new file
By admin at 28 August, 2009, 1:41 pm
If you copy data from one sheet to another the formula refer back to the original sheet. Doing a ‘past special’ and copying only the data can do the trick. But if you need to do such operations for a large number of sheets a VBA macro can be handy: Sub CopyPasteSave() Dim NewName As [...]
Read More >>MS Office 2010 going cloud
By admin at 13 July, 2009, 2:24 pm
Microsoft today announced at its Worldwide Partner Conference in New Orleans about the new version of Microsoft Office 2010. In response to Google Apps, Microsoft is going to roll out web browser versions of Word, PowerPoint, Excel and OneNote for free. Microsoft and free? Yes, and I am excited. Hopefully, I won’t need to install [...]
Read More >>Batch printing in MS Excel
By admin at 7 April, 2009, 2:06 pm
I had to print loads of charts from excel files. All at once! Rather than starting printing one by one I started looking for software to do the job for me. I found some really nice featured software but they came with hefty price tags (not less than 100 bucks). At last I found just [...]
Read More >>Free Excel add-in The Duplicate Master
By admin at 18 November, 2008, 4:26 pm
Update: Duplicate master V2.16 (Download link). (04/08/10) David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. But as his original web site is gone offline, people are deprived from using the great utility. The add-in works in MS Excel 2003 and 2007. It was originally distributed through the site – http://members.iinet.net.au/~brettdj [...]
Read More >>Change Case in MS Word 2007
By admin at 16 October, 2008, 3:06 pm
If you have recently upgraded from Word 2003 it would be difficult to find things you could do by clicking the menus. It took some time for me to find the “change case” option and was surprised to find it was right in front of me all the time. First let me tell you the [...]
Read More >>MS-OUTLOOK SHORTCUT KEYS
By admin at 20 August, 2008, 11:14 am
Alt + S Send the email Ctrl + C Copy selected text Ctrl + X Cut selected text Ctrl + P Open print dialog box Ctrl + K Complete name/email typed in address bar Ctrl + B Bold highlighted selection Ctrl + I Italicize highlighted selection Ctrl + U Underline highlighted selection Ctrl + R [...]
Read More >>MS-WORD SHORTCUT KEYS
By admin at 18 August, 2008, 11:11 am
Ctrl + A Select all contents of the page Ctrl + B Bold highlighted selection Ctrl + C Copy selected text Ctrl + X Cut selected text Ctrl + N Open new/blank document Ctrl + O Open options Ctrl + P Open the print window Ctrl + F Open find box Ctrl + I Italicize [...]
Read More >>MS-EXCEL SHORTCUT KEYS
By admin at 16 August, 2008, 11:11 am
F2 Edit the selected cell F5 Go to a specific cell F7 Spell check selected text and/or document F11 Create chart Ctrl + Shift + ; Enter the current time Ctrl + ; Enter the current date Alt + Shift + F1 Insert new worksheet Shift + F3 Open the Excel® formula window Shift + [...]
Read More >>
