Tuesday, January 31, 2012

Create Macros In Microsoft Office Word 2010

Macros has been an old phenomenon of Office apps allowing you to record set of actions you perform on document, and to repeat them in future. Through Macros, you don’t need to perform same action, i.e, change formatting, style, font family, size, and color over and over again in document. It actually records each and every click, keystrokes that you do while performing the task. So you can play it back to perform same action over any other document.

To begin with, launch Word 2010 and open a document in you want to record a macros. For Illustration, we have included a document containing a paragraph. We will be record a macro for a simple formatting of paragraph.

For recording a Macro, navigate to View tab and from Macros options, click Record Macro.

It will bring up Record Macro dialog, now enter a Macro name, and under Assign macro to options, click Keyboard button to assign Hotkey.

Now place insert cursor in Press new shortcut key box, and assign a hotkey by pressing keys combination on keyboard. Click Assign to assign hotkey to macro and click OK.

You will tape recorder like image with pointer indicating that macro is now recording actions. We will be doing some formatting over the text like insert drop box, change paragraph color, etc.

To stop recording macro, head over to View tab and from Macro options, click Stop Recording.

Now we will be executing macro over new document to align with the formatting style we have applied earlier.

Run the macro by pressing hotkey assigned. In our case it is Ctrl+Shift+M. It will immediately apply recorded formatting style to the new paragraph.

For saving a macro-enabled document, on File menu, click Save as. From Save as dialog, under Save as type options, click Word Macro-Enabled Template (*dotm). Enter an appropriate name of document and click Save.

We have demonstrated recording a macro with simple steps and applied less formatting over aforementioned document content. However , you could create a complex one, which would record tons of design change and formatting styles.

Monday, January 30, 2012

How to Create a Drop Down List in Microsoft Excel

Step 1: Open your work sheet and write down all the items you need in the list anywhere on it. Make sure that the list is written vertically and you sort and arrange the items carefully as the same order will be reflected in the list.
Step 2: Now, select all the items and name your list by writing it down in the name box.

Step 3: Select the cell where you want to create the dropdown list and click on Data –> Data Validation  in the ribbon.

Step 4: In the Data Validation dialog window choose List in the Allow: field and write down the name of the list that you gave in step 2 with an equal to (=) sign in front of it in the source field. For e.g. =Department.

Step 5: Click on the OK button.
Your selected cell will now have a drop down list and will now accept only the values that’s present in it. Even if a user tries to enter a custom value Excel will throw an error instantly. You can now copy and paste the drop down cell to any other cell to create the copy of the list

One of the major setback to this kind of approach is that you cannot delete the root list at any moment as it’s the data source for the drop down list you create. If you don’t want to show the root list on your workbook, you will have to provide all the data in the Source field, the one mentioned in step 4, manually separated by a comas(,).


Friday, January 27, 2012

How to Export Microsoft Communicator Contacts

Microsoft Communicator is an all-in-one communication program that combines instant messaging, voice calls, video conferencing and desktop sharing. You can contact anyone anywhere and collaborate on tasks. Just as you would in an email program, you can store information for all of your contacts. Microsoft Communicator does not have a specific function that allows you to directly export contacts and save them as a backup. You can work around this, though, by saving the information in Excel.


Navigate to the file in this location: C:\Documents and Settings\ USERNAME\Local Settings\Application Data\Microsoft\Communicator\ presence_User_Name_Company_Com.xml. This file has your contacts listed in a single column.

Right-click the file and select "Open With." Select Microsoft Excel.

Choose how you want to open the file in Microsoft Excel. For example, you can choose to open it as a read-only workbook, which will put the data into a table.

Click "File" and "Save As" to save the file on your computer.

Related Post :-
How To Create a Dot Plot in Excel
How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Thursday, January 26, 2012

How To Create a Dot Plot in Excel

A Dot Plot or Dot Chart is one of the most simple types of plots and they are very easy to create in Excel without having to use a Chart object. The trick is to use the REPT() function to display the dot plot either horizontally or vertically. I will explain how this is done and you can download the Dot Plot Example file to see how I created the dot plots on this page.

 Horizontal Dot Plot

I like board games. The example dot plot below shows the number of times out of 50 that I rolled a 1-6 with a single die. Actually I cheated because these values were randomly generated in Excel (see the example file). But it demonstrates the point.

