Advanced Excel Sheet Development
Budget: $10 – $30 USD
We need an Excel expert to create a comprehensive and automated Excel workbook to track jobs, calculate payouts, and manage financials for two different companies: "CRST Solutions" and "LL Flooring". The workbook should include dropdown lists for easy data entry and formulas to automate calculations
we want to be able to add customers name account number date job was done. and calculate the number of jobs each installer did and how much they made including the company.
then what ever the company makes "gary calderon llc" should be didvided on excel to both partners who are
Argeliz pepin and Gary calderon
The chosen candidate should understand the intricacies of Excel 2019, as version 2404 Build 16.0.17531.20152 64-bit will be utilized. Excel skills such as Macros, Pivot Tables, VLOOKUP and complex formulas are necessary to accomplish the tasks.
The functionalities essential for this project are:
- Data Entry and Calculation: Accurate entries must be ensured and mathematical computations executed smoothly.
- Data Analysis and Visualization: Understand trends, patterns, and interpret the data graphically.
- Automated Reporting: Create reports updated in real-time using raw data.
The sheet will house in excess of three worksheets, hence requiring skillful management of complex workbook navigation and references.
Ideal applicants possess strong attention to detail and excellent problem-solving abilities. Familiarity with dynamic, interactive spreadsheets is also preferred. If you can visualize data in clear, creative, and insightful ways while establishing an easy-to-use data entry and reporting system, this project is for you.
we want to be able to add customers name account number date job was done. and calculate the number of jobs each installer did and how much they made including the company.
then what ever the company makes "gary calderon llc" should be didvided on excel to both partners who are
Argeliz pepin and Gary calderon
The chosen candidate should understand the intricacies of Excel 2019, as version 2404 Build 16.0.17531.20152 64-bit will be utilized. Excel skills such as Macros, Pivot Tables, VLOOKUP and complex formulas are necessary to accomplish the tasks.
The functionalities essential for this project are:
- Data Entry and Calculation: Accurate entries must be ensured and mathematical computations executed smoothly.
- Data Analysis and Visualization: Understand trends, patterns, and interpret the data graphically.
- Automated Reporting: Create reports updated in real-time using raw data.
The sheet will house in excess of three worksheets, hence requiring skillful management of complex workbook navigation and references.
Ideal applicants possess strong attention to detail and excellent problem-solving abilities. Familiarity with dynamic, interactive spreadsheets is also preferred. If you can visualize data in clear, creative, and insightful ways while establishing an easy-to-use data entry and reporting system, this project is for you.