Ms Excel

Advanced Excel skills include **the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data**. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

‘Proficient in Excel’. That’s something we’ve all seen at least once when looking through job adverts.

In fact, being proficient in Microsoft Excel is sometimes listed as a more straightforward alternative to being tech-savvy.

But how can you tell whether you’re really ‘proficient’ in Excel or just average? Does this even matter that much to recruiters?

And most of all - how do you prove your Excel proficiency on your resume? Let’s find out

**What are Excel skills and why are they wanted on your resume**

Excel is considered important by recruiters because it allows users to organize data, identify trends, and most importantly - draw priceless conclusions.

It’s not as intuitive as its sibling MS Word, for instance, and requires some time to master. That’s exactly why applicants with strong Excel skills are preferred over others, even if they have less experience.

There are two types of Excel skills - basic and advanced. Basic skills include stuff like being able to add and subtract numbers in different cells, change cell styles, and insert graphs. Advanced Excel skills, on the other hand, include using functions and formulas, creating pivot tables, and knowing how to make your own conditional formatting rules.

And usually, recruiters add ‘Excel skills’ or ‘Proficient Excel user’ to job requirements for two main reasons.

Secondly, to point applicants to the fact that the job will most probably require them to use MS Excel in some form or another.

It’s also worth remembering that an increasing number of recruiters have started using applicant tracking systems (ATS) that screen resumes for certain keywords.

That being said, if knowledge of Excel is mentioned as a job requirement, make sure to list it explicitly in different sections of your resume.

Let’s now look at some examples of specific Excel skills worth adding to your resume

**Examples of Excel skills for your resume**

Instead of just plainly listing ‘Excel’ or ‘Microsoft Excel’ in your skills section, we advise you to try something less common that will help you stand out. You can list these skills in any part of your resume:
**MS Excel fundamental skill set**:

- Task automation using macros and VBA
- Creating dynamic reports with PivotTables
- Building formulas
- Cell formatting
- Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
- Task automation
- Manipulate date, time, text, and arrays
- Building charts and graphs
- Pivot tables and reporting
- Data recording
- VLOOKUP and XLOOKUP
- INDEX MATCH
- Advanced conditional formatting
- Data simulations
- Data validation
- Charts and graphs creationUsed MS Excel to organize company data and budget reports into detailed pivot tables
- Monitored office inventory by tracking stock items with advanced skills in MS Excel
- Automated manual MS Excel tasks using macros which lead to a 12% boost in productivity

**Job Types**: Full-time, Regular / Permanent

**Benefits**:

- Provident Fund

Schedule:

- Day shift
- Fixed shift
- Morning shift

Supplemental pay types:

- Yearly bonus

COVID-19 considerations:
Encourage adherence to Infection Prevention Control measures i.e. provision of mask, practicing of basic hygiene, among others. Ensure that your employee is counselled and is in a reasonable mental state to follow other instructions, such as advice regardi

**Education**:

- Master's (preferred)

**Experience**:

- total work: 5 years (preferred)
- Data analytics ms excel: 6 years (preferred)

**Language**:

- English (preferred)

**Speak with the employer**
+91 9793537525