INDEX

Ms office
Ms powepoint Ms word Ms excel
Introduction
Elements of presentation Introction Introduction
Steps to create a presentation , Features
Features
change a layout Create a document
Saving a presentation, opening an
Print a document
Opening a worksheet
existing presentation
Adding a new slide , adding a
Opening an existing document Formatting toolbaar
duplicate slide Saving a document
Entering data
Printing a presentation Page setup
Applying a design template Font style Deleting
Sorter view Page break
Replacing data
Steps to insert slides from another Find and replace text
ppt Saving a worksheet
Bookmark & Watermark
Insert picture
Slide show
Increase and decrease documents Printing a worksheet
Symbols in ms word
Rehearse timings
Customize an animation Header & footer

Adding transition Mail merge

Changing background
MS office
Microsoft Office, or simply Office, is a family
of client software, server software, and services
developed by Microsoft. It was first announced
by Bill Gates on August 1, 1988, at COMDEX in
Las Vegas. Initially a marketing term for an
office suite (bundled set of productivity
applications), the first version of Office
contained Microsoft Word, Microsoft Excel, and
Microsoft PowerPoint.
MS powerpoint
Introduction
MS Powerpoint provides a systematic display of information
along with graphics, movies, sound, etc. A collection of slides
arranged in sequential manner to convey all give information is
called presentation. MS Powerpoint is a powerful communication
tool to prevent ideas through visual aids . A present action can
be presented on a big screen by attaching a multimedia
projector to a computer .
Powerpoint 2010 provides new ribbon interface to locate certain
commands in easier say . Improved picture crop feature , crop
the picture easily using aspect ratio fill crop option make picture
cover at the edge of the shape where come, it make the picture
edge fit inside of the shape . Screen capturing is one of
important feature , which capture screen shots in order to use
them into the presentation .
 Elements of powerpoint
Title Bar
The Title bar generally appears at the top of the screen. The Title bar displays the title of the
current presentation.

Menu Bar
The Menu bar displays the menu. You use the menu to give instructions to PowerPoint.

Standard and Formatting Toolbars

PowerPoint has several toolbars. Toolbars provide shortcuts to menu commands. The most
commonly used toolbars are the Standard and Formatting toolbars.

Rulers
Rulers are vertical and horizontal guides. You use them to determine where you want to place an object.
They are marked in inches.

Placeholders
Placeholders hold the objects in your slide. You use placeholders to hold text, clip art, and charts.

Status Bar
The Status bar generally appears at the bottom the screen. The Status bar displays the number of the
slide that is currently displayed, the total number of slides, and the name of the design template in use or
the name of the background.
Outline Tab
The Outline displays the text contained in your presentation.
Slides Tab
The Slides tab displays a thumbnail of all your slides. You click the thumbnail to view the slide in the Slide
pane.
View Buttons
The View buttons appear near the bottom of the screen. You use the view buttons to change between
Normal view, Slider Sorter view, and the Slide Show.
Drawing Toolbar
The Drawing toolbar generally appears near the bottom of the screen. It contains tools for creating and .
Task Pane
The Task pane enables you to select the specific task you want to perform.
Vertical Splitter Bar
You can click and drag the vertical splitter bar to change the size of your panes.
Minimize Button
You use the Minimize button to remove a window from view. While a window is minimized, its title appears on
the taskbar.
Maximize/Restore Button
You use the Maximize button to cause a window to fill the screen. After you maximize a window, if you click
the Restore button, the window returns to its former size.
Close Button
You use the Close button to exit the window and close the program.
 Creating a new presentation
To create a new presentation , steps are

Step 1 Click on the file tab and than select the backstage view the screen will
open .

Step2 -Choose Blank presentation on may template on Themes as per the

requirement from the Available Template Of Themes . After making the
appropriate select click on create button given ay the right side of the backstage
views To Change the layout of
slide
Once the presentation has been created it's layout can be changed as per the
requirements of the user.

To change the layout of the slide , steps are

-Step- 1. Right click on the blank area of the slide.

Step- 2 Click on layout option .Step-& Click on the desired one to change
layout of slide
 Saving a presentation
The steps to save the presentation are –

Step- 1. Select save option from Backstage view of the file tab. As dialogue box is displayed
click on save button present an the quick Access button or press ctrl + S key combination .

Step2. Enter the file name.

Step [Link] on the save Button.