A horizontal dot plot is probably the easiest type to create. Just list the category labels in column A. Then in column B enter the corresponding numbers. To create the dots for the dot chart in column C enter the formula =REPT("•",B1) or =REPT(CHAR(149),B1) and then copy the formula down. Then, hide column B. Pretty simple, eh?

Vertical Dot Plot

One of the games I like to play is Settlers of Catan. If you're familiar with this game, you may recognize why I used the following example vertical dot plot.

The trick to creating a vertical dot plot is to simply change the orientation of the text within the cells to vertical. Otherwise, the procedure is pretty much the same as the horizontal dot plot.

Spice up the Dot Plot

When you use this approach to create dot plots, you can change the color of the dot chart by just changing the font color. In the example below, I've used conditional formatting in Excel to automatically make the maximum value red.

 Tip: If you want a larger dot without increasing the font size, you can use the WingDing font and the letter l (el) for the repeated character.

Related Post :-
How to Export Microsoft Communicator Contacts

How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Wednesday, January 25, 2012

How to Install Microsoft Office Visio From Zip File

Microsoft Visio is an add-on for Microsoft Office that creates vector graphs and diagrams using Microsoft Excel. Visio is not compatible with Mac OS X or Linux -- it is currently only available on the Windows operating system. Users looking for more advanced functions can use the Professional edition of Visio as it has extra features including diagram types and extra templates.


Unzip the Visio file from the folder. Make sure you have Winzip installed. Download and install it if you do not.

Double-click on the "Setup.exe" file in the extracted folder. Click on "Visio Connector for Near Real Time Monitoring.msi". Click "Next."

Select the folder you want to install the program in by clicking "Browse," or click "OK" to install into the default folder.

Click "Next" when the "Confirm Installation" screen pops up. Wait for program to install fully. A window will prompt you when the installation is complete. You have now installed Microsoft Office Visio.

Related Post :-
How To Create a Dot Plot in Excel
How to Export Microsoft Communicator Contacts

How To Create a Dot Plot in Excel How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Tuesday, January 24, 2012

How To Transform Dull Data With Microsoft Visio 2010

Complex data and impenetrable tables can flummox even the most savvy professional. If information is presented in a dry, dense fashion it becomes much more difficult to assess and analyse resulting in a lack of focus and interest in the user.

Microsoft Visio 2007 eliminates this problem by reinterpreting data in the form of exciting, vibrant diagrams and drawings that convey the sense of the information instantaneously. The visualisations within MS Visio are created using vector graphics, which can be scaled indefinitely without degrading in quality. Therefore the diagrams and drawings always look slick, professional and attention grabbing.

There are many different templates on offer in Microsoft Visio, which not only act as a quick and efficient means of creating data visualisations but also aid the user in establishing their own styles of drawing and diagram. The 2007 version of Visio includes a Getting Started window, which makes the selection of appropriate templates and styles even simpler.

And, as with all programs in the Office 2007 suite, Visio looks far more attractive this time around. The new Data Graphics feature embraces colour coding, icons and data bars which bring a new level of sophistication to the diagrams and drawings that MS Visio is able to produce.

This is not to say that flashy pictures can replace rigorous facts and figures. Data-connected diagrams integrate data with graphics to provide a rounded view of all the information to hand. New Data Link functionality allows a close interrelation of data and image that enables the user to present the full complexity of the information in an eye catching way.

One of the most useful facets of Microsoft Visio is Data Refresh, which essentially means that data stored in Visio diagrams will always remain relevant and up to date. This can either be done automatically or through scheduling Visio to update the information at fixed intervals. Once again MS Visio takes care of an issue that would previously have to have been dealt with manually. In today's time pressured environment this automated refreshing of data removes one more potential headache for the user.

MS Visio also makes use of Pivot Diagrams, which are an offshoot of the Pivot Tables of other Microsoft programs like Access and Excel. The ability to manipulate data in this visual form really brings to life cold, hard facts and figures as well as allowing a more detailed analysis of complex data and information.

