Before learning formulas, dashboards, or automation, you must understand the Excel interface and how spreadsheets work. This foundation will make advanced Excel much easier later.
🧠 1. What is Excel?
Microsoft Excel is a spreadsheet application used to:
• ✅ Store data
• ✅ Perform calculations
• ✅ Analyze information
• ✅ Create reports & dashboards
• ✅ Automate repetitive tasks
📌 Real-World Uses of Excel
Industry -> Use Case
• Finance -> Budgeting & forecasting
• Data Analytics -> Data cleaning & reporting
• HR -> Attendance & payroll
• Sales -> KPI dashboards
• Education -> Marksheets & tracking
🗂️ 2. Workbook vs Worksheet
📘 Workbook
• A workbook -> the entire Excel file
Example:
• Sales_Report.xlsx
📄 Worksheet
• A worksheet -> a single sheet/tab inside the workbook
• 📌 One workbook -> can contain multiple worksheets
Example:
• January Sales
• February Sales
• March Sales
🧱 3. Rows, Columns & Cells
🔹 Rows
• Horizontal lines in Excel
• They are numbered:
• 1, 2, 3, 4...
🔹 Columns
• Vertical sections in Excel
• They are labeled:
• A, B, C, D...
🔹 Cells
• Intersection of a row and column
📌 Example:
• B5
• B -> Column
• 5 -> Row
🎀 4. Understanding the Excel Interface
Important Parts of Excel
Section -> Purpose
• Ribbon -> Contains all tools & features
• Formula Bar -> Shows formulas/data
• Name Box -> Shows selected cell name
• Sheet Tabs -> Navigate between worksheets
• Status Bar -> Displays quick calculations
🧭 5. Ribbon Tabs You Must Know
Tab -> Purpose
• Home -> Formatting & editing
• Insert -> Charts, tables, PivotTables
• Formulas -> Functions & calculations
• Data -> Sorting, filtering, Power Query
• Review -> Protection & comments
• View -> Freeze panes & zoom
📌 Most daily work happens inside:
• Home
• Insert
• Data
⌨️ 6. Basic Keyboard Shortcuts
Shortcut -> Purpose
• Ctrl + C -> Copy
• Ctrl + V -> Paste
• Ctrl + X -> Cut
• Ctrl + Z -> Undo
• Ctrl + S -> Save
• Ctrl + Arrow Keys -> Fast navigation
📝 7. Entering Data in Excel
You can enter:
• ✅ Text
• ✅ Numbers
• ✅ Dates
• ✅ Formulas
Example:
Name -> Sales
• Rahul -> 5000
• Priya -> 7000
📌 8. Difference Between Data and Formula
Data
• Direct values entered manually
• Example:
• 5000
Formula
• Performs calculations
• Example:
=A1+B1🧊 9. Freeze Panes
• Freeze Panes -> keeps headers visible while scrolling
Steps:
• View -> Freeze Panes
Common Options:
• Freeze Top Row
• Freeze First Column
📌 Very useful in large datasets
🔍 10. Zoom Feature
• Zoom -> helps increase or decrease worksheet size
Location:
•
Bottom-right corner slider
OR
•
View -> Zoom
🧪 Practice Tasks for Today
✅ Task 1:
Create a workbook named:
• Student_Report.xlsx
✅ Task 2:
Create columns:
• Student Name
• Marks
• Grade
✅ Task 3:
Practice:
• Copy/Paste
• Bold formatting
• Freeze Top Row
• Zoom In/Out
🎯 Goal of Week 1
By the end of this week, you should:
• ✅ Navigate Excel confidently
• ✅ Understand worksheets & cells
• ✅ Enter and format data
• ✅ Use essential shortcuts
• ✅ Work comfortably with spreadsheets
📌 Double Tap ❤️ For More