Opening an existing presentation

Steps to open existing presentation includes-
Step-1 Click the file tab.

Step-2 Click on open option from the Backstage view.

Step- 3. Open dialog box.

Step- 4. Choose the existing presentation from different [Link] Choose

the file you want to open and click on open button.
Saving an presentation
 Adding a new slide
To create a new slide

1. Choose Insert > New Slide from the menu

2. Click the New Slide button .

Or Press Ctrl-M.

Adding a duplicate slide

[Link] the slide or slides you want to duplicate.

[Link] Edit > Duplicate from the menu.

Or Press Ctrl- D.
 Printing a
presentation
To print:

[Link] File >Print Preview from the menu. The Print Preview area will open.

[Link] the down arrow next to the Print What field.

[Link] what you would like to print.

[Link] the Print icon. The Print dialog box will open.

[Link] whether you want your slides to print in color, grayscale, or black and white. If you
are using a black and white printer, choose black and white. You will use less ink or toner.

[Link] whether you want your slides to print vertically or horizontally.

 Apply a Design Template

Design templates provide attractive backgrounds for your PowerPoint slides.

To apply a design template:

[Link] Format > Slide Design from the menu.

[Link] the Slide Design icon .
3. Design templates will appear on the right side of the screen.

To apply a design template to all of the slides in your presentation do one of the
following:

1. Click on the design template.

2. Right-click on the template. A menu will appear. Choose Apply to All Slides.
 Sorter View

After you have created your PowerPoint slides, you can move, cut, copy,
paste, duplicate, navigate, and view them in Sorter view.

To view the slides in Sorter view, do one of the following:

• Choose View > Slide Sorter from the menu.
• Click the Slide Sorter View icon.
 Steps to insert slides from another presentation

[Link] the left pane where you see thumbnail images of your slides, click in-between the slides
where you want to add the imported slide. A red line will appear as seen in the screenshot
below between slides 4 and 5.

[Link] click on New Slides under the HOME tab and select Reuse Slides from the bottom of
the list.

3.A new pane will appear on the right, which will ask you to locate the file you want to obtain
the new slides from. Click Browse and then click Browse File in the drop-down menu that
appears.

[Link] you locate the file, thumbnails of the presentation slides will appear on the right pane
as shown below.
To insert a picture from a
file:
[Link] the Insert tab,
then click
the Pictures command in
the Images group.

2.A dialog box will appear.

Locate and select
the desired image file,
then click Insert.

[Link] picture will appear

on the currently selected
 Slide show

Start and End a Slide Show

[Link] the Slide Show tab on the ribbon.

[Link] From Beginning or From Current [Link] can also

press F5 on your keyboard or click the Slide Show button in the status
bar to start the presentation.

[Link] exit the presentation and return to normal view, click

the Options button.

[Link] End [Link] the Escape key also ends the presentation.
 Rehearse timing

[Link] the Slide Show tab and in the Set Up group,

select Rehearse Timings.
[Link] Recording box will launch. You can use the
options to click through the slide show and pause it.
[Link] done recording, a dialog box will launch asking
if you would like to save the timing. Click Yes to save
the new slide timings.
Customize an Animation
[Link] an object with an animation applied.

[Link] the Animations tab.

[Link] the Effect Options button.

4. Select an effect option.

 Adding transitions to
slide
To add a transition:
[Link] the desired slide, then click
the Transition command on the toolbar.

[Link] Motion pane will appear. Underneath Slide

Transition, open the drop-down menu; then, select a
transition.

[Link] transition will be applied to the current slide. You

also can adjust the speed of the transition or apply the
same transition to all slides.
 Changing background
You can also adjust the slide background in the Master view.

[Link] Slide Master view, select the slide master or one of the
layouts.

[Link]-click the slide and select Format Background.

[Link] the [Link] options that appear in the Format

Background pane will vary depending on which theme you are
using. You will frequently see Fill, Hide background graphics,
Color, Transparency, Line, and Insert Picture.

[Link] the Close button in the Format Background pane.

[Link] the Close Master View button.

MS Word
Introduction
Microsoft Word is a word processor published by Microsoft. It is one
of the office productivity applications included in the Microsoft Office
suite. Originally developed by Charles Simonyi and Richard Brodie, it
was first released in 1983.
Microsoft Word is available for Microsoft Windows, Apple macOS,
Android, and Apple iOS. It can also run on the Linux operating system
using WINE.

