Excel Tutorial
Microsoft Excel is a spreadsheet program. It lets you store data in rows and columns and calculate with it using formulas.
Shops use Excel to track sales and stock. Schools use it for marks and fees. Offices use it for budgets, salaries and reports. It is one of the most requested skills in job adverts, from office assistant to data analyst.
This tutorial starts from zero and uses simple examples, like a shop in Karachi or a class result sheet.
What You Will Learn
- The Excel window: workbooks, sheets, cells and ranges
- Writing formulas and using relative and absolute references
- Everyday functions: SUM, AVERAGE, COUNT, MIN, MAX
- Decisions with IF, AND, OR and IFS
- Text functions to clean names and codes
- Looking up values with VLOOKUP and XLOOKUP
- Sorting, filtering, charts and PivotTables
A First Example
Every formula starts with an equals sign. This one adds the prices in cells B2 to B4:
Example
=SUM(B2:B4)| A | B | |
|---|---|---|
| 1 | Item | Price (Rs) |
| 2 | Pen | 50 |
| 3 | Notebook | 180 |
| 4 | Bag | 1200 |
| 5 | Total | 1430 |
Exercises and Quiz
Lessons end with a short exercise, and the last lesson has a quiz on the whole tutorial.
Exercise
What must every Excel formula start with?
What to Learn Next
When your data grows too big for a spreadsheet, learn Data Science with Python and pandas to analyse it with code.
Want to learn with a teacher? The Workownix CIT (Certificate in Information Technology) course covers MS Office, including Excel, with practical work, online or at our institute in Orangi Town, Karachi.