khalid ul islam

8/18/2019 Khalid Ul Islam

1/60

Khalid ul islam| 14-mba-1044


2/60

eaning of s Word :-

Word is the word processing program of the Microsoft Office suite that allows you to create

documents and reports. his tutorial co!ers all of the features you need to get started using M"

Word #00$% #00& '() #010% such as te*t entry% formatting% spell chec+% bulleting% numbering%

and much more. 'lthough +nowledge of how to na!igate in a Windows en!ironment is helpful%

this tutorial was created for the computer beginner.

ail merge:-

We use merge fields to customi,e the content of indi!idual documents. When inserted into your

main document% they contain the indi!idual records that reside in your data source. f Microsoft

Word doesnt find the information it needs by lin+ing merge fields automatically to the headings

in the data source% it gi!es you the opportunity to do so as youre inserting address and greeting

fields or pre!iewing the merge.

How to create mail merge toolbar/

clic+ in mailings tab

select start mail merge

clic+ on start mail merge

lic+ on step by step mail merge wi,ard



3/60

Mail merge

Mail merge dialogue bo* appears.



4/60

"elect document type on which you are wor+ing.

"uppose letter lic+ on letter

lic+ on current document

"elect recipients

reate a new list

Create new head list of mail merge



5/60


6/60



7/60

2re!iew your letter

Preview your letter

Mail merge completed.



8/60

acro :- ' macro is a se3uence word commands and instructions that are grouped together

as a single command and sa!ed by you% to accomplish a tas+ automatically.

create a macro /-

lic+ on !iew toolbar

"elect macros

Macro

lic+ on macro

lic+ on record macro



9/60

Record macro

"elect tool Macro ecord (ew Macro% a dialog bo*.

"pecify the name in the macro name te*t bo*.



10/60

PLAY MACRO!

lic+ on ool Macro% select the macro name and clic+ on un



11/60

Comment: -

(ow you can write comments

"elect the te*t or item you want to comment

lic+ at the end of the te*t

On the re!iew menu% clic+ on comment.

comment

Spelling and Gram mar : -



12/60

o specify a preferred spelling for a word% you add unwanted !ariations of the word are spelling

to the e*clude dictionary.

lic+ on re!iew toolbar

"elect spelling and grammar

"#elling and grammar

hec+ the spelling or grammar



13/60

We can also select the auto correct command.



14/60

Page setup:- 2age setup is a option in which different type of pages are selected.

"teps to go on a page setup/-

• lic+ on page layout of the ms word toolbar.

• lic+ on anyone margins% orientation% si,e% olumns of

2age setup options.



15/60

Table menu :-

he table menu is usually used for creating tables and more options

related to table .

"te#s to create a table !

5o to insert toolbar.

lic+ on the table tab.

nsert or )raw the table



16/60

$able

Protect document:-

2rotect document is a option which is used to sa!e personal documents. t is helpful for +eeping

data safe.

"te#s to go on a #rotect document !

5o on a re!iew toolbar

(ow clic+ on protect document



17/60

Protect document

Auto text :-

'uto te*t is helpful for automatic correction of letter as wanted.

How to create an auto te%t !

1 5o to insert toolbar

# lic+ on 3uic+ part

$ lic+ on sa!e selection to 3uic+ part gallery

Auto te%t



18/60

Hyper lin:-

6yperlin+ is helpful in connecting to internet. )ifferent pages can be uploaded with its help. '

hyperlin+% or simply a lin+% is a reference in a hyperte*t document to another document or other

resource. 's such it would be similar to a citation in literature. 6owe!er% combined with a data

networ+ and suitable access protocol% it can be used to fetch the resource referenced. his can

then be sa!ed% !iewed% or displayed as part of the referencing document

"te#s to create a hy#erlin& !

5o on insert toolbar.

lic+ on hyper lin+.

reate a hyperlin+



19/60

Hy#erlin&

t helps to connect with internet or other file.

o lin+ to an e*isting file or Web page% clic+ 7*isting 8ile or Web 2age under 9in+ to% and then

type the address that you want to lin+ to in the 'ddress bo*. f you dont +now the address for a

file% clic+ the arrow in the 9oo+ in list% and then na!igate to the file that you want.

Hy#er lin&



20/60

!eplace:-

t is the one of the most important function of Ms-word which help us to replacethe data or any particular word which we want to replace in ms word. t is used to replace any

word to another word.

6ome eplace ype the word you want to replace in 8ind what bo* : ype the word you

want to replace with in replace with bo* clic+ on eplace if you want to replace only one

word otherwise clic+ on eplace 'll button if you want to eplace all the words.

re#lace



21/60

"ind :- 8ind +ey is help to finding different data or file needed. t is also the important feature

of Ms word which help us to find out the particular word. We use this dialog bo* for find any

re3uired word or number in the file.

Home 'ind $y#e your word in find what te%t bo% then clic& on find ne%t button

find



22/60