Microsoft Word allows you to create professional-quality

documents, reports, letters, and résumés.
List of Microsoft Word Features

Home
This Feature of MS word has options like font colour, font size, font
style, alignment, bullets, line spacing, etc. Additionally, all the basic
elements which one may need to edit their document is available
under the Home option.
Insert
You can enter tables, shapes, images, charts, graphs, header, footer,
page number, etc., in the document. These Features of MS word are
available in the “Insert” category.
Design
You can create or select the template or the design under the
Design Tab in which you want your document to be by using this
Features of MS word. Moreover, choosing an appropriate tab will
enhance the appearance of your document on MS Word.
Page Layout
This Features of MS word under the Page Layout tab comes
options like margins, orientation, columns, lines, indentation,
spacing, etc.

References
This tab is the most useful feature of MS word for those who are
creating a thesis or writing books or lengthy documents.
Options like citation, footnote, table of contents, caption,
bibliography, etc. are present under this tab.

Review
Spell check, grammar, thesaurus, word count, language,
translation, comments, etc., everything is trackable under the
review tab. Additionally, it benefits those who review their
documents in Microsoft Word.
 Create a new document
[Link] the File tab.

[Link] New.

[Link] Blank document.

A new, blank document is created in a

new window.
Or

Press Ctrl + N to open a new blank

document.
 Print a document
Click the File tab.

Click Print.

Examine the print preview on the right side of the screen to

ensure the document appears correct.

Select the correct printer by clicking the Printer list arrow

and selecting it from the list.

Adjust the printer settings using the options below the

printer, described in the following table.

Set the number of copies in the Copies text field.

Click Print.
 To open an existing document:

[Link] to Backstage view, then click Open.

[Link] Computer, then click Browse.

Alternatively, you can choose OneDrive (previously
known as SkyDrive) to open files stored on your
OneDrive.

[Link] Open dialog box appears. Locate and select

your document, then click Open.
 Saving a Document

Step 1: Click on the File Menu.

Step 2: Go to the Save or Save As button provided.

Step 3: Select the location where you want the file to be saved.

Step 4: Provide a name to the file or use the default one.

Step 5: Click on the Save button

 Page setup

To change page orientation:

[Link] the Layout tab.
[Link] the Orientation command in the Page
Setup group.
3.A drop-down menu will appear. Click
either Portrait or Landscape to change the page
orientation.
To change
[Link] the page
page size:
orientation of the document will be
Word has a variety of predefined page sizes to choose from.
changed.
[Link] the Layout tab, then click the Size command.
2.A drop-down menu will appear. The current page size is
highlighted. Click the desired predefined page size.
[Link] page size of the document will be changed.
 Font Style in MS Word
The basic steps to change the font of a text in a document are
given below;

•Select the text you want to modify

•Select the Home tab and locate the Font group

•Click the drop-down arrow next to font style box

•Font style menu appears

•With a left click select the desired font style

•If you want to change the font to bold or italic, click the 'B' or 'I'
icons on the format bar.
 Page break
Insert Page Breaks

A page break is a special marker that will end the current page and start a new one.

[Link] to place your cursor where you want to start a new page.

[Link] the Insert tab.

[Link] necessary, expand the Pages group by clicking it.

[Link] the Page Break button.

A page break is inserted, and any text after that point is moved to a new page.
 Find text
[Link] Find on the Home .

[Link] in the Search document box in the Navigation pane and type the text you want to find.

[Link] a search result to jump to it in the document.

You can use the arrows under the search box to jump to the Previous or Next search result.

[Link] Close when you're finished.

Replace text
[Link] Replace on the Home tab

[Link] the word you need to replace in the Replace with text field.

[Link] a replacement option.

• Replace: Replaces the first instance of the word. Keep clicking to fix them one at a time.
• Replace All: Fixes all instances of the word at once.

[Link] OK.

[Link] Close when you're done.

 Bookmark Watermark
[Link] or highlight a location, Step 1: Open or Create a new
picture, or text in your document. Word document in which you
want to insert a Watermark.
2. In the "Insert" tab on the ribbon
menu, within the "Links" group Step 2: Go to the Page
select "Bookmark.“ Layout tab on the Ribbon and
click on the Watermark option
3. Type a name for your bookmark and in the Page
click "Add." Background section.

4. To create a link to the bookmark Step 3: The following window

