Scribd
Upload
12 views3 pages

Microsoft Office Guide: Word, Excel, PowerPoint

The document outlines features and functions of Microsoft Office programs including Word, Excel, and PowerPoint. Word allows for formatting text, creating tables, adding watermarks and pictures. Excel enables creating tables, using formulas and functions for calculations, creating pivot tables and charts, conditional formatting, sorting and filtering data. PowerPoint assists with creating presentations on various topics and setting up slideshows with video, audio, and links. All the programs provide shortcuts and access to full menus.

Uploaded by

Narendra Dewangan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views3 pages

Microsoft Office Guide: Word, Excel, PowerPoint

The document outlines features and functions of Microsoft Office programs including Word, Excel, and PowerPoint. Word allows for formatting text, creating tables, adding watermarks and pictures. Excel enables creating tables, using formulas and functions for calculations, creating pivot tables and charts, conditional formatting, sorting and filtering data. PowerPoint assists with creating presentations on various topics and setting up slideshows with video, audio, and links. All the programs provide shortcuts and access to full menus.

Uploaded by

Narendra Dewangan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MICROSOFT OFFICE

M S OFFICE WORD

1. TEXT LETTER
2. FORMATING TEXT AND TAB SETTING
3. TABLE CREAT
4. COLORFULL PAGE WATER MARK
5. PICTURE UPLOAD PAMPHALET
6. A TO Z SHORTCUT KEY
7. MAILING AND ID CARD
8. PASSWORD SETTING
9. TRAC CHANGE AND DOCUMENT COMPARE
10. ALL MENU

MS OFFICE EXCEL

1. TABLE CREAT
2. FORMULAS :-
i. SUM, SUMIF
ii. MIN
iii. AVERAGE
iv. MAX
v. LEN
vi. ODD , EVEN
vii. TABLE CREAT
viii. COUNT, COUNTA, COUNT IF,
ix. MULTIPLY, PERCENTAG
x. VLOOKUP
xi. HLOOKUP
xii. DROP DOWN LIST
xiii. CONSOLIDATE
xiv. DATA VALILDATION
xv. WHAT-IF ANALYSIS (DATA TABLE , GOAL SEEK , DATA
TABLE)
xvi. DATA ENTRY (ADD FORM)
3. PIVOT TABLE, CHARTS
4. CONDITINAL FORMATING
5. SORT & FILTTER
6. TRACE PRECEDENTS, TRACE DEPENDANCE
7. IMPORT DATA {GET EXTRANAL DATA- I)ACCESS (II) WEB (III)
TALLY
8. TEXT TO COLUMNS , DATA GROUP,UNGROUP , SUBTOTAL
9. SHORTCUT KEY
[Link] MENUS
M S OFFICE POWER POINT

1. PROJECT CREAT
I) CAR PRESENTATION
II) MOBILE SHOP
III) COMPUTER PROJECT

2. SONG AND VIDEO SETTING


3. LINK SET
4. KBC
5. SLIDE SHOW (HIDE, UNHIDE)
6. SHORTCUT KEY
7. ALL MENU
MS OFFICE EXCEL

You might also like