Why Every University Student Should Learn Excel

Scroll through job ads on Rozee or LinkedIn for fresh graduates in Pakistan, whether in banking, marketing, HR, supply chain or engineering, and you'll see the same line again and again: 'proficiency in MS Excel'. It's often listed as a basic requirement, yet most graduates only know how to type data into cells and add a SUM at the bottom.

That gap is an opportunity. A few weeks of focused practice can put you ahead of most of your classmates in interviews and internships.

Why Excel matters in every field

• Business and commerce: budgets, financial models, sales reports.
• Engineering: calculations, material estimates, project schedules.
• Social sciences: survey data and basic statistics for your thesis.
• Medicine and health: patient data, research and audit work.
• Any job: tracking, reporting and presenting numbers to a manager.

What to learn, in order

Level 1: the essentials

Formatting tables properly, sorting and filtering, absolute and relative references, and basic functions such as SUM, AVERAGE, COUNT, MIN, MAX, IF and ROUND. Learn keyboard shortcuts early; they make you noticeably faster.

Level 2: the skills employers test

XLOOKUP (or VLOOKUP), SUMIFS and COUNTIFS, text functions, conditional formatting, data validation and, above all, PivotTables. PivotTables are the single feature most likely to come up in an interview task.

Level 3: standing out

Charts that communicate clearly, dashboards, Power Query for cleaning messy data, and an introduction to Power BI. At this level you're doing basic data analysis, which is a career path of its own.

In most offices, the person who can turn a messy spreadsheet into a clear summary in twenty minutes quickly becomes the person everyone relies on.

How to practise

• Track your own monthly expenses and build a summary with a PivotTable.
• Use your semester results to calculate GPA trends and build a chart.
• Download a public dataset, for example from the Pakistan Bureau of Statistics, and analyse it.
• Offer to manage data for a university society event: registrations, budgets, attendance.

Put one or two of these projects on your CV with a line about what you did and the result. 'Built a dashboard tracking 400 event registrations' is far more convincing than 'Proficient in MS Office'. Start this semester; by the time you apply for internships, you'll have a skill you can demonstrate rather than just claim.