📊 Free Microsoft Excel course with certificate

From your very first cell to lookups and pivot tables — with real spreadsheets you build as you go.

What you will learn

1. What a spreadsheet actually is
2. Entering data: text, numbers, dates
3. Editing and the fill handle
4. Your first formula
5. SUM, AVERAGE, COUNT, MIN, MAX
6. Worked example: monthly budget
7. Absolute references and the dollar sign
8. Number formatting: PKR, dates, percentages
9. IF: making the sheet decide
10. COUNTIF and SUMIF
11. VLOOKUP and XLOOKUP
12. Worked example: student result sheet
13. Sorting, filtering and Tables
14. Conditional formatting and dropdowns
15. Charts that explain themselves
16. PivotTables

How it works

Open a lesson a day, mark it done, then take the quiz. Pass it and you get an XpertAcademy certificate with your name that anyone can check. Sign in to save your progress on every device.

Related courses

All courses · XpertAcademy