Chapter 2: MS Office Applications – Word, Excel, PowerPoint, Outlook, Access & One Drive

 

 Ms Office Complete Guide All Applications Explained

1. MS Word 

2. MS Excel 

3. MS PowerPoint

4. MS Outlook 

5. MS Access

6. One Note 

7. One Drive

1. MS Word Explanation, Menu Bar & Shortcuts:

What is MS Word?

MS Word is word processing software developed by Microsoft.

It is used to create, edit, format, and print documents.

Uses of MS Word:

Letters 

Reports

Resumes
Notes and Projects

MS Word Shortcut Keys:

Shortcut Key	Function
Ctrl + N	New Document
Ctrl + O	Open File
Ctrl + S	Save
Ctrl + P	Print
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + E	Center Alignment
Ctrl + L	Left Alignment
Ctrl + R	Right Alignment
Ctrl + J	Justify
Ctrl + Shift + >	Increase Font Size
Ctrl + Shift + <	Decrease Font Size

MS Word Menu Bar:

1. File Menu

Used for file-related operations:

New
Open
Save / Save As
Print
Close

2. Home Menu

Used for text editing and formatting:

Font style, size, color
Bold, Italic, Underline
Bullets and numbering
Alignment options

3. Insert Menu

Used to insert objects:

Tables
Pictures
Shapes
Charts
Header & Footer
Page Numbers

4. Layout Menu

Used to change page layout:

Margins
Orientation (Portrait / Landscape)
Columns
Page Size

5. References Menu

Used for academic and professional documents:

Table of Contents
Footnotes
Citations

6. Review Menu

Used for checking and reviewing:

Spelling & Grammar
Track Changes
Comments

7. View Menu

Used to control document appearance:

Read Mode
Print Layout
Zoom

Conclusion:

By learning MS Word, you can create professional documents easily.

Shortcut keys help complete work faster and more efficiently.

2. MS Excel Explanation, Menu Bar & Shortcuts:

What is MS Excel?

MS Excel is spreadsheet software developed by Microsoft.

It is used to store data, perform calculations, analyze information, and create charts.

Uses of MS Excel:

Offices
Banking
Accounting
Data Analysis
Education

Main Features:

Worksheets & Workbooks
Rows, Columns, Cells
Formulas & Functions
Charts & Graphs

Excel Interface:

Workbook – Excel file
Worksheet – Single sheet
Row – Horizontal (1,2,3…)
Column – Vertical (A,B,C…)
Cell – Combination of row & column
Formula Bar – Displays formulas
Name Box – Shows cell address

MS Excel Menu Bar:

1. File Menu

New
Open
Save / Save As
Print
Share
Export (PDF)
Close

Shortcuts:

Ctrl + N, Ctrl + O, Ctrl + S, Ctrl + P

2. Home Menu

Clipboard (Cut, Copy, Paste)
Font formatting
Alignment
Number formats
Conditional Formatting
Insert / Delete cells
Auto Sum, Sort

3. Insert Menu

Tables
Pivot Tables
Charts
Pictures & Shapes

Shortcut: Alt + N

4. Page Layout Menu

Margins
Orientation
Page Size
Print Area

Shortcut: Alt + P

5. Formulas Menu

Common formulas:

=SUM()
=AVERAGE()
=IF()
=COUNT()

Shortcuts:

Alt + = (AutoSum), Shift + F3

6. Data Menu

Sort
Filter
Data Validation
Remove Duplicates
Text to Columns

Shortcut: Ctrl + Shift + L

7. Review Menu

Spelling
Comments
Protect Sheet / Workbook

Shortcut: F7

8. View Menu

Normal View
Page Layout View
Zoom
Freeze Panes

Shortcut: Alt + W

Important Excel Shortcut Keys:

Shortcut	Use
Ctrl + A	Select All
Ctrl + F	Find
Ctrl + H	Replace
F2	Edit Cell
Ctrl + ;	Date
Ctrl + Shift + :	Time
Ctrl + Space	Select Column
Shift + Space	Select Row
Ctrl + +	Insert
Ctrl + -	Delete

Advantages of Excel:

Saves time
accurate calculations
Easy data analysis
Professional reports

3. MS PowerPoint

What is MS PowerPoint?

MS PowerPoint is presentation software used to present information using slides.

Uses:

Education (classes, seminars)
Office meetings
Training programs
Business presentations

Key Features:

Slides & layouts
Images, text, shapes
Animations & transitions
Charts, audio, video

PowerPoint Menu Bar:

1. File Menu

New
Open
Save / Save As
Print
Export (PDF)
Close

2. Home Menu

New Slide
Font & paragraph tools
drawing tools

3. Insert Menu

Tables
Pictures
Shapes
Charts
Audio & Video

4. Design Menu

Themes
Slide Size
Background

5. Transitions Menu

Transition affects
Duration
Sound

6. Animations Menu

Animation affects
Animation Pane

7. Slide Show Menu

From Beginning
from Current Slide

Shortcut: F5

8. View Menu

Normal
Slide Sorter
Notes Page
Zoom

Important PowerPoint Shortcuts:

Shortcut	Use
Ctrl + N	New Presentation
Ctrl + M	New Slide
Ctrl + S	Save
Ctrl + C / V	Copy / Paste
Ctrl + Z	Undo
F5	Start Slide Show
Esc	Exit Slide Show
Ctrl + P	Print

Advantages:

Attractive presentations
Easy to understand content
Time saving
Professional look

4. MS Outlook:

What is MS Outlook?

MS Outlook is an email and personal information management software.

Uses:

Send and receive emails
Calendar (meetings, reminders)
Contacts management
Tasks and To-Do lists

Advantages:

Professional email system
Better time management
secure communication

5. MS Access:

What is MS Access?

MS Access is a Database Management System (DBMS).

Main Components

Tables – Store data
Queries – Search data
Forms – Data entry
Reports – Generate reports

Excel vs Access

Excel → Calculations
Access → large database management

6. MS One Note:

What is One Note?

One Note is a digital note-taking application.

Features

Text notes
Images & drawings
Sections & pages
Cloud synchronization

Users

Students
Teachers
Professionals

---

7. One Drive:

What is One Drive?

One Drive is a cloud storage service by Microsoft.

Uses

File backup
File sharing
Access files anywhere
Safe online storage

Comparison Table:

Software	Use
MS Word	Documents
MS Excel	Calculations
MS PowerPoint	Presentations
MS Outlook	Emails
MS Access	Database
One Note	Notes
One Drive	Cloud Storage

Final Conclusion:

MS Office is an essential software package for everyone.

By learning MS Word, Excel, PowerPoint, Outlook, Access, One Note, and One Drive, students, job seekers, and professionals can work faster, smarter, and more efficiently. 

 

https://wisdomtutorialpoint.blogspot.com/2025/12/chapter-1-basic-computer-knowledge.html