In a highly competitive business world presentation is king. How you convey data and information is a crucial foundation for success and marks your company out as professional, vibrant and polished. Therefore it is a great benefit to have Microsoft Visio to do the hard work for you. So take the time to fully get to grips with everything that the program can do for you and enroll on a training course. Once completed you will be able to transform the most prosaic data into fresh, exciting new forms with Visio's incredible versatility and expanded functionality.


 Related Post :-
How To Create a Dot Plot in Excel
How to Export Microsoft Communicator Contacts
How to Install Microsoft Office Visio From Zip File
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Monday, January 23, 2012

How to Add a Traditional Header and Footer in Microsoft Visio 2010

This is a quick post to help users find the traditional header and footer functions in Microsoft Visio 2010. I had tremendous trouble finding it (Google searches failed to help me find the exact function I was looking for), so I am posting in hopes that this will help others find what I was looking for.
Up until recently, I’ve worked in Microsoft

Visio 2007 to produce design documents for my job. Some developers preferred having a header and/or footer on the documents to say the revision number and date. In Visio 2007, this was easily accessible via the View menu (View > Header and Footer).

Visio 2010 has been changed to include Microsoft’s tabbed toolbar, known as the Ribbon. In general, it does a pretty good job of grouping functions, but it removed the Header and Footer option from the View menu/tab.

There’s a new feature that lets you create a master background page, which is definitely more functional than the previous Header and Footer I was using. However, I had ported some files from 2007 and needed to adjust (or remove) the header and footer from these files, and the new background feature didn’t help.

I ended up stumbling upon the Header and Footer menu by pure chance. It can be found via the following steps:

1. Click the File tab
2. Click on the Print option
3. Within the Print option, choose Print Preview
4. From here, choose Header & Footer in the toolbar

Again, I don’t expect this post to be relevant to most people, but I wanted to post it for anyone who can’t seem to find it otherwise (including by looking at the Support files — bad Microsoft!).

 Related Post :-

How To Create a Dot Plot in Excel
How to Export Microsoft Communicator Contacts
How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010

How to Use MS Visio ?

Microsoft Visio (formerly known as Microsoft Office Visio), is a commercial diagramming program for Microsoft Windows that uses vector graphics to create diagrams. The current version, Microsoft Visio 2010 for Windows, is available in three editions: Standard, Professional and Premium. Unlike the core Office 2007 applications, Microsoft Visio 2007 did not feature the Ribbon user interface, but Microsoft Visio 2010 does. Visio is not developed for the Mac OS X or Linux operating systems. Due to a proprietary Visio file format, few Mac OS X or Linux diagramming programs can read Visio files. Omnigraffle Pro on the Mac can read and write Visio files.

Microsoft Office Visio is a software package used to create diagrams such as business process flowcharts, workflow diagrams, building site diagrams, database models, network maps, UML diagrams and state diagrams. Visio is considered a part of the Microsoft Office suite of products, but it is not bundled with any of the Microsoft Office packages. Visio comes in Professional and Standard

From the left-hand side of the screen in Visio, click on the name of the template you wish to use. For example, "Flowchart" or "Maps and Floorplans".

Select a template from the list of featured templates. Click on the radio button corresponding to the measurement units you wish to use (US units or Metric), and click on the "Create" button.

Click on the categories on the left-hand side of the screen to display options in a category. For example, "shapes," "arrow shapes" and "backgrounds." Click on the object you wish to add, and drag it to the workspace. Alternatively, items can be added by using the "Insert" menu item.

Use the "Format" menu item to add options such as text, fill, corner rounding and shading.

Related Post :-
How To Create a Dot Plot in Excel
How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Friday, January 20, 2012

How to put watermark In Word 2010

Watermark lets user to mark the document as private, confidential, and write any text that informs about the usage & credibility of the document. Either text or image can be include as watermark, that appear on printed page to mark it for specific use. It could be an emblem of some brand, logo of a company, monogram of a product that you want to include as watermark. In Word 2010, using Watermark feature would be helpful to inform audience of your document about the constraints over the usage you have applied. Word supports both text and image watermarks.

Launch Word 2010, open a document on which you want to show Watermark, and navigate to pag layout tab.

Now From Watermark option , select an appropriate watermark to apply it over.

Here you can see the watermark on the document.

Now if you want to show watermark with custom text, from Watermark options, click Custom Watermark.

You will reach Printed Watermark dialog. Under Text watermark and from Text, enter text you want to show as watermark in the document, as shown in the screenshot below. Click OK to continue.

