Basic Excel Training Course – Learn Excel from Scratch in 30 Days

Module 1: Excel Introduction & Interface (Week 1)

• 🎯 What is Microsoft Excel?
• 🖥️ Exploring Excel Interface: Ribbon, Tabs, Cells, Rows, Columns
• 🧮 Workbook vs Worksheet
• 📁 Creating, Saving, and Opening Files
• ✍️ Basic Data Entry (Text, Numbers, Dates)

Module 2: Cell Basics & Formatting (Week 2)

• 🪄 Cell Formatting: Font, Color, Borders, Alignment
• 📏 Number Formatting: Currency, Percentage, Date Formats
• 🗃️ Copy, Cut, Paste, Undo/Redo, Fill Handle
• 🔄 Merge & Center, Wrap Text
• 🎨 Table Styles and Themes

Module 3: Basic Calculations & Formulas (Week 3)

• ➕ Basic Arithmetic: SUM, SUBTRACTION, MULTIPLICATION, DIVISION
• 🧠 AutoSum Function
• 🧾 Using Functions: AVERAGE, MIN, MAX, COUNT
• 📌 Relative vs Absolute Cell Reference
• 📋 Introduction to Formula Bar

Module 4: Data Handling & Print Setup (Week 4)

• 🔍 Sorting & Filtering Data
• 📊 Creating Simple Charts (Bar, Column, Pie)
• 📑 Page Layout and Print Area
• 🖨️ Headers, Footers, Print Preview, Page Setup
• 📁 Project: Create an Attendance Sheet & Salary Sheet

🎓 Course Outcome:

By the end of the course, students will be able to:

• Confidently handle Excel spreadsheets for everyday tasks
• Create tables, apply basic formulas, and generate charts
• Prepare reports suitable for data entry and office jobs
• Get job-ready with Excel skills needed in business environments