Use Excel with confidence: enter and format data, write formulas like SUM and AVERAGE, sort, filter and make charts.
Microsoft Excel is one of the most requested skills in offices, shops and organisations. This course teaches the essentials step by step.
You will learn how a spreadsheet is organised, how to enter and format data, how to write formulas that calculate for you, how to sort and filter lists, and how to turn numbers into a clear chart. We finish by building a simple monthly budget.
You need a computer with Excel or a free alternative such as Google Sheets; nearly everything in this course works the same way there.
5 lessons · 54 min · final quiz
Lesson 1 · 9 min
An Excel file is called a workbook. Each workbook contains one or more worksheets, shown as tabs at the bottom of the screen (Sheet1, Sheet2…). Rows, columns and cells Columns go up and down and are n...
Lesson 2 · 11 min
Typing data Click a cell, type, and press Enter. To change a cell, click it and type again, or double-click it to edit part of the text. Start every table with a header row that names each column, for...
Buy the course to open this lesson.
Lesson 3 · 13 min
Formulas are what make Excel powerful: you type the calculation once and Excel updates the answer whenever the numbers change. Writing a formula Every formula starts with an equals sign (=). For examp...
Buy the course to open this lesson.
Lesson 4 · 9 min
When a list grows long, sorting and filtering help you find what you need quickly. Sorting Click any cell inside your table. Go to the Data tab. Click A→Z to sort from smallest to largest (or alphabet...
Buy the course to open this lesson.
Lesson 5 · 12 min
Making a chart Charts turn numbers into a picture that is quick to understand. Select your data, including the header row. For example, months in column A and sales in column B. Go to the Insert tab....
Buy the course to open this lesson.
Microsoft Excel Essentials: final quiz
5 questions · Pass mark 60%
Complete every lesson and pass the final quiz to get your Professional Certificate. Download it as a PDF and share it. Anyone can check it with its code.
No reviews yet. Learners enrolled in this course can rate it.
Start from zero: learn what a computer is, use a mouse and keyboard, organise files and go online safely.
Everyday English for real life: greetings, numbers and time, asking questions and shopping at the market.
Turn an idea into a small business: know your customers, set a fair price, keep simple records and get paid.
One-time
$5