Skip to content

Hands-on Skills

Almost every first job comes with a spreadsheet. Few students have used one for real.

Students have typed marks into a grid and made a chart for a lab record. Then the first job hands them three thousand rows of untidy data and asks for a summary by Friday. This session puts a working practitioner beside them for that task: clean it, total it, summarise it, and check that the answer is right.

Illustration of Indian colleagues sharing ideas in a bright office lounge

Illustrative image · GullyHR

Explore this page7 sections

Listing “MS Excel” on a resume is easy. Using it under a deadline is not.

Spreadsheets sit underneath a great deal of ordinary work: sales reports, attendance, stock, budgets, survey results, lists of leads. A fresher in operations, accounts, HR, sales support or analysis is expected to work with one from the first week, and nobody teaches it.

What is missing is rarely knowledge of a menu. It is the routine: looking at the data before touching it, cleaning it without destroying the original, choosing the simple formula over the clever one, and checking the total before sending it. That routine is learnt fastest by watching someone who does it every day and then doing it yourself.

What the session covers

30 topics across 6 areas. Six parts, in the order the work happens.

Looking Before TouchingUnderstand the data first.5 topics
  • What one row represents
  • What each column means
  • Where the data came from
  • Blank cells, duplicates and odd values
  • Keeping an untouched copy of the original

Most spreadsheet mistakes start with somebody editing data they had not yet read.

Cleaning Messy DataReal data is never tidy.6 topics

The dataset in the room is deliberately untidy, the way a real export from a billing system or a form is.

  • Trimming extra spaces
  • Splitting and joining text columns
  • Fixing dates stored as text
  • Removing duplicates, carefully
  • Consistent spellings and categories
  • Filters and sorting without scrambling rows
The Formulas That Do Most of the WorkA short list, used well.5 topics
  • SUM, AVERAGE, COUNT and their conditional forms
  • IF for simple decisions
  • Lookups to bring data together from two sheets
  • Absolute and relative references
  • Reading an error message instead of deleting the formula

A formula your manager can follow is worth more than one only you understand.

Summarising With a Pivot TableThe question first, then the table.4 topics
  • Turning a question into rows, columns and values
  • Totals by month, region or group
  • Filtering a summary
  • When a pivot table is the wrong tool
Making It ReadableSomebody else has to use it.5 topics
  • Clear headings and frozen header rows
  • Number and date formats
  • Conditional formatting, used sparingly
  • One simple chart that answers one question
  • A short note on what the sheet contains
Checking Your Own WorkThe habit employers notice.5 topics
  • Does the total match the source?
  • Did the row count change, and why?
  • Spot-checking a few rows by hand
  • Does the answer make sense?
  • Saying what you assumed

Sending a wrong number confidently does more harm than asking a question first.

What participants leave with

  • The cleaned file and the summary they built
  • A one-page guide to the formulas used
  • A checklist for checking a spreadsheet before sending it
  • Suggestions for practice data to keep going with
  • Pointers to free courses on government platforms such as SWAYAM and Skill India Digital Hub

What this session is not

  • A certification course
  • Advanced macros or programming
  • A tour of every menu
  • A promise that one session makes someone an analyst

Who teaches it

  • Analysts and operations staff
  • Accounts and finance practitioners
  • HR and sales operations staff
  • Small-business owners who run their business on spreadsheets

How the session runs

Two to three hours, in a small group, with a laptop for each participant or pair. The practitioner opens a realistic, untidy dataset and works through it aloud, including the checks most people skip. Participants then do the same with a second dataset and a question to answer, and the practitioner reviews what they produced. Excel or Google Sheets both work; the routine is the same.

What participants leave with

  • A messy, realistic dataset cleaned by their own hands
  • The handful of formulas that cover most everyday work
  • A summary built with a pivot table, and the habit of checking it
  • A clear idea of the level an employer expects from a fresher
  • A small finished file they can describe in an interview
  • Pointers to free courses for going further

How to get this session

  1. Step 1

    Ask

    Say who it is for and roughly how many participants.

  2. Step 2

    We reply by email

    A person reads it and replies, usually within two working days.

  3. Step 3

    We agree the date

    We find the right speaker and agree the date and format with you.

Ask for this session

No session is scheduled right now.

Start a conversation

Ask for this session

Tell us who you are and what you have in mind. A person reads it and writes back, usually within two working days.

  1. Tell us what you need

    A topic or a question is enough to start.

  2. A person replies

    Usually within two working days.

  3. Agree the next step

    We work out the details together.

How we look after your details

You are asking about Spreadsheets for Real Work. We will have that in front of us when we reply.

Fields marked optional can be left blank.

01Your request

A topic, a programme, or the question on your mind.

What you have in mind, and anything that would help us reply usefully.

02How we can reach you

We will use these details to reply to your request.

10 digits, without the country code.

Free for students, and a person reads every request. Want to speak, mentor or volunteer instead? Use the contribute page. Your details are used only to reply.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms of Service apply.

Clean it, total it, check it, then send it.

Tell us who the session is for and roughly how many people. Sessions are free for participants.