Free course · Office & English

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 Taught by Ali Free Certificate on completion Video in اردو Exercises in اردو
6lessons
12quiz questions
6exercises
1graded lab
Watch the course walkthrough اردو

The 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

When you want the whole trade

Office Management

Office Management

12 weeks 240 contact hours beginner Mapped to the NAVTTC standard Assignments & assessment Real projects

This free course is the introduction. 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 fee

Course content

  1. 1 What employers mean by 'must know Excel' Be able to name the five things that phrase actually stands for. 1 min 2 questions Exercise · اردو Free preview
  2. 2 Getting messy data into a usable shape Be able to take a pasted mess and turn it into columns you can work with. 1 min 2 questions Exercise · اردو Sign in to open
  3. 3 The six formulas that do most of the work Be able to write SUM, AVERAGE, COUNTIF, SUMIF, IF and ROUND from memory. 1 min 2 questions Exercise · اردو Sign in to open
  4. 4 Finding one row among thousands Be able to use XLOOKUP, or VLOOKUP where XLOOKUP is not available. 2 min 2 questions Exercise · اردو Sign in to open
  5. 5 Turning thousands of rows into six numbers Be able to build a pivot table and explain what it is summarising. 1 min 2 questions Exercise · اردو Sign in to open
  6. 6 A sheet somebody else can open Be able to hand over a spreadsheet without having to explain it. 1 min 2 questions Exercise · اردو Sign in to open

Course lab

Graded lab The fee register of a real shop 6 tasks about 90 min marked out of 100 English · اردو Open the lab →

Related free courses

  1. Computer Basics · Urdu video
  2. Word for Work · Urdu video
  3. PowerPoint and Presenting
  4. Business Communication Basics · Urdu video
  5. Conflict Resolution
  6. Critical Thinking

All free courses · Government free courses open now