(O $O!

t is the another important feature of ms ; word. his is used to go to the desired page or desired

page number or desired word.

6ome 8ind 5o o.

8irst choose where do you want to go


23/60

Header and footer: -

6eader : 8ooter is used to put repetiti!e information in the top and bottom margins of the

document. ' header consists of te*t or graphics appears of the top of e!ery page.

Create a header and footer !

1 "elect 6eader : 8ooter from the insert menu. Word places the cursor in the blan+ header

space.

# ype the desired te*t in to the header or insert any of the standard functions from the header :

footer toolbar.

$ lic+ on the switch between header : footer icon to switch to the footer.

4 ype the desired te*t into the footer or insert any of the standard functions from the heaer and

footer toolbar.

> lic+ on the close icon of the header : footer toolbar to close the toolbar.

header



24/60

Clic& on footer !

footer



25/60

Header! 6eader is used to put the repetiti!e information in the top.

Header



26/60

'ooter!

'ooter is used to #ut the re#etitive information in the bottom.



27/60


28/60



29/60

eaning of Po#er Point :-

2ower2oint and co!ers the basics of creating simple presentations and editing and formatting the

2ower2oint slides 2ower2oint is a program to help create and present presentations. hishandout introduces the basic features of Microsoft.

2ower2oint creates multimedia presentations to display information in a graphical format. he

tutorial co!ers all of the features you need to get started using Microsoft 2ower2oint% such as

creating slides% applying templates% running your slide show% printing% and much more. 'lthough

+nowledge of how to na!igate in a Windows en!ironment is helpful% this tutorial was

created for the computer beginner. 2ower2oint is graphic presentation software that helps you

present your ideas effecti!ely% in a professional loo+ing manner% through the use of drawings%

charting% outlining and word processing. ' single 2ower2oint presentation file may be used to

generate a slide show% spea+er?s notes% an outline% audience handouts% and Web pages and may

contain animations% !ideo clips% graphics% sound and hyperlin+s.

' 2ower2oint presentation consists of slides that can contain te*t% graphics% charts% and other

data types. When you start 2ower2oint% you can start with a blan+ presentation% or you can begin

from a template or use the 'utoontent Wi,ard.



30/60


31/60

Custom :-

n custom animations are !isual effects applied to individual items on the slide such as graphics%

titles. 'nimations are different than that of transitions which are the mo!ements of the whole

slide.

"elect the te%t in which we want to give the effect

• lic+ on animation• "elect custom animation

• lic+ on effects

• "elect the effect custom



32/60


33/60

Action button:-

t is one of the good feature of Ms power point. With help of this feature we can easily hyperlin+

our current slide to other slide or to hyperlin+ with any program or any file in the system



34/60

Action

'fter ma+ing its lin+ to a file. t loo+s li+e that



35/60



36/60

Hyperlin :-

t?s a most important feature of Ms power point which help us to create a lin+ with internet or

any running email id on the system.

"elect the te%t in which you want to hy#erlin&

5o to insert

"elect hyperlin+

lic+ on hyperlin+

Hy#erlin&



37/60

Slide layout:-

"lide layouts define containers% positioning% and formatting for all of the content that appears on

a slide

Slide layout



38/60

Slide design:-

he Master "lide is the design template or design theme used for the slides within your

presentation. With the help of slide design% we can also gi!e the effect of current slide or all the

slides.

"lide design



39/60



40/60

eaning of s $xcel

!

7*cel lets you de!elop spreadsheets that display data in !arious tabular and !isual formats. he

tutorial co!ers all of the features you need to get started using Microsoft 7*cel% such as entering

data% formatting% cell alignment% fonts% mathematical calculations% functions% and much more. '

spreadsheet is a collection of te*t and numbers laid out in a rectangular grid. Often used in

business for budgeting% in!entory management% and decision ma+ing.he M" e*cel window constitute a menu bar% tool bar% and the other formatting tool bar.

he formula bar consists of a rectangular bo* for entering and editing information as well as help

from e*cels in writing formulas.

How to insert formulae !

o insert a function you ha!e follow the following steps/

1. lic+ on the cell in which you want to insert the function.

#. "elect the option function from insert menu.

$. 'bo!e dialog bo* will appear.

4. "elect the desired function and clic+ on o+ button.

>. he resultant window loo+ li+e this



41/60

8ormula

C%arts :-



42/60


43/60

1- 6ighlight the range of data cells that are re3uired in the chart

#- lic+% nsert% hart

$- Ma+e your re3uired selections using the chart wi,ard

4- lic+ (e*t

>- Ma+e your selection of where you want to place the chart

B- lic+ 8inish

Goal see :-



44/60

5oal "ee+er is part of the CWhat-f 'nalysisC tools in Microsoft 7*cel for performing data

analysis. What-f analysis is the process of studying impact of different !ariables on an outcome

5o to a data toolbar then lic+ CWhat-f 'nalysisC and select 5oal "ee+ from drop down menu.

he 5oal "ee+ dialogue bo* appears .

5oal see+

7nter the cell reference of the spreadsheet cell that has the desired result ne*t to the C"et cell.C

his cell should ha!e a formula in!ol!ing the changing !ariable. 8or e*ample you want to figure

out the number that% when multiplied by si*% gi!es the result . n this case% you select the cell

that defines the product of two numbers.

7nter the desired result in the te*t bo* adDacent to the Co !alue.C n your e*ample% enter .



45/60

7nter the cell reference either by typing or clic+ing the reference button ne*t to CEy changing

cellC the !alue that goal see+ adDusts to reach the desired result. n the e*ample% it is the blan+cell used in the product formula.

lic+ OK to start the program and another window pops up specifying the result

"ormula auditing:-

When we hear the word structure% we often thin+ about the structure of a building. he structure

of a wor+sheet model refers to the way our input assumptions Fdata such as unit sales% price% and

unit costG are used to compute outputs of interest% such as (2H% profit% or cost. he Microsoft

Office 7*cel #00& auditing tool pro!ides an easy method for documenting the structure of a

wor+sheet% which ma+es understanding the logic underlying comple* wor+sheet models easier.

8ollowing functions are used in formula auditing

$race Precedents When you clic+ this button% 7*cel draws arrows to the cells Fthe so-called direct precedentsG that are referred to in the formula inside the selected cell. When you

clic+ this button again% 7*cel adds @tracerA arrows that show the cells Fthe so-called indirect

precedentsG that are referred to in the formulas in the direct precedents

$race )e#endents When you clic+ this button% 7*cel draws arrows from the selected cell to

the cells Fthe so-called direct dependentsG that use% or depend on% the results of the formula in the

selected cell. When you clic+ this button again% 7*cel adds tracer arrows identifying the cells Fthe

so-called indirect dependentsG that refer to formulas found in the direct dependents

Remove Arrows lic+ing this button For the emo!e 'rrows option on its drop-down menuG

remo!es all the arrows drawn% no matter what button or command you used to put them there.

lic+ the emo!e 2recedent 'rrows option on the drop-down menu to get rid of the arrows that

were drawn when you clic+ed the race 2recedents buttonI and emo!e )ependent 'rrows to

get rid of the arrows that were drawn when you clic+ed race )ependents.



