Home › Courses › Excel for Beginners
🆓 Free Course

Excel for Beginners

Go from zero to confident Excel user. Learn everything you need — from the basics to formulas, charts, and real-world projects — in simple, practical steps.

📚 8 Modules
🎯 30 Lessons
⏱️ ~8 Hours
📊 Beginner Level
🌐 Hindi + English
Start Learning Free  → Ask a Question
📊
FREE — No signup needed
  • 30 structured lessons
  • 8 practical modules
  • Real-world examples
  • Practice tasks per lesson
  • Final project included
  • Top 20 shortcuts cheat sheet
  • Common mistakes guide
  • Lifetime free access
Start Course Now →

What You Will Learn

By the end of this course, you will be able to confidently use Excel for real work.

Navigate the Excel interface with confidence
Enter, edit, and format data professionally
Use essential formulas — SUM, AVERAGE, COUNT, IF
Understand relative and absolute cell references
Sort, filter, and find data instantly
Create professional charts and graphs
Build and use Excel Tables smartly
Apply data validation to avoid errors
Use 20+ time-saving keyboard shortcuts
Complete a real-world monthly expense report
Understand how to structure clean data
Avoid the most common Excel beginner mistakes

Course Modules

Click any module to expand lessons. Click any lesson to see full details.

Your Progress 0 / 0 lessons
0% Complete
1
Getting Started with Excel
4 Lessons · Introduction
▼
▶
What is Excel and Why Learn It?
Overview of Excel, real-world uses, and why it is one of the most valuable skills.
▶
The Excel Interface Explained
Ribbon, Quick Access Toolbar, formula bar, worksheet tabs, and navigation.
▶
Rows, Columns, and Cells
Understanding the grid structure, cell addresses, and how to navigate efficiently.
▶
Creating, Saving, and Opening Files
Save as .xlsx, auto-save, open recent files, and file organization tips.
2
Data Entry & Formatting
4 Lessons · Core Skills
▼
▶
Entering and Editing Data
Type, edit, delete, and use AutoFill to enter data faster.
▶
Formatting Cells — Text, Numbers, Dates
Bold, italic, font size, number formats, date formats, and alignment.
▶
Column Width, Row Height & Merging
Resize rows/columns, merge cells, wrap text, and freeze panes.
▶
Cell Colors, Borders & Styles
Background color, borders, Cell Styles, and Format Painter.
3
Basic Formulas & Functions
4 Lessons · Core Skills
▼
▶
How Formulas Work in Excel
Writing your first formula, using operators (+, -, *, /), and understanding the formula bar.
▶
SUM, AVERAGE, COUNT, MAX, MIN
The 5 most essential Excel functions every beginner must know.
▶
The IF Function — Make Smart Decisions
Write conditions in Excel — pass/fail, above target, bonus eligible.
▶
COUNTA, SUMIF & COUNTIF
Count non-empty cells, sum/count based on conditions.
4
Cell References
3 Lessons · Important Concept
▼
▶
Relative Cell References
How formulas change when you copy them — and why that's powerful.
▶
Absolute Cell References with $
Lock a cell so it doesn't change when copying — using the $ sign.
▶
Mixed References — Row or Column Lock
Lock only the row or only the column — $A1 vs A$1.
5
Sorting, Filtering & Finding Data
4 Lessons · Data Management
▼
▶
Sorting Data A-Z, Z-A & by Numbers
Sort single columns and multiple columns simultaneously.
▶
AutoFilter — Find What You Need Fast
Filter rows by value, text, date, and custom conditions.
▶
Find & Replace
Find specific data, replace values across the whole sheet in seconds.
▶
Removing Duplicates
Identify and delete duplicate rows from your dataset instantly.
6
Excel Tables
3 Lessons · Smart Data
▼
▶
What is an Excel Table and Why Use It?
Convert data to a Table, understand benefits — auto-expand, structured refs.
▶
Table Styles, Total Row & Slicers
Apply styles, add totals automatically, and filter visually with slicers.
▶
Data Validation — Control What Gets Entered
Dropdown lists, number limits, date restrictions — prevent data entry errors.
7
Charts & Data Visualisation
4 Lessons · Visual Skills
▼
▶
Choosing the Right Chart Type
Bar, column, line, pie — when to use which and why.
▶
Creating Your First Chart
Select data, insert chart, and adjust it — step by step.
▶
Formatting Charts — Title, Labels, Colors
Add chart title, data labels, axis labels, change colors, resize.
▶
Sparklines — Mini Charts in Cells
Tiny trend charts inside a single cell — powerful and clean.
8
Printing & Productivity Tips
4 Lessons · Work Smarter
▼
▶
Page Setup & Print Settings
Page layout, margins, print area, fit to page, headers and footers.
▶
Freeze Panes & Split View
Keep headers visible when scrolling large datasets.
▶
Comments & Notes
Add notes to cells, reply to comments, and manage annotations.
▶
Protecting Your Workbook & Sheets
Lock cells, protect sheets with password, prevent accidental edits.

