Tip to Stop Zeros Showing for Empty Excel Values

If we are not careful our Excel spreadsheets can appear cluttered and clumsy. One often irritating feature is when formulas that reference other cells display '0' instead of remaining blank when there is nothing to display.
What do I mean? Imagine your formula references A1 but the cell doesn't have a value. Rather than making our formula return blank, Excel actually shows '0'.

Tip to make Word 2007 always save in 2003 format

Sometimes problem arises as we send a Word 2007 document without converting it into 2003 format because not everyone has updated to Word 2007. But, it is possible to make Word 2007 always save in 2003 format. By changing a few settings, we can make Word 2007 always save in 2003 format automatically.

Using the Freeze Panes Feature of Microsoft Excel for Easier to Use Spreadsheets

Have you noticed how when you have a lot of data to input into a spreadsheet, your column headings disappear off the top of your screen?
There is a simple way around this in Microsoft Excel. It is the Freeze Panes feature.

Tip to reorder pages in Microsoft word 2010

Reorder (of slides) in PowerPoint is easy, as one just needs to drag and rearrange the thumbnails for the slides but sometimes you  one  want to rearrange pages in a MS Word which is somehow different. This article  describes how you can reorder your pages in a Word document

Tip to Stop Excel Displaying the Formula Instead of the Result

A quite common complaint of Excel users is that they can see the formula of a cell instead of the formula results; for example:

Tip for converting Text into Table

You can also convert the text of a Word document into table. Usually, the tab is used as separator between columns. It means, the text is arranged into columns byinserting tabs and then it can very easily be converted into table. You can also use commas as separators to create the columns.

Protect your Word and Excel Files with password

If you are of one of those who creates Microsoft Word document and Microsoft Excel spreadsheets, and intend to password protect them either for view or modifications, this post will be of interest to you.

In this post, we will learn about a simple trick using which you can password protect your Microsoft Word documents and Microsoft Excel spreadsheets. This definitely lets you add a first level of security to your files.

How to Join Ranges in Microsoft Excel

If you have ever had to import data from multiple sources into one Excel spreadsheet, you know how painful it can be to manually consolidate all that data into a well organized file.
Thankfully Excel has a few "hidden" features that can take away some of the hassle and make the whole process a lot easier.

Tip to Add Horizontal Lines in Word 2007 Document Quickly

You can add horizontal lines in Word 2007 document quickly without having to use the ribbon on the top of the page. A very easy way to add horizontal lines in Word 2007 quickly is by using the keyboard shortcuts. This method will save your time. You will be able to insert lines of many different designs by using the keyboard and not having to use the mouse at all. 

Tip for Changing Exchange/Outlook Mailbox Location

To change the location of your mailbox for Exchange:
1. Open RegEdit
2. Go to
HKEY_CURRENT_USER\Software\ Microsoft\Windows Messaging Subsystem\ Profiles
3. Go to the profile you want to change 

How to Use Escape Characters in Excel

If you want a cell to contain an equal sign (=) or a formula (to show the formula itself in the cell, not the result), you can use an apostrophe in front of the formula, like so:

This even works correctly if another cell calculates the length of this cell, like: =LEN(A1). Excel uses the length without the apostrophe.

List Of Microsoft Excel Keyboard and mouse Shortcuts

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.

Mouse shortcuts

Shortcut	Description
Double-click (on a cell)	Edit the cell contents.
Double-click (on a row/column divider)	Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider	Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click	Select the entire contents in the cell
Click on row/column divider then drag	Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag	Adjust height/width of the rows/colunns
Ctrl + Mouse wheel	Zooms in and out of document.
Hold Shift + Click the cells	Select multiple cells

TIPS TO SELECT TEXT QUICKLY IN MS WORD

Here are some tips to slect text quicky in MS Word, this is really very useful and very handy. This is a great feature of microsoft word and most of the users are unknown of this selecting style. Here are instructions to select text:

