Category | MS Office Tricks

Get things done fast with keyboard shortcuts for Windows, Word, Excel and Outlook

Posted on 21 February 2008

Keyboard shortcuts are definitely great time savers. Here is a list of shortcuts for Windows, Word, Excel and Outlook for you to use. Of course, it wouldn’t be possible for an average person to remember all the shortcuts but then you wouldn’t need to. It would be enough if you remember the ones that [...]

Tags: , , , , , , , , , , , ,

Insert your signature using Autocorrect in Word

Posted on 02 December 2007

Most of us who have used Microsoft Word would also know about it’s AutoCorrect feature. Normally we use it to replace certain long text with a shorter form to reduce key strokes. For example you can set the AutoCorrect to replace ‘yf’ with ‘Yours faithfully’. This is how most of us use it.
But few people [...]

Tags: , , , , ,

Excel 2007 - The 65535 & 65536 problem

Posted on 22 November 2007

If you are using Excel 2007 at office or at home, you might be surprised to know that while it can do complex calculations accurately, Excel 2007 has trouble doing simple multiplication.
While it is hard to believe, Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5. Basically Excel 2007 has [...]

Tags: , , , , , , ,

ExTools - A free collection of useful Excel functions

Posted on 09 June 2007

ExTools is a free Microsoft Excel add-in program that has lot of useful functions that can make your life easier working with Excel.
While some of the functions available in ExTools simplify a task which normally would take much more time otherwise some tools in ExTools are additions which are not available in Excel. These can [...]

Tags: ,

Zoho QuickRead - Open and Edit Office files within the browser

Posted on 26 April 2007

Zoho Quickread is a great plug-in for Firefox/IE that lets users open common online office files like documents, spreadsheets and presentations right in the web browser.

Let’s see how it works in Firefox. Once you install the plugin and restart Firefox, you will find the ‘Zoho Options’ menu item under the Tools menu where you can [...]

Tags: , , , , ,

An Excel AddIn to show Currency in Indian format and Words

Posted on 30 March 2007

This post is about an Excel Add-in that I developed about 6-7 years ago. The Add-In was born out of necessity in my office work.
What we needed was to show a number in the Indian Rupee format as well as display the amount in words. Let me explain. Say we have a figure 12345678. If [...]

Tags: , , , , , ,

Easy ways to select text in a Microsoft Word document

Posted on 21 March 2007

Here are a few tips to save some time while working in a Microsoft Word document. Once you type out the text in Word, if you want to work on a portion of the text, like say apply some kind of formatting, you need to first select the text. The most common way is to [...]

Tags: , , , , ,

  • Recent Comments:

  • Advertise Here