Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 1 of 9, section 1, 12 min
What a workbook, a sheet and a cell are, and how to move around quickly with the keyboard.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 2 of 9, section 1, 15 min
Type numbers, dates and text the right way, then format them as rupees, dates and percentages.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 3 of 9, section 1, 16 min
Add, subtract and total columns with formulas and the SUM function.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 4 of 9, section 2, 14 min
Sort a list by name or amount and filter it to show only what you need.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 5 of 9, section 2, 18 min
Let Excel decide for you: mark pass or fail, and show late payments in red.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 6 of 9, section 2, 20 min
Find a price, a name or a salary from another table with one formula.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 7 of 9, section 3, 15 min
Turn a monthly sales table into a clear column or line chart.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 8 of 9, section 3, 22 min
Build a salary sheet with allowances, deductions and net pay for ten staff.
Demo: in a real course the lesson video plays here. The notes below are the real lesson.
Start the course to open this lesson
It is free. One tap and every lesson opens.
Lesson 9 of 9, section 3, 12 min
Fit a sheet on one page, add a header and share it as PDF or a Google Sheets link.
Get at least 3 of 4 right to pass. You can try again as many times as you like.
The quiz opens when you join the course