Skills

Dashboard Advanced Formulas VBA

Project Detail

Time Slots:

 

Morning: (8:00 am to 5:00 pm)

Evening: (4:00 pm to 1: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.

Location:
Compensation:
PKR 75,000/month
Compensation Details:
50,000 to 75,000
Project Type:
Work From Home
Minimum Hours Per Day:
8 Hours
Apply Before:
Apr 01, 2024
Posting Date:
Mar 22, 2024

ITCoderz

Information Technology · 1-10 employees -

.

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
I found a job on Rozee!