Costing Sheet Optimization & Formula Assistance
Budget: £250 – £750 GBP
I've developed a costing and budgeting spreadsheet for my company, but I need some assistance with certain formulas and techniques to enhance its functionality. Most of the work is already done; it's mainly about connecting the pieces properly.
Key Areas of Assistance:
- IF Statements & Nested Functions: I need help with implementing and troubleshooting these formulas.
- Linking Data Between Sheets: There's a need for proper connections across various sheets in the workbook.
- User-Friendly Input Forms: Ultimately, I want to make my sheet more accessible and easier to use for my team.
- I need help with setting up conditional formatting rules to highlight key data points automatically.
The ideal freelancer for this job should have a strong proficiency in Excel, particularly with IF statements and nested functions. Experience in creating user-friendly input forms is a definite plus. I'm estimating this task will take a day or two, as the majority of the sheet is already built and formatted.
The user-friendly input forms should include dropdown menus for easier data selection.
Key Areas of Assistance:
- IF Statements & Nested Functions: I need help with implementing and troubleshooting these formulas.
- Linking Data Between Sheets: There's a need for proper connections across various sheets in the workbook.
- User-Friendly Input Forms: Ultimately, I want to make my sheet more accessible and easier to use for my team.
- I need help with setting up conditional formatting rules to highlight key data points automatically.
The ideal freelancer for this job should have a strong proficiency in Excel, particularly with IF statements and nested functions. Experience in creating user-friendly input forms is a definite plus. I'm estimating this task will take a day or two, as the majority of the sheet is already built and formatted.
The user-friendly input forms should include dropdown menus for easier data selection.