? Part 1: Introduction to Excel

? What is MS Excel?

Microsoft Excel is a spreadsheet application used to:

• Store and organize data
• Perform calculations
• Analyze information
• Create charts and reports

? It is widely used in education, business, and data management.

?️ Part 2: Starting Excel

? Step 1: Open Excel

1. Click Start Menu
2. Type Microsoft Excel
3. Click to open

? Step 2: Create New Workbook

1. Click File → New
2. Select Blank Workbook

? A workbook is the Excel file you are working in.

? Part 3: Understanding Excel Interface

? Main Components

1. Title Bar

• Shows workbook name (e.g., Book1)

2. Ribbon

• Contains tools and commands

3. Worksheet Area

• Grid of rows and columns

4. Rows

• Horizontal (1, 2, 3…)

5. Columns

• Vertical (A, B, C…)

6. Cell

• Intersection of row & column
• Example: A1, B2

? Step 3: Active Cell

• The selected cell is called Active Cell
• Highlighted with a border

⌨️ Part 4: Data Entry in Excel

? Step 4: Enter Data

Click on cell A1 and type:

Name

Continue:

? Step 5: Types of Data

? Step 6: Move Between Cells

• Enter → Move down
• Tab → Move right
• Arrow Keys → Navigate

✏️ Part 5: Editing Data

? Step 7: Edit Cell Content

• Double-click cell
  OR
• Press F2

? Step 8: Delete Data

• Select cell
• Press Delete key

? Step 9: Select Cells

? Part 6: Copy, Cut & Paste

? Step 10: Use Shortcuts

? Step 11: AutoFill Feature

1. Select a cell
2. Drag small square (bottom-right corner)

? Automatically fills data (numbers, names, patterns)

? Part 7: Saving Workbook

? Step 12: Save File

1. Click File → Save As
2. Choose location
3. Enter file name:

Excel_Basics_YourName.xlsx

4. Click Save

? Step 13: Save Regularly

• Use Ctrl + S frequently

? Part 8: Opening Existing Workbook

? Step 14: Open File

1. File → Open
2. Browse location
3. Select workbook

? Part 9: Basic Excel Tips

✅ Do’s

• Enter data carefully
• Keep table organized
• Use clear headings

❌ Don’ts

• Avoid empty rows in data
• Do not mix text and numbers incorrectly
• Avoid messy structure

? Lab Practice Tasks

Students must perform:

✅ Open Excel and create workbook
✅ Enter student data (at least 5 records)
✅ Practice navigation (Tab, Enter)
✅ Use copy/paste
✅ Save file with correct name

? Expected Learning Outcomes

Students will:

• Understand Excel interface
• Enter and manage data
• Navigate efficiently
• Save and retrieve workbooks

⚠️ Common Mistakes to Avoid

• Typing data in wrong cells
• Not saving file
• Confusing rows and columns
• Skipping headings

?‍? Instructor Guidelines

• Demonstrate interface clearly
• Give real data entry examples
• Monitor student practice
• Ensure proper file saving

? Conclusion

This tutorial builds the foundation of Excel skills, enabling students to work with data efficiently and prepare for advanced features like formulas and charts.