MS excel
Introduction to Microsoft Excel
👶 For KG Students – Very Simple Explanation
4
🌟 What is Microsoft Excel?
Microsoft Excel is a smart notebook inside the computer 💻
It helps us:
✏️ Write names
🔢 Write numbers
➕ Do addition
➖ Do subtraction
📊 Make charts
📋 Make tables
Excel is like a magic maths book.
📖 Example 1 – Adding Numbers
Teacher asks:
10 + 20 = ?
In Excel we type:
=10+20
Excel shows:
30 ✅
Wow! Excel is very smart!
📖 Example 2 – Student Marks
Let us write:
Excel can tell:
Who got highest marks?
Who passed?
Total marks?
Very easy!
🧱 What Do We See in Excel?
Excel has:
📦 Small boxes → Called Cells
↔️ Letters on top → Called Columns (A, B, C…)
↕️ Numbers on side → Called Rows (1, 2, 3…)
Example:
A1 means:
Column A + Row 1
Getting Started with Microsoft Excel (Beginner Level)
4
📘 1. What is Microsoft Excel?
Microsoft Excel is a spreadsheet software.
It is used to:
Store data
Do calculations
Create tables
Make charts
Manage accounts
👉 Excel is mostly used in schools, offices, shops, banks, and companies.
📘 2. How to Open Excel
🖥️ On Windows:
Click Start
Type Excel
Click Microsoft Excel
OR
Double click Excel icon on Desktop
📘 3. Creating a New Workbook
When Excel opens:
Click Blank Workbook
A new spreadsheet will open
📌 Workbook = Full Excel file
📌 Worksheet = Single page inside workbook
📘 4. Understanding the Excel Screen
Excel has different parts:
🔹 Ribbon
Top menu bar (Home, Insert, Page Layout)
🔹 Columns
Vertical lines (A, B, C, D…)
🔹 Rows
Horizontal lines (1, 2, 3…)
🔹 Cell
Small box where row & column meet
Example:
Cell A1 = Column A + Row 1
📘 5. Entering Data
Example 1: Typing Text
Click on A1
Type: Ravi
Press Enter
Example 2: Typing Number
Click on A2
Type: 100
Press Enter
📘 6. Basic Formula (Addition)
Click on A3
Type:
=10+20
Press Enter
Answer: 30
📘 7. Using Cell Reference Formula
If:
A1 = 10
A2 = 20
In A3 type:
=A1+A2
Press Enter
Answer: 30
📘 8. Saving the File
Click File
Click Save As
Choose Location
Type File Name: MyExcelFile
Click Save
📘 9. Simple Practice Exercise
Create this table:
Now:
Add total using formula
Save the file
📘 10. Beginner Tips
✔ Always start formula with "="
✔ Save your file regularly
✔ Use simple formulas first
✔ Practice daily
bout Spreadsheet – For Beginners
4
📘 What is a Spreadsheet?
A Spreadsheet is a table made of:
Rows ➡️ (1, 2, 3…)
Columns ⬇️ (A, B, C…)
Cells ⬜ (Small boxes)
It is used to:
Store information
Do calculations
Organize data
Create reports
👉 Microsoft Excel is a spreadsheet program.
🧱 Main Parts of a Spreadsheet
1️⃣ Rows
Horizontal lines
Numbered as 1, 2, 3, 4…
2️⃣ Columns
Vertical lines
Named as A, B, C, D…
3️⃣ Cell
Where row and column meet
Example: A1, B2, C5
📌 A1 means Column A + Row 1
📊 Example of a Spreadsheet
In this spreadsheet:
Each box is a Cell
We can calculate total marks
We can find highest mark
🟢 Why Do We Use Spreadsheet?
We use spreadsheets in:
🏫 School – Marksheet
🏢 Office – Salary sheet
🛒 Shop – Bill making
🏦 Bank – Account management
🧮 What Can a Spreadsheet Do?
✔ Add numbers
✔ Subtract
✔ Multiply
✔ Divide
✔ Find average
✔ Count data
✔ Create charts
Example:
If A1 = 10
If A2 = 20
In A3 type:
= A1 + A2
Answer: 30
🎯 Beginner Practice
Open Excel and create this:
In A1 type Name
In B1 type Marks
Enter 3 student names
Add marks
Use formula to find total
📌 Important Points
Spreadsheet is made of rows and columns
Cell is the basic unit
Always start formula with "="
Excel is the most popular spreadsheet software
About Ribbon in Microsoft Excel
👩🏫 Beginner Friendly Teaching Guide
4
📘 What is Ribbon?
The Ribbon is the top menu area in Microsoft Excel.
It contains:
Buttons
Tools
Commands
👉 We use the Ribbon to do all work in Excel.
Think like this:
🧰 Ribbon = Toolbox of Excel
📍 Where is Ribbon Located?
The Ribbon is at the top of the Excel window, below the Title Bar.
It has many tabs.
🟢 Main Tabs in Ribbon (Beginner Level)
1️⃣ File Tab
Used to:
Save
Open
Print
Close file
2️⃣ Home Tab (Most Important)
Used to:
Bold text
Change font size
Change color
Align text
Add borders
Copy & Paste
👉 Beginners mostly use Home tab.
3️⃣ Insert Tab
Used to:
Insert charts
Insert tables
Insert pictures
Insert shapes
4️⃣ Page Layout Tab
Used to:
Change page size
Set margins
Print settings
5️⃣ Formulas Tab
Used to:
Insert functions
Use SUM
Use AVERAGE
Use IF
Use financial formulas
6️⃣ Data Tab
Used to:
Sort data
Filter data
Remove duplicates
Post a Comment