技能

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
在之前申请:
Apr 01, 2024
发布日期:
Mar 22, 2024

ITCoderz

· 1-10 员工 -

.

你最大的竞争优势

快速得到有竞争力的分析和专业的对你的评定
联系我们团队的专业顾问来提升你的简历
尝试罗资 专业版
我在ROZEE上找到工作啦!