Skip to main content

Posts

Showing posts from November, 2012

How to convert an image or photo into PDF

You can convert an image or photo into PDF format. To covert an image or photo into PDF you must have Adobe Photoshop installed in your system. To convert your photo or image into PDF just follow the few steps ::

1. Right click on your photo or image 2. Go to Open with 3. Photoshop Elements Editor
Your image or photo will be opened in Adobe Photoshop. Or open Adobe Photoshop first and then go to File in the menu bar and then open your image or photo that should be converted into PDF.
4. Go to File on the menu bar 5. Select Save As 6. Click on the small downward arrow to change the Format 7. Select Photoshop PDF (*.PDF, *.PDP) 8. Click on Save 9. Click on Save PDF


How to link an external file in MS word 2007

In Microsoft word 2007 you can connect an external file or link to your word document and the process is called hyperlink. You can link any external file like word document, a PowerPoint presentation, an Excel sheet, an audio or a video file etc. To link an external file you need to follow the steps ::

1. First place the pointer where you want to insert a link  2. Click on the Insert tab on the menu bar (if not selected)  3. On the Link group, click on the Hyperlink  4. Browse the file that to be linked Against text to display: type the desired word that to be displayed as a link


How to increase or change the font size in Microsoft word 2007

To increase the font size in Microsoft word 2007 you need to do the following steps ::
1. First select the font or sentence  2. Click on Home tab (if it is not selected) on the menu bar  3. On the Font group, click on the grow font button or click on the downward arrow of font size and select from the list
Or 
Press Ctrl + Shift + [greater than (>) or dot (.)] on the keyboard



How to insert border & shading in MS Word 2007

You can insert border and shading to your document using border and shading button in Microsoft word 2007. You can insert either border or shading or both using border and shading button. To do so do the following steps :: 

1. First select the texts or lines where you want to apply border and shading  2. Select Home tab on the menu bar (if not selected)  3. On the Paragraph group, click on the small downward arrow of the border button or border and shading button  4. Click on Border and Shading…


Border and Shading dialog box opens. 

On the Border tab, select border style and colour. You can see the preview on the right side. On the Shading tab, choose Fill colour and Patterns  5. Click on O.K

How to give shading or change background colour of text in MS Word 2007

To give shading or change background colour of the text in Microsoft Word 2007 you need to do the following steps :: 
1. First select the text or number  2. Select Home tab on the menu bar (if not selected)  3. Click on the small downward arrow of shading button in the Paragraph group to see more colour  4. choose the desire colour


How to make the text Superscript or Subscript in MS Word 2007

Superscript and subscript refers to number that are positioned slightly higher or slightly lower than the text on the line. You can do this by two ways. To do so you need to follow the steps below :: 
1. Select the text or number that you want to format as superscript or subscript.  2. you need to select Home tab on the menu bar (if not selected) 
for superscript  click X2 in the Font group or Press Ctrl + Shift + = 

for subscript  click X2 in the Font group or Press Ctrl + =

How to change line spacing in MS Word 2007

To change line spacing in MS Word 2007 you have to perform the following steps ::

1. Select the lines first whose line spacing you want to change
2. you need to select Home tab on the menu bar (if not selected)
 3. Click on the small downward arrow of the Line Spacing button in the Paragraph group
4. Select the desire one.
5. If you want to insert according to you then click Line Spacing Options..
6. Change the value
7. Click O.K.

How to insert numbers in MS Word 2007

To insert numbers in your document follow the below steps ::
1. Select the position where you want to insert numbers  2. Select Home tab on the menu bar (if not selected)  3. Click on the small downward arrow of the numbering button in the Paragraph group select the desire one.  4. If you want more numbers click on Define New Number Format… 
5. Click on small downward arrow to select from a list.  6. Click O.K.

What is the difference between Save and Save As

You cannot save your same document with different name simply clicking on Save option. If you want to save your same document with different name you have to click on Save As and then type the desired name every time you want to save the same document. This is the main difference between Save and Save As.

How to insert bullets in MS Word 2007

To insert bullets in your document in Microsoft word 2007 follow the below steps Select the position where you want to insert bullets

1. Select the position where you want to insert bullets 2. Select Home tab (if not selected) in the menu bar 3. click on the small downward arrow of the bullets button in the Paragraph group
4. Select the desired one. 5. If you want more bullets click on Define New Bullet… 6. Click on Picture to select picture bullet or click on Symbol to  7. Select symbol as a bullet 8. Click O.K. 9. Click O.K.









How to hide and see sub menus in MS Word 2007