46/60

"how 'ormulas o display all formulas in their cells in the wor+sheet instead of their

calculated !alues FDust li+e pressing trlJG.

*rror Chec&ing When you clic+ this button or the 7rror hec+ing option on its drop-down

menu% 7*cel displays the 7rror hec+ing dialog bo*% which describes the nature of the error in

the current cell% gi!es you help on it% and enables you to trace its precedents. lic+ the race

7rror option on this button?s drop-down menu to attempt to locate the cell that contains the

original formula that has an error.

*valuate 'ormula lic+ing this button opens the 7!aluate 8ormula dialog bo*% where you

can ha!e 7*cel e!aluate each part of the formula in the current cell. he 7!aluate 8ormulafeature can be 3uite useful in formulas that nest many functions within them.

'ormula auditing



47/60


48/60

"ilter:-

'ilter



49/60

&alidation:-

)ata !alidation rules in 7*cel automatically chec+ an entry made by a user against rules you

ha!e preset in the wor+sheet. his is helpful when you ha!e formulas that depend on certain

e*pected input from the user. hese formulas can often return errors if the format of the

entered data is wrong.

Protect s%eet:-

7*cel #00& includes a 2rotect Wor+boo+ command that pre!ents others from ma+ing changes to

the layout of the wor+sheets in a wor+boo+. Lou can assign a password when you protect awor+boo+ so that only those who +now the password can unprotect the wor+boo+ and ma+e

changes to the structure and layout of the wor+sheets.

2rotect sheet



50/60

a wor+boo+ does not pre!ent others from ma+ing changes to the contents 2rotecting of cells.

Conditional formatting:-

6ighlight re3uired range of cells

lic+ 8ormat% onditional 8ormatting

Ma+e your selections.

hen press the 8ormat button to set the format and

lic+ OK

Conditional formatting



51/60



52/60



53/60


54/60

he )O" prompt +nown as the command prompt loo+s li+e /PQor)/PQ where @A%A)A represent

the hard dri!e of the computer system. 'll the commands typed at the )O" 2rompt. 7nter +ey is

pressed to !iew the output of the typed command.

"tart All Programs Accessories Command Prom#t +C,-

COMMA/)"!

$o change0Ma&e a folder!

C:\>md folder name



55/60

$o create folder!

C ,- cd folder name

$o clear the screen dis#lay!

C:\>cls



56/60

Copy con:-

his command is used to create a file. "ynta%. C,-co#y con 1'ile

name-.t%t

$o dis#lay the current time

C:\>time



57/60

$o delete a file

C:\>del filename.txt



58/60

$O CR*A$* A '2L*

C:\>edit filename.txt



59/60

$o "how the date

C,-date



60/60

$o 3uit from ms dos

C:\>exit

khalid ul islam

Documents