Excel skills employers expect from freshers

Start with what an employer is really asking. Entry-level spreadsheet work is rarely about clever formulas. It is a sales list to total by region, an attendance sheet to reconcile, a stock report to update, survey responses to summarise. The work is ordinary, the data is untidy, and the deadline is real. The skills below are the ones that come up in that kind of work, in roughly the order you use them.

The first is reading the data before you touch it. What does one row represent? What does each column mean? Are there blank cells, repeated rows, dates that look wrong, numbers stored as text? Make a copy of the original sheet and work on the copy. This sounds too basic to mention, and it is the habit that prevents most spreadsheet disasters.

The second is cleaning, which is where many freshers struggle, because data in coursework is often tidy. Learn to remove extra spaces with TRIM, split one column into two and join two into one, convert text that looks like a date into an actual date, make spellings consistent so that Bengaluru and Bangalore count as one place, and remove duplicate rows only after you have checked they are true duplicates. Learn to sort and filter without scrambling rows, which happens when only one column is selected.

The third is a short list of formulas. SUM, AVERAGE, COUNT and COUNTA. Their conditional versions, SUMIFS and COUNTIFS, which answer most questions of the form "how many" or "how much, for this category". IF, for simple decisions such as marking an order late. A lookup, VLOOKUP or the newer XLOOKUP where your version has it, to bring information from one sheet into another. And the difference between relative and absolute references, the dollar signs that decide whether a formula still works when you copy it down. When a formula returns an error, read the error rather than deleting the formula; it usually says what is wrong.

The fourth is the pivot table. It is a useful dividing line between someone who has used spreadsheets for real work and someone who has not. A pivot table takes a long list and summarises it by whatever you choose: sales by month, applications by source, expenses by category. The skill is less about clicking and more about turning a question into rows, columns and values. Practise by writing the question in plain words first, then building the table that answers it.

The fifth is making the sheet usable by someone else. Clear column headings. A frozen header row. Sensible number and date formats. Conditional formatting used for one purpose, such as highlighting overdue items, rather than to decorate. One simple chart that answers one question. A short note at the top saying what the sheet contains and where the data came from.

The sixth, and the one that employers notice most, is checking your own work. Does your total match the total in the source? Did the number of rows change after cleaning, and can you explain why? Pick three rows at random and work them out by hand. Does the answer make sense, or is one region suddenly ten times larger than the others? When you send the file, say what you assumed. A fresher who does this every time is trusted with more within weeks; one who sends a confident wrong number loses that trust quickly.

What is usually not expected of a fresher: macros, programming, complex dashboards, or advanced statistical functions. If a role needs those, the job description normally says so. Some roles, especially in finance and analytics, do test more, so read the posting and prepare to its level rather than to a general one.

How should you practise? Not by watching another video. Download a public dataset, from a government open data site or a public data repository, choose one that is a little untidy, and give yourself a question to answer: which month had the most, which category is growing, which records are missing information. Clean it, summarise it, check it, and write three lines on what you found. Do that three or four times with different data and you will have done more real spreadsheet work than many applicants. Keep one of those files; in an interview, "I can show you" is stronger than "I know Excel".

If you want structured learning alongside, government platforms such as SWAYAM and Skill India Digital Hub list courses on spreadsheets and data. Check on the platform itself what is free and what any certificate costs. A certificate is useful, but the file you made and can explain is better evidence.

Finally, be honest on your resume. Write what you can actually do, for example "cleaning data, SUMIFS, lookups, pivot tables", rather than a level you cannot define. Some interviewers ask candidates to do a small spreadsheet task on the spot, and the honest description is the one that survives it.