Job Type: Remote [Full Time]
Time Slots: Morning: (8:00 am to 5:00 pm)
Night: (12:00 am to 9:00 am)
Requirements:
1. Proficiency in using complex formulas, functions (such as VLOOKUP, INDEX, MATCH, and array formulas), and the ability to create and modify pivot tables and pivot charts in Excel and google sheets.
2. Experience in analyzing large datasets and presenting data in a clear, concise manner using advanced charting and graphing techniques, conditional formatting, and data validation tools.
3. Experience with VBA (Excel) and Google Apps Script (Google Sheets) to automate tasks, customize functionality, and integrate with other Google services (e.g., Google Forms, Google Drive).
4. Ability to organize, clean, and efficiently manage data from various sources, ensuring accuracy and reliability in data processing and reporting.
5. Expertise in designing user-friendly and efficient Excel models, templates, and dashboards that adhere to best practices in spreadsheet development.
6. Strong analytical skills with the ability to troubleshoot and resolve complex issues within Excel spreadsheets.
7. A commitment to staying updated with the latest features, best practices, and advancements in Excel and data analysis methodologies.
8. Familiarity with integrating Google Sheets with other APIs and third-party services for enhanced data manipulation, reporting, and dashboards.
Job Details
ITCoderz
.
What is your Competitive Advantage?
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Aqib Irshad
Head of HR, Training & OD
FINCA
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ali Aziz
CEO
Shopistan
Muzammil Baig
Digital Marketing Manager
IT Services Group
Zohaib Ali
Marketing Manager
Digital Online Devices
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