Tips to make your Excel models look more professional

No matter what version of Excel you’re using, there are three easy tricks you can do to make your tables and models easier on the eyes, easier to use, and more professional. I’ll show you the transformation alongside an example.

First, let’s suppose this simple table is what we originally start with:

Add Email Signature in OUTLOOK 2010

One of the most important feature in an email is a Signatures that can be appended at the end of the email and contains contact information, salutation etc. Signatures can be set in an email client so they don’t need to be retyped every time a new mail is drafted. Microsoft Outlook 2010 too provides the ability to integrate and save email signatures. To create a signature & save it for future use in Microsoft Outlook 2010 follow the steps :

Microsoft Office 2010 launched for consumers

Microsoft has launched Office 2010 for consumers worldwide which includes three main editions - Office Home and Student 2010 ($149), Office Home and Business 2010 ($279), or Office Professional 2010 ($499).

Office 2010 comes with multiple new features like the Backstage view which replaces the file menu, improved search and navigation, new picture and video editing tools, the Sparklines tool (in Excel) for creating small charts in a single cell, and more. Also, for those who like to be in the clouds, Microsoft has the Office Web Apps - online versions of Word, PowerPoint, Microsoft Excel and OneNote.

Office 2010 is available in 10 languages but will cover no less than 94 languages in the coming months. For more info about Microsoft's Office offer check out this page .

Tips to Wordpress Blog Post From Office 2010

I have shared several Office tips on this blog, Today i will tell you another trick related to blogging with office 2010.  if you dont have office 2010 installed,first install it ,then you can  simply configure word 2010 for a wordpress blog and use it as blog editor.

Below is a step by step procedure on how to configure word 2010 as blog publishing editor for a wordpress blog.

1. Open Word 2010 and go to File Menu >> New Blog Post

Insert Flash Movies into PowerPoint slides

MS PowerPoint is a powerful and attractive tool to express your ideas to others. You can convey these ideas in more effective ways, if you are using movie files with your simple slides. The Flash movies are normally the best choice to add into PowerPoint due to its small file size.

Follow the given steps to insert the Flash Movies into PowerPoint Slides:

Make sure before inserting the Flash Movies into PowerPoint slides that you have installed the Flash Player on your computer.

First of all open the presentation in which you want to insert Flash movie file.

Now click on "Toolbar" option from the "View" menu and choose the option "Control Toolbox".

Backup Your Outlook Contacts to Excel File

Microsoft's Outlook is integrated into Microsoft Office 2000, 2002, 2008 and Microsoft Exchange Server. Outlook is complete e-mail manager by which you e-mail, calendaring, and contact management. Outlook enables you to filter and organize e-mail messages, integrate and manage e-mail from multiple e-mail accounts, personal and group calendars, contacts, folders, and tasks.

Using Import and Export feature in Outlook, you can create the full backup of outlook contacts. Because without backup yon can lose your e-mail accounts data any time due to virus, power failure and hard disk problem. 

Follow the given steps to export your outlook contacts to Excel file: 

Click on Start button, go to Program then click on Microsoft Outlook to export the contacts. 

Now go to File menu and click on Import and Export option. Choose Export to a file as show in the below figure then click Next.

Show and use the Shortcuts keys in Word 2007

In Word 2007, most of the shortcut keys are same from the earlier versions such as Word 2000 and Word 2003. But the interesting thing in Word 2007 is that, Microsoft provides a new look or system for these shortcuts keys. In earlier Word versions, you must be memorized to use the shortcuts keys such as (CTRL + B" to make letters bold and "CTRL + I" to make letters italic). But now do not require planned memorization in latest Word 2007 version. There is a fast, simple, and visual way to find out what you need to press.

Now by pressing the "ALT" button and many options or keyboard shortcuts (containing letters or numbers) will be appear on top of the toolbar buttons.

You will see here, For Example:

Alt-F = Office Button

Alt-1 = Save

Alt-2 = Undo