You will see the custom watermark showing on the document.

Now for inserting image instead of text as watermark, click Custom Watermark from Watermark menu. Now enable Picture watermark option, and click Select Picture. Select the image you want to include as watermark and click Insert.

You can see the path of the image file you chose, now click OK to proceed further.

You will see watermark image on the document, as shown in the screenshot below.

You can also check out previously reviewed guides on Word 2010 Mail Merge & Embed YouTube Videos in Word 2010.


Related Post :-
How To Create a Dot Plot in Excel
How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010 

Thursday, January 19, 2012

How-To Use Word 2010 As a Blog Editor

Word 2010 can also be used as a tool for publishing your blog post that is as a blog editor.  To start publishing, navigate to New menu –> select Blog post

If you have not already registered your blog with Word 2010 then you need register by following below steps

Click on on Register now button and select the your blog provider, in this example we are going for WordPress and the provider

Enter your blog post URL and the account information of your blog.

It also provides option to specify your image server, this can be done by using the Picture options.

We are going with the default value as My blog provider. Click Ok to continue with the blog registration. The following warning dialog box would be displayed, Click Yes to continue.

Account registration confirmation would be displayed as shown below. Click Ok to Continue

Enter your blog post title and the content to be published.
To specify the category for your blog post, Click on the Insert Category button. This should display Category field as shown below, select the required category for the post.

Click Publish button to publish the blog post. If you want to publish the post as a draft, then you can select Publish as draft option using the drop down

After successful publishing, the following confirmation message would be displayed


Related Post :-
How To Create a Dot Plot in Excel
How to Install Microsoft Office Visio From Zip File
How To Transform Dull Data With Microsoft Visio 2010
How to Add a Traditional Header and Footer in Microsoft Visio 2010

Wednesday, January 18, 2012

How To Solve When Microsoft Word Document Continuously Repaginates?

Microsoft Word meting out use facial appearance a social class moreover repeated repagination story headed for side afterward at that moment surprise a page. This bottle repaginate a provide evidence taking place the starting point of its margin size, side size, also not many settings. next to times, you say a provide evidence repaginates taking place its identifiable continuously. in the function of a result, you find a provide evidence together with enlarged digit of pages. incessant repagination frequently indicates a degraded document, which requires Word Repair solutions. Suppose, a client creates a record in the midst of ‘X’ numeral of pages. in imitation of with the file representing significant time, unexpectedly individual day, the client experiences with the intention of the provide evidence starts repaginating at what time the client scrolls down. The numeral of pages clothed in the record increases headed for 10 headed for 20 era the creative number, X. Cause: being mentioned, expected repagination shows corruption of Word document. Solution: headed for decipher the problem, client bottle appraise fork rotten social class repagination. representing this, individual requirements headed for click ‘Tools’ | ‘Options’ | after that elite ‘General’ tab. client bottle at that moment cloudless rotten the ‘Background repagination’ option. clothed in Word 2007, client requirements headed for in the beginning belief the provide evidence all the rage ‘Draft’ mode, click ‘Office button’ as a consequence at that moment ‘Word options’. Next, it bottle click ‘Advanced’ tab along with cloudless the opportunity all the rage ‘General’. proviso the glitch continues, a Word client should:Open the degraded provide evidence in the midst of ‘Open along with Repair’ opportunity
  • Insert or carbon copy the glitch record all the rage a new to the job documentli>
  • Save the record popular RTF formatli>
  • Try headed for candid the record by a discrete applicationli>
  • Restore the record commencing the keep on open backupli>
  • Use a third-party value headed for Repair Word Fileli>ul>A Word Recovery software bottle examine the degraded record with intense scanning algorithms also refurbish its subject matter safely. These utilities comprise interactive exhibit with the intention of facilitates the recovery deal with with no trouble in addition to smoothly. You bottle manipulate these goods all the rage some rank of record corruption problems. Also, these goods are straightforward headed for install. in the midst of far along features, the software are accepted amongst Microsoft Word users. 

Tuesday, January 17, 2012

How to Stop Auto-Correcting Ordinal Numbers in MS Word

Depending on your configuration, Microsoft Word 2003 may automatically change keyed-in ordinal numbers such as 1st and 2nd with superscripted counterparts.This post provide microsoft word support to stop auto correct Ordinal Numbers

