ms office

Office 2010 The Movie (Trailer)

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 away your [...]

Excel Filename – Copy sheets to new file

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 tried [...]

Excel VBA – Copy worksheets and save as a new file

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

MS Office 2010 going cloud

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

Batch printing in MS Excel

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

Free Excel add-in The Duplicate Master

David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. But as his original web site is gone people are deprived from using the great free utility.
The add-in works in MS Excel 2003 and 2007. It was originally distributed through the site – http://members.iinet.net.au/~brettdj which is offline these days.
You can however download [...]

Change Case in MS Word 2007

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 easier [...]

MS-OUTLOOK SHORTCUT KEYS

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 Reply to an email
Ctrl + F Forward an [...]

MS-WORD SHORTCUT KEYS

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 highlighted selection
Ctrl + K Insert link
Ctrl + U [...]

MS-EXCEL SHORTCUT KEYS

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 + F5 Bring up search box
Ctrl + A Select [...]