Spreadsheets for IT Work

Clean, sort, filter and report on data accurately and fast.

What the course covers

8 modules, 32 topics. Open any one to see what sits inside it.

1. 1.1 Workbooks, sheets and cells
2. 1.2 Entering data without introducing errors
3. 1.3 Selecting, moving and filling at speed
4. 1.4 Saving, versions and file formats
1. 2.1 What makes a table usable
2. 2.2 Splitting and joining text
3. 2.3 Removing duplicates and blanks
4. 2.4 Fixing dates and numbers stored as text
1. 3.1 References, relative and absolute
2. 3.2 Sum, count, average and the everyday functions
3. 3.3 Conditions and nested logic
4. 3.4 Handling errors deliberately
1. 4.1 Matching one list against another
2. 4.2 Lookup functions and their limits
3. 4.3 Index and match
4. 4.4 Proving a lookup actually worked
1. 5.1 Sorting on several columns
2. 5.2 Filters and views
3. 5.3 Conditional formatting that highlights real problems
4. 5.4 Subtotals and grouping
1. 6.1 Building your first pivot
2. 6.2 Rows, columns, values and filters
3. 6.3 Grouping dates and numbers
4. 6.4 Refreshing without breaking it
1. 7.1 Charts that say one thing clearly
2. 7.2 Layout and print setup
3. 7.3 Protecting cells and sheets
4. 7.4 Sharing a file other people can actually use
1. 8.1 Named ranges and structured tables
2. 8.2 The shortcuts worth learning
3. 8.3 Auditing a sheet you did not build
4. 8.4 Common spreadsheet disasters and how to avoid them

By the end of this course you will be able to explain and apply:

Two hours, not two months Eight short modules. Finish in a day, or do one module a night for a week.

Job-ready from the first module Everything here is a task you will actually be asked to do at work, not theory you will never use.

Built for a phone Watch on the bus, pause mid-module, pick up where you stopped. No download, no lab.

A certificate that can be checked Every certificate carries an ID your college or an employer can verify on our site.

Pre-degree / Foundation students in India
Studying: BCA, B.Sc. Computer Science, B.Sc. IT, B.Tech CSE/IT, B.Sc. Data Science
Recent graduates strengthening a CV
Anyone working in this field without a formal qualification

About two hours in total — eight modules of roughly fifteen minutes. You can do it in one sitting or spread it across a week. Your place is saved either way.
No. There is no prerequisite course and no software to install. A phone, tablet or computer with an internet connection is enough.
Yes. This course is placed at Pre-degree / Foundation for India, and the content is written for that level. If you are at a different stage, change your level at the top of the page and the courses will change with it.
A certificate for the course, carrying an ID that your college or an employer can check on our verification page. You keep access to the material afterwards.
Yes — ₹450 for this course on its own, or ₹1,450 for all five in this set, which works out cheaper if you want more than one.
There is a short quiz at the end of each module so you can check what stuck. It is not timed and you can retake it.
Change your country using the picker at the top. Level names, degree names and prices all switch to that country, and the courses adjust to its education system.

Wording shown for India. Pick a different country at the top and the terms, currency and programme names change with it.