Walk into almost any office in Haryana — a shop's back office, a school admin desk, a company's accounts room — and you'll find Excel open on the screen. Knowing a handful of the right formulas is one of the most useful, low-cost job skills you can pick up. Here are the 10 that actually get used, explained in plain language.
Why Excel still matters for jobs
You don't need to be an "Excel expert" to stand out. Most office work uses the same few formulas again and again — adding things up by condition, looking up a value, cleaning text. Get comfortable with those and you can walk into a data-entry, accounts, or admin role and be useful from day one.
Nobody in an office is impressed by fancy formulas. They're impressed by someone who can get the monthly numbers right, quickly, without errors. That's what these ten are for.
The 10 formulas, explained simply
| Formula | What it does (in plain words) |
|---|---|
| SUM | Adds up a range of numbers — the everyday workhorse. |
| AVERAGE | Finds the average of a range — sales per day, marks, etc. |
| IF | Makes a decision: "if this is true, show A, otherwise show B" (e.g. Pass/Fail). |
| SUMIF | Adds numbers only when a condition is met — total sales for one product. |
| COUNTIF | Counts how many cells meet a condition — how many "Paid" entries. |
| VLOOKUP | Looks up a value in a table — find a price or name from an ID. |
| XLOOKUP | The newer, easier lookup that replaces VLOOKUP in modern Excel. |
| CONCAT / & | Joins text together — combine first and last name into one cell. |
| TRIM | Removes extra spaces from messy text — cleans up imported data. |
| LEFT / RIGHT / MID | Pulls out part of a text — the first 4 digits of a code, for example. |
If you learn just SUM, IF, SUMIF, COUNTIF and VLOOKUP well, you already cover the majority of everyday office tasks. The rest make you faster and cleaner.
How to actually get good at these
Reading a list won't make you employable — practice will. Here's a sensible way to build the skill:
- Type them yourself on real data (a mock sales sheet or marksheet), don't just watch videos.
- Break things on purpose — see what error a wrong VLOOKUP gives, so you can fix it later.
- Rebuild a real task — recreate a monthly summary from scratch until it feels routine.
Where to learn Excel properly in Hisar
If you want structured, hands-on Excel as part of a job-ready course, two Hartron options include it. CIFT (Course in IT Foundation & Tools) covers Excel for finance alongside IT and Tally basics, and CCBA (Certificate Course in Computer Basics and Accounting) teaches advanced MS Office for business work. Both are practical, office-focused courses.
| Course | Good for | Duration & fee at Hartron Hisar |
|---|---|---|
| CIFT | Excel for finance + IT and Tally basics | 26 weeks · ₹10,000 (₹9,000 lumpsum) |
| CCBA | Advanced MS Office for business/office roles | 26 weeks · ₹10,000 (₹9,000 lumpsum) |
Not sure which fits your goal? Bring us your target job and we'll suggest honestly. Call 92158-38058.
Frequently asked questions
Which Excel formulas are most important for a job?
For most office roles, SUM, IF, SUMIF, COUNTIF and VLOOKUP cover the majority of everyday tasks. Add AVERAGE, XLOOKUP, TRIM, CONCAT and LEFT/RIGHT/MID to be faster and cleaner.
Do I need to be good at maths to learn Excel?
No. Basic comfort with numbers is enough. Excel does the calculation for you — your job is to know which formula to use and how to set it up correctly.
Can I learn Excel as part of a course in Hisar?
Yes. Hartron's CIFT teaches Excel for finance alongside IT and Tally basics, and CCBA teaches advanced MS Office for business work. Both give hands-on practice.
How long are the CIFT and CCBA courses and what do they cost?
Both CIFT and CCBA are 26 weeks and cost Rs 10,000, or Rs 9,000 as a one-time lumpsum, at Hartron Hisar.