INTL
Freelancer
어려움
외주
원격 가능
Excel Macro and Formula Specialist
예산
$750~$1,500 AUD
예상 기간
2~3주
난이도
어려움
기술 스택
Excel
Excel VBA
Excel Macros
Visual Basic
Data Analysis
Data Management
Troubleshooting
Conditional Formatting
Complex Formulas
AI 분석 요약
이 프로젝트는 기존 Excel 스프레드시트의 복잡한 매크로, 조건부 서식, 수식 오류 등을 수정하고 기능을 개선하는 것을 목표로 합니다. 특히 직원의 프로젝트/현장 배정, 데이터 계층 구조 구현, 쉬운 데이터 추가 및 주간 집계 정확성 확보가 중요합니다. Excel VBA, 매크로 및 복잡한 수식에 대한 깊은 이해와 문제 해결 능력을 갖춘 전문가가 필요합니다.
프로젝트 원문 설명
I need an Excel expert to fix some issues in my spreadsheet. The project is urgent and I require it to be completed ASAP.
Key Issues:
- Difficulty with macros
- Conditional statements in formulas not working correctly
- Colour coding if employees aren't inducted on a particular project
- Formulas page where employees have their site and project inductions displayed and easily edited by excel basic users
- Fix convoluted formulas within the spreadsheet
- If Employees are scheduled for a particular day they disappear from the list to avoid double ups.
- Have a tiered system that references project first, site second and job third
- Jobs Merge and center under their selected site and sites merge and center under their selected project so they can be all seem in the same area of the spreadsheet
- Make it easy to add new projects/Sites/jobs
- Make it easy to add new employees
- Make it easy to continue past the 4 weeks within the spreadsheet already.
- Fix the tally at the end of each week as it isn't calculating correctly
- Excel Spreadsheet attached.
Ideal Skills and Experience:
- Proficiency in Excel macros and VBA
- Strong understanding of conditional statements and complex formulas
- Ability to troubleshoot and resolve spreadsheet issues quickly
- Experience with data formatting and spreadsheet optimization
Please provide examples of similar work done and estimated time to complete.
Key Issues:
- Difficulty with macros
- Conditional statements in formulas not working correctly
- Colour coding if employees aren't inducted on a particular project
- Formulas page where employees have their site and project inductions displayed and easily edited by excel basic users
- Fix convoluted formulas within the spreadsheet
- If Employees are scheduled for a particular day they disappear from the list to avoid double ups.
- Have a tiered system that references project first, site second and job third
- Jobs Merge and center under their selected site and sites merge and center under their selected project so they can be all seem in the same area of the spreadsheet
- Make it easy to add new projects/Sites/jobs
- Make it easy to add new employees
- Make it easy to continue past the 4 weeks within the spreadsheet already.
- Fix the tally at the end of each week as it isn't calculating correctly
- Excel Spreadsheet attached.
Ideal Skills and Experience:
- Proficiency in Excel macros and VBA
- Strong understanding of conditional statements and complex formulas
- Ability to troubleshoot and resolve spreadsheet issues quickly
- Experience with data formatting and spreadsheet optimization
Please provide examples of similar work done and estimated time to complete.
Freelancer에서 원본 확인
원본 보기