(such as in a list or table of contents will appear on the screen. Select
at the top of the document), highlight the Watermark that you want to
the text you'd like it to link from insert in the Word document.
and "Hyperlink" from
the "Insert" tab. The screenshot below shows that
a Watermark is inserted in the
5. Select "Place in This Word document.
 Increase and decrease indents

The Increase Indent button The Decrease Indent

button moves the paragraph
adds a 0.5” (1.27cm) indent at
one tab stop to the left. Tab
the left margin for the entire stops are every half inch by
paragraph (not just the first default; however, you can change
line). them.
Increase and Decrease Indent Shortcut Keys

Description Shortcut Keys

Increase Indent Ctrl+M

Decrease Indent Ctrl+Q

 Symbols in MS Word

Microsoft Word has a special features

called symbols in which user can insert
many different types of symbols in the
document.
MS Word has a variety of symbols, special
characters, fractions, languages, etc. We
can insert the symbols and special
characters with the help of the Symbol
dialog box present in MS Word.
 Header and footer
Insert a header or footer
•Go to Insert > Header or Footer.

•Choose the header style you want

to use.

•Add or change text for the header

or footer.

•To eliminate a header--like deleting

it on the title page--select it and
then check the Different First Page
box.

•Select Close Header and Footer or

Mail Merge
 MS EXCEL

Introduction
MS Excel is a commonly used Microsoft Office application. It is
a spreadsheet program which is used to save and analyse
numerical data.
 Features of
excel
•Home
• Comprises options like font size, font styles, font
colour, background colour, alignment, formatting
options and styles, insertion and deletion of cells and
editing options
•Insert
• Comprises options like table format and style,
inserting images and figures, adding graphs, charts
and sparklines, header and footer option, equation
and symbols
•Page Layout
• Themes, orientation and page setup options are
available under the page layout option
•Formulas
• Since tables with a large amount of data can be
created in MS excel, under this feature, you can add
formulas to your table and get quicker solutions
•Data
• Adding external data (from the web), filtering
options and data tools are available under this
category
•Review
• Proofreading can be done for an excel sheet (like
spell check) in the review category and a reader can
add comments in this part
•View
• Different views in which we want the spreadsheet to
be displayed can be edited here. Options to zoom in
and out and pane arrangement are available under
this category
 Open a Workbook

[Link] the File tab.

[Link] [Link] Ctrl + O to quickly display the Open tab of
the Backstage view.
[Link] the location where the file is [Link] can choose
from:
1. Recent: Recent files you've worked on.
2. Shared with Me: Files others have shared with you on
OneDrive or SharePoint Online.
3. OneDrive: Microsoft's cloud-based storage.
4. This PC: Browse files on your local computer.
5. Browse: Opens a dialog box where you can browse
through your computer's folders, drives, and network
shares.
[Link] the file you want to open.
[Link] Open.
 Formatting
Toolbar

Click View > Toolbars > Formatting. The

Formatting toolbar appears or disappears.

The Formatting Toolbar contains a

collection of icon buttons that allows
the user to access various formatting
menus such as changing the font or the
paragraph format.
Entering data into an Excel
worksheet
[Link] the cell pointer to the required cell
and then type the data. While you type the
data you will notice that it appears both in the
worksheet (in the example below, the text
appears in cell A1) and in the Formula Bar.
2. Press ENTER to enter the information into
the cell. Your cell pointer will move down to
the cell below.
Deleting and replacing data

•To delete data select the cell containing the data

and then press DELETE.
•To replace data just type directly over the top of
the existing cell contents. The new data will
replace the old.
 Saving a worksheet

Step 1 − Click the File tab and select Save

As option.

Step 2 − Select a folder where you would

like to save the sheet, Enter file name,
which you want to give to your sheet and
Select a Save as type, by default it
is .xlsx format.

Step 3 − Finally, click on Save button and

your sheet will be saved with the entered
name in the selected folder.
 To Print Excel
spreadsheet
To print an Excel worksheet:

[Link] your worksheet, click File > Print or

press Ctrl + P. This will get you to the
Print Preview window.

[Link] the Copies box, enter the number

of copies you want to get.

[Link] Printer, choose which printer to

use.

[Link] Settings, specify exactly what

to print and configure the page
margins, orientation, paper size, etc.

[Link] the Print button.

 Thank
you

Dav college jalandhar