Excel Skills Every Office Job Expects You to Have

Almost every office job description in India lists "proficiency in MS Excel". Almost none of them define it. The result is candidates who either undersell competent skills or claim expertise that collapses in the first practical test.

In practice, "proficient in Excel" means about twelve things. Here they are, roughly in the order they are worth learning.

Tier 1 — assumed, not impressive

If you cannot do these, you will struggle in the first week of any office job. Nobody will praise you for them.

• Navigation and shortcuts. Ctrl+arrow to jump to the edge of data, Ctrl+Shift+arrow to select a range, F2 to edit a cell, Alt+= to autosum. These are the difference between working and crawling.
• Formatting. Number formats, currency, dates, wrap text, merge (sparingly), freeze panes.
• Basic formulas. SUM, AVERAGE, COUNT, COUNTA, MIN, MAX.
• Sort and filter. Including multi-level sorts and filtering on more than one column.
• Absolute vs relative references. The $ sign. This one trips people up constantly and causes silent errors in copied formulas.

Tier 2 — this is what "proficient" means

IF and nested logic

IF, and knowing when to reach for IFS instead of nesting five of them. Also IFERROR to stop #N/A littering a report someone else will read.

Lookups

VLOOKUP is still what job descriptions name and what interviews test. XLOOKUP is better in every way and available in Microsoft 365 — learn both, use XLOOKUP when you can, and be ready to explain VLOOKUP's limitations (only looks right, breaks when columns move).

Conditional aggregation

SUMIF, SUMIFS, COUNTIF, COUNTIFS. Enormously used in real work — "total sales for the Mumbai region in March" is a SUMIFS question.

Pivot tables

The single highest-leverage thing in Excel. Rows, columns, values, filters, and grouping dates by month. A pivot table answers in thirty seconds what a formula-heavy sheet takes an hour to do badly.

Text functions

TRIM, LEFT, RIGHT, MID, CONCAT, TEXT, and Text to Columns. Real-world data is messy — trailing spaces, names in one column that need splitting, dates stored as text.

Conditional formatting

Highlighting overdue rows, duplicate values, or numbers outside a range. Makes reports readable by people who will not read numbers.

Tier 3 — what makes you stand out

Power Query is the one worth singling out. Most people still clean data by hand every month. Someone who sets it up once and clicks Refresh looks remarkable while doing considerably less work.

The mistakes that mark someone as a beginner

Certain habits signal inexperience to anyone who has to work with your file afterwards. Worth unlearning early:

• Merged cells everywhere. They break sorting, filtering and pivot tables. Use "Center Across Selection" instead when you want the visual effect.
• Hard-coded numbers inside formulas. =A2*1.18 works until the GST rate changes. Put the rate in a cell and reference it.
• Data and presentation in the same sheet. Keep raw data on one tab and your summary on another. Mixing them makes both harder to maintain.
• Dates stored as text. If your dates are left-aligned by default, Excel is treating them as text and every date calculation will silently fail.
• Blank rows inside a data range. They stop Ctrl+arrow navigation and confuse pivot tables. Filter instead of leaving gaps.
• No documentation. One cell explaining what a complicated formula does saves the next person — often you, in four months — a great deal of time.

Speed matters more than people think

Two candidates can both produce the correct answer, and the one who did it in four minutes rather than twenty-five will be remembered differently. Speed in Excel is almost entirely keyboard habit rather than cleverness.

The shortcuts worth building into muscle memory: Ctrl+arrow and Ctrl+Shift+arrow for moving and selecting, Alt+= for autosum, Ctrl+T to turn a range into a proper table, Ctrl+Shift+L for filters, F4 to toggle absolute references while writing a formula, and Alt+E,S,V for paste-special values. Six shortcuts, and they cover most of what you do repeatedly.

How Excel gets tested

Practical tests are common in India for accounts, analyst and operations roles. The usual shapes:

• "Here is a sales file. Give me total revenue by region and by month." Pivot table. Five minutes.
• "Match these two lists and tell me what is missing." XLOOKUP or VLOOKUP with IFERROR.
• "Clean this data." TRIM, Text to Columns, Remove Duplicates, consistent date formats.
• "Build a summary sheet." SUMIFS, conditional formatting, a clean layout.

How to describe it on your CV

Do not write "Excel: Advanced". Write what you did with it: "Built a monthly sales summary in Excel using pivot tables and SUMIFS across 8,000 rows; added conditional formatting to flag overdue invoices." That survives a follow-up question. "Advanced" does not.