We are seeking a highly proficient MS Excel Specialist with a strong command of Microsoft Office 365 Excel and related tools. The ideal candidate will have 2 years of experience working with advanced Excel functionalities and will be adept at creating efficient data solutions using formulas, pivot tables, and automation techniques. Fresh candidates with internships or project experience at reputable organizations are also encouraged to apply.

Key Responsibilities: 

  • Develop and manage complex Excel spreadsheets, models, and reports. 
  • Use advanced Excel functions such as VLOOKUP, XLOOKUP, SUMIFS, and conditional formatting for data analysis. 
  • Create and maintain dynamic dashboards using Excel charts and pivot tables. 
  • Implement Power Query and Power Pivot for data cleaning and automation. 
  • Automate repetitive tasks with VBA macros and Excel automation tools (preferred but not required). 
  • Collaborate with various teams to understand data requirements and provide meaningful insights

Required Skills & Expertise: 

  • Strong proficiency in Microsoft Office 365 Excel
  • Advanced knowledge of Excel formulas, pivot tables, and charts. 
  • Familiarity with Power Query and Power Pivot
  • Ability to clean, manipulate, and analyze large datasets. 
  • Basic understanding of VBA for automation (preferred). 
  • Strong attention to detail and analytical skills. 

Qualifications: 

  • Minimum 2 years of experience in a professional environment working extensively with Excel. 
  • Bachelor’s degree in Business, Finance, Data Science, IT, or a related field. 
  • Fresh graduates with internships or project experience in reputable organizations are also eligible.

Preferred: 

  • Experience with Power BI or other data visualization tools. 
  • Knowledge of basic SQL or other data management software is a plus.

 

Job Details

Industry:
Functional Area:
Total Positions:
2 Posts
Job Shift:
First Shift (Day)
Job Type:
Job Location:
P.E.C.H.S, Karachi, Pakistan
Gender:
No Preference
Minimum Education:
Bachelors
Degree Title:
Business, Finance, Data Science, IT, or a related field
Career Level:
Experienced Professional
Minimum Experience:
2 Years
Apply Before:
Jan 03, 2025
Posting Date:
Dec 02, 2024

Experts Consulting BD

Consultants · 11-50 employees - Karachi

Experts Consulting is an enterprise software consulting firm serving the manufacturing, distribution & Retail industries throughout EMEA, as well as companies with global operations.

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Similar Job Titles

Sales Specialist

DG Tronix, Multiple Cities, Pakistan
Posted Nov 25, 2024

Data Entry Operator

Confidential , Lahore, Pakistan
Posted Nov 21, 2024

Office Assistant

Zafar Associates LLP, Lahore, Pakistan
Posted Nov 26, 2024

Electrical Engineer

Rolin Technology, Lahore, Pakistan
Posted Dec 02, 2024
View All
I found a job on Rozee!