🏆 Bonus: Top 20 Excel Shortcuts

Master these shortcuts and work 3x faster in Excel.

Select entire columnCtrl + Space
Select entire rowShift + Space
Save workbookCtrl + S
Undo last actionCtrl + Z
Redo last actionCtrl + Y
Copy selectedCtrl + C
PasteCtrl + V
Paste SpecialCtrl + Alt + V
Bold textCtrl + B
Find & ReplaceCtrl + H
Go to last row with dataCtrl + ↓
Select to last cellCtrl + Shift + End
AutoSum selected rangeAlt + =
Insert current dateCtrl + ;
Insert current timeCtrl + Shift + ;
Format cells dialogCtrl + 1
Delete row / columnCtrl + –
Insert row / columnCtrl + Shift + +
New worksheetShift + F11
Close workbookCtrl + W

⚠️ Bonus: Common Beginner Mistakes

Avoid these mistakes that almost every Excel beginner makes.

1

Merging cells in data tables

Merged cells look nice but break sorting, filtering, and formulas. Use "Center Across Selection" instead for visual centering.

2

Storing numbers as text

If a number has a green triangle in the corner, Excel sees it as text. Formulas won't work. Use "Convert to Number" to fix it.

3

Using spaces instead of zero

Leaving a cell blank when you mean "0" causes formula errors. Always enter 0 if a value is zero.

4

Not using absolute references when needed

Forgetting $ when copying formulas causes wrong calculations. Always lock cells that should not change.

5

Hardcoding values inside formulas

Writing =A1*0.18 is bad practice. Put 0.18 in a separate cell and reference it so changes are easy.

6

Not saving regularly

Excel can crash. Save every few minutes with Ctrl+S or enable AutoSave if using OneDrive.

7

Putting multiple pieces of data in one cell

"Delhi, India" in one cell means you cannot sort by city alone. Keep each data point in its own column.

8

Using colour instead of data to represent information

Highlighting a row red to show "rejected" is fine for humans but Excel cannot calculate by colour. Use a Status column instead.

9

Leaving headers in row 2 or 3

Your headers must always be in Row 1 for Tables, filters, and pivot tables to work correctly.

10

Not using Tables for structured data

Plain ranges don't auto-expand. Convert your data to an Excel Table (Ctrl+T) and formulas will update automatically.

🎓 Final Project

Apply everything you have learned in one real-world project.

Monthly Expense Tracker & Summary Report

You will build a complete Monthly Expense Tracker from scratch. This project tests every skill you learned in this course — data entry, formatting, formulas, charts, and tables.

Your project must include:

  • A data entry sheet with Date, Category, Description, and Amount columns
  • At least 20 rows of expense data across 4–5 categories
  • A summary section using SUMIF to total each category
  • An IF formula to flag expenses above ₹5,000 as "High"
  • A SUM for monthly total, AVERAGE per transaction, and COUNT of entries
  • A Pie Chart or Bar Chart showing spend by category
  • Proper formatting — headers bold, numbers as currency, alternating row colours
  • Data converted to an Excel Table with a Total Row
  • A dropdown Data Validation list for the Category column

Completion criteria: Your file should be clean, professional, and ready to show in an interview or on a resume.

Submit Your Project  →

Lesson Title