Excel Designer Needed to improve & build existing spreadsheet
Worldwide
We are seeking an experienced excel spreadsheet designer with a strong understanding of excel to improve, expand, and further develop our existing estimating spreadsheet. The objective is to create a robust, user-friendly, and integrated spreadsheet that streamlines the electrical estimating process while improving accuracy, and consistency. Additionally, also implement suitable protections to avoid data overrides, etc. Scope of works: - Build out excel sheets, create dynamic dashboards and reporting tools. - Implement complex formulas to calculate specific pricing, labour and material, etc. - Automatic adjustment of rows, columns to a input, or variable, etc. - Build material list with better UI and accessibility including change log & version - protections throughout spreadsheet cells, inputs, etc as required. - developing prompt boxes, or other more efficient methods to complete estimation, example: (clickable selection of type of work, specific install - then pulls a cells w/ calculations from another sheets in excel file) Desired skills: - Strong Microsoft Excel skills (including complex formulas, Power Query, Power Pivot, Pivot Tables, and VBA/macros where appropriate). - Ability to innovate and think outside of the box to suggest ideas. - Ability to communicate effectively and collaborate throughout development.
- Less than 30 hrs/weekHourly
- 1-3 monthsDuration
- IntermediateExperience Level
$10.00
-
$30.00
Hourly- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:last week
- Interviewing:3
- Invites sent:5
- Unanswered invites:0
About the client
- Australia10:54 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by