To toggle this behavior:

1. Select "Tools" - "AutoCorrect Options".

2. When the "AutoCorrect" multi-tabbed dialog box appears, click the "AutoFormat" tab.

3. Check or uncheck "Ordinals (1st) with superscript" as desired.

4. Click the "AutoFormat As You Type" tab and repeat the above step.

5. Click "OK" to close the dialog box.

How to Set and Clear Notes in Microsoft Office Communicator

Setting a note on the Office Communicator is really a useful stuff where you can put your thoughts, your status etc. for example you are going on leave for a week you can put that in your note so that people who have added you in their list can see that. Also I have seen most of my friends who would keep changing their notes by displaying thoughts for the day.
Now let’s see how to set notes, Open you Microsoft Office Communicator and Click Connect -> My Status -> Set Note…

You will get the window as shown below where you can type the text whatever you want to and click OK. Now your note has been set and the people can see this on their Office Communicator.

When you want to clear this, open you Microsoft Office Communicator and Click Connect -> My Status -> Clear Note… which will clear you note.


Monday, January 16, 2012

How to take a Screenshot in Microsoft Word 2010

Here’s an interesting piece of feature in Word 2010 that lets you take screenshot screenshots and insert them directly in to your WOrd Document .
This feature is part of the Ribbon in the Word 2010 .
To insert a screenshot , click the Insert tab on the Ribbon and then the option Screenshot .

The Screenshot options displays the available windows where the screenshot can be taken .
Once the screenshot is taken , the picture is automatically inserted in to the document .

Friday, January 13, 2012

How To Lock your Document in Word 2010

If you are working a very important document, someone such as your children or your classmates close your document, that's quite bad. Word 2010 provide a number of ways of protecting document from any unauthenticated source. Here we will introduce some methods of them. One of them is just locking down the content of the document with a single click. And the other is a litter complex, but absolutely not confusing. 

Follow This ............. 

Before click the button, we should make sure the button apparent on the Word Quick Access Toolbar. Launch Word 2010, navigate to toolbar and from small drop down button, select More Commands. Just like the followed figure.

Then you will get a Word Options dialog box. Go Choose commands from>All Commands, and you can see all cammands. Next, scroll down the list, find eht lock command and click on it. Select the buuton Add>>. Now you can see the lock button is on Quick Access toolbar pane. Just hit OK.

After these operations, the Lock button in the Quick Access toolbar. 

Click the button, and no one can write, edit, or modify. And click it again, the document is unlocked.

Thursday, January 12, 2012

How to Use Office 2010 on Windows and Non-Windows Mobile

Microsoft Office 2010 has introduced Office 2010 mobile version for Windows and non-windows Mobile users. They are Office Mobile 2010 and Office 2010 Mobile Viewers mobile version. So, you can enjoy a different experience to use Office 2010 on Windows or non-Windows Mobile. Office Mobile 2010 is released for Windows Mobile and Office 2010 MobileViewers is for non-Windows platform Mobile. No worries about to use Office 2010 on Windows or non-Windows Mobile.

Use Office 2010 on Windows Mobile

The name of Office 2010 in Windows Mobile is Office Mobile 2010. No matter your Windows Mobile is v 6.5 or later, you can use SharePoint Workplace to link to the SharePoint serve to access related documents.

Note: The visited SharePoint documents will be automatically added to the Recent Documents folder. If the recently visited documents are not the presentations but the contacts link, then the link will be added to the Recent Link folder.

If you want to visit the new place, you just need to enter the URL of the sever in the address bar with your Windows Mobile. Now you can freely and easily open the Recent Document and the Recent Links by just a click.

When using Office 2010 in Windows Mobile, the users can directly open the link in their E-mail. So you can fix the some documents' Pin on the top or send the links to others.

Use Office 2010 on Non-Windows Mobile

If you are using non-Windows Mobile smart phone, you can still use Office 2010 by using Office 2010 MobileViewers. They are Word, Excel and Powerpoint Office 2010 MobileViewers.

The steps are very similar to use Office 2010 on desktop. You can reference the other guide on how to use Office 2010 MobileViewers when you meet any difficult in using Office 2010 in non-Windows Mobile.