To hide and see the sum menus in Microsoft word 2007 you need to do the following steps :
To hide sub-menus :
1. Right click anywhere on the Menu barand 2. Select Minimize the Ribbon
Again to see the sub-menus :
1. Right click anywhere on the Menu bar   and 2. Select Minimize the Ribbon


Keyboard Shortcuts For Microsoft Word

Ctrl + N  = To create a new document
Ctrl + O  = To open an existing document
Ctrl + S  = To save the entire document
Ctrl + C= To copy selected text / sentence / entire document
Ctrl + V= To paste text / sentence / entire document
Ctrl + X= To cut selected text / sentence / entire document
Ctrl + P  = To print a document
Ctrl + B  = To make selected text bold
Ctrl + I  = To make selected text italic
Ctrl + U  = To make selected text underline
Ctrl + A  = To select the entire document
Ctrl + F  = To find some similar word / letter from the entire document
Ctrl + H  = To replace some similar word / letter from the entire document
Ctrl + L = To change alignment to left
Ctrl + R = To change alignment to right
Ctrl + E = To change alignment to centre
Ctrl + J = To change alignment to justify
Ctrl + K = To make hyperlink to selected text
Ctrl + Alt + F = To insert footnote to the end of a page of a document
Ctrl + Alt + D = To insert end note to the end of the document

How to change default file save location of MS Word 2007

You can change the default location from My Documents for all document that will be created in future. To do so you need to follow the steps below :: 

1. Click on Office Button (extremely top of the left corner)  2. click Word Options  3. select Save

4. click Browse your location where you want to save all your word file by default against Default file location : (C:\Documents and Settings\HCL\My Documents\SharePoint Drafts\)  5. click O.K.

Watch This Video

How to Change Default File Save Format in MS Word 2007

The file or document you have saved in Microsoft word 2007 is saved with (.docx) format. You can not open those files or documents in Microsoft word 2003. If you want  to open those files or documents in Microsoft word 2003 you need to save those files or documents in (.doc) format. You can change the extension when you save your document or you can change the default extension prior to do anything. Read also : Microsoft Word 2007 full tutorials.

Steps to change the default file save format

Step 1. Click on Office Button (extremely top of the left)
Step 2. click Word Options
Step 3. Select Save
Step 4. Click on small downward arrow to see the list against Save file in this format : (Word document (*.docx). Read also : MS Word 2003 full tutorials.
Step 5. Select Word 97-2003 document (*.doc)
Step 6. Click O.K. Read also : Open Office full tutorials.



Watch This Video

Macro in Microsoft Excel

A Macro in Microsoft Excel can be defined as a program that instructs Excel to perform action. In other words they are programs run by the application for which they are created. MS-Excel poses a feature which can record and play back command Macro. When you record a series of steps, Excel notches the steps and converts them into instructions.
Steps to perform Macro in Excel 2003 ::
Tools > Macro > Record New Macro (Record Macro dialog box appears) > Type the Macro name, also the shortcut key  > OK  (then a step recording dialog box appears) > Write down the structure that you want to be recorded.  > After completing it click stop recording button. > Open another blank sheet where you want the same sheet to be written. Press the Ctrl + and the shortcut key together to run the Macro.

Write down the structure that you want to be recorded. After completing it click stop recording button on the recording dialog box.

What is Macro ?

A Macro in Microsoft word is procedure of recording a certain input sequence (often a sequence of characters) that should be mapped to an output sequence (also often a sequence of characters) according to a defined procedure.

The mapping process that instantiates (transforms) a macro into a specific output sequence is known as macro expansion.

Steps to perform Macro in Microsoft Word 2003 ::

Tools > Macro > Record New Macro  > Type Macro name > OK > after completion of typing click on red button to stop recording.

Write down the structure that you want to be recorded. After completing it click stop recording button on the recording dialog box. You can use the same saved macro whenever you want.


Microsoft Excel Scenarios

A scenarios is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.
Steps to perform scenarios in MS Excel 2003 are ::
Select only data (not heading & item name) > Go to Tools menu > Scenario > Add > Type scenario name > OK > Cell address for changing data > OK > Scenario Values dialog box open, enter the new value > OK > Scenario Manager dialog box opens, click on Summary > Result Cells > OK




Steps to Edit Scenarios in MS Excel 2003
Go to Tools menu  >  Scenarios  >  Click on the  name of the scenarios which you want to edit, and then click Edit  >  Make the changes you want  >  In the Scenarios Values dialog box, type the values you want for the changing cells  &g…