Excel for Work
The spreadsheet skills that actually appear in job adverts, taught on the kind of messy data you will really be handed. No accountancy, no macros.
- 6 lessons
- about 7 minutes (estimate)
- Free
- Free BvLogic Certificate of Completion
- Video in اردو
- Exercises in اردو
- 12 quiz questions
- 6 exercises
- 1 graded lab
Earn your free BvLogic Certificate of Completion.
A digital credential issued by BvLogic Academy to recognize successful completion of this introductory learning activity.
Not a government qualification or regulatory certification.
That was a one-minute preview. The full course video is for signed-in learners. Sign in to watch it here, or create a free BvLogic ID; it takes a minute, and this course is added to it.
What you'll be able to do
- Be able to name the five things that phrase actually stands for.
- Be able to take a pasted mess and turn it into columns you can work with.
- Be able to write SUM, AVERAGE, COUNTIF, SUMIF, IF and ROUND from memory.
- Be able to use XLOOKUP, or VLOOKUP where XLOOKUP is not available.
- Be able to build a pivot table and explain what it is summarising.
- Be able to hand over a spreadsheet without having to explain it.
Skills covered
- Data Handling
- Data Preparation
- Excel
- Microsoft Excel
Course content
- 1 What employers mean by 'must know Excel' Be able to name the five things that phrase actually stands for.
- 2 Getting messy data into a usable shape Be able to take a pasted mess and turn it into columns you can work with. Sign in to open
- 3 The six formulas that do most of the work Be able to write SUM, AVERAGE, COUNTIF, SUMIF, IF and ROUND from memory. Sign in to open
- 4 Finding one row among thousands Be able to use XLOOKUP, or VLOOKUP where XLOOKUP is not available. Sign in to open
- 5 Turning thousands of rows into six numbers Be able to build a pivot table and explain what it is summarising. Sign in to open
- 6 A sheet somebody else can open Be able to hand over a spreadsheet without having to explain it. Sign in to open
Read what each lesson covers
- What employers mean by 'must know Excel'. Five things: getting data in cleanly, about six formulas, finding one row among many, summarising, and presenting a sheet someone else can read.
- Getting messy data into a usable shape. Text to Columns, TRIM and CLEAN, and Find and Replace, so FSD, Fsd and Faisalabad become one city. Never overwrite the raw data.
- The six formulas that do most of the work. SUM, AVERAGE, COUNTIF, SUMIF, IF and ROUND, each understood well enough to read aloud as a sentence.
- Finding one row among thousands. XLOOKUP, or VLOOKUP with FALSE for an exact match, because without it you get the nearest price and no error. Always handle not-found.
- Turning thousands of rows into six numbers. Pivot tables with rows, columns and values, built on a proper table, with the grand total checked against a plain SUM.
- A sheet somebody else can open. Title and date, raw data, working and output on separate sheets, labelled units, a frozen header, no merged cells and one line on where the data came from.
Course lab
Graded lab · optional practice The fee register of a real shop Open the lab →Who this course is for
- Job seekers who see 'must know Excel' in every advert and want to know what that means.
- Office staff handed messy exports and asked for a summary by tomorrow.
- Anyone who wants to be ahead of most applicants in an afternoon per skill, without macros.
Try the first exercise (in Urdu)
پاکستان میں تین حقیقی job adverts ڈھونڈیں جن میں Excel کا ذکر ہو۔ ہر ایک کے لیے لکھیں کہ اوپر کی پانچ چیزوں میں سے اس کردار کو اصل میں کون سی چاہیے ہوں گی۔ غور کریں کہ advert کتنی بار یہ بتاتا ہی نہیں۔
Using this in Pakistan
- Indeed's range for data entry clerks in Faisalabad is Rs 18,318 to 47,831 a month across all experience levels, averaging Rs 29,600. Source
- Office assistants in Faisalabad average Rs 28,948 a month on Indeed, among the lowest-paid roles, so the Excel and English skills that lift a CV above that matter. Source
- Freelance: Pakistani data entry specialists featured on Upwork charge about $4 to $5 an hour. Source
Questions
Is it really free?
Yes. No payment and no card; lesson 1 needs no account.
Is there a certificate?
Yes, when you complete every lesson.
Can I learn in Urdu?
Every lesson has an Urdu exercise alongside the English reading.
How long does it take?
About 7 minutes of reading, plus the exercises.
What comes next?
The paid Office Management programme, in Faisalabad and live online.
Office Management
Office Management
This free course is the introduction to the full Office Management programme. The programme is taught by a trainer, marked by the academy, and carries the syllabus in full: the part an employer asks about.
See the full syllabus and feeRelated free courses
- Computer BasicsUrdu video
- PowerPoint and PresentingUrdu video
- Word for WorkUrdu video
- Business Communication BasicsUrdu video
- Conflict Resolution
- Critical Thinking
Data Science courses in Pakistan · All free courses · Government free courses open now