Takhti My learning

Excel for Office Jobs

Formulas, tables, charts and a salary sheet: the Excel that office job tests ask for.

Free course 4.6 (902 ratings) 6,140 learners

Created by Ayesha Siddiqui

Updated September 2026 English, with Urdu help Beginner

Ratings and learner numbers are made up for this demo.

What you will learn

  • Enter and format data in clean tables
  • Use SUM, AVERAGE, IF and VLOOKUP
  • Sort, filter and find data fast
  • Make charts for a monthly report
  • Build a salary sheet and a stock register
  • Print and share sheets without layout problems

Course content

3 sections · 9 lessons · 2 hr 24 min total

Excel basics 3 lessons · 43 min
  1. Rows, columns and cells 12 min
  2. Entering and formatting data 15 min
  3. Your first formulas 16 min
Working with data 3 lessons · 52 min
  1. Sort and filter 14 min
  2. IF and conditional formatting 18 min
  3. VLOOKUP and XLOOKUP 20 min
Reports for the office 3 lessons · 49 min
  1. Charts that explain 15 min
  2. A salary sheet from scratch 22 min
  3. Printing and sharing 12 min
Final quiz: 4 questions, pass with 3 Certificate with your name

Requirements

  • A laptop with Excel, or free Google Sheets.
  • Basic computer use.
  • No maths beyond school level.

Description

Almost every office job in Pakistan asks for Excel, and many interviews include a short Excel test. This course teaches exactly what those tests check, with the files you would really use at work.

You will finish with a salary sheet, a stock register and a monthly report you can show in an interview.

Instructor

Ayesha Siddiqui

Office skills trainer

Has trained office staff and students in MS Office and computer basics for nine years. Teaches slowly and checks that everyone keeps up.

Also teaches Computer Basics and MS Word .

Learner reviews

4.6
4.6

902 ratings

5.0

I used the salary sheet lesson in my job interview test. Got the job.

Rabia, Multan. An example review written for this demo.

Learners also take