Advanced Excel Expert for BOORA Management
Budget: ₹600 – ₹1,500 INR
We are a manufacturing company that sells and uses BOORA (iron scrap) for various purposes. We already have a basic Excel worksheet that contains all the raw data related to BOORA. What we need is a skilled Excel expert who can transform this data into a more impressive, interactive, and advanced material sheet with formulas and features to improve usability and presentation.
The goal is to make the data more actionable, trackable, and visually appealing, allowing us to better manage both the in-house usage and sales of the material.
Project Requirements:
Data Enhancement:
Optimize and clean up the raw data (if necessary).
Ensure all columns are clearly labeled, structured, and easy to navigate.
Interactive Elements:
Create dropdown lists, checkboxes, or other interactive elements that improve user input.
Implement dynamic charts or dashboards that update based on the data.
Advanced Formulas:
Use complex formulas like VLOOKUP, INDEX-MATCH, SUMIFS, or custom formulas to automate calculations.
Implement conditional formatting to highlight trends, low stock levels, or discrepancies.
Track in-house usage and sales in a way that’s easy to compare, forecast, and analyze.
Visualization & Reporting:
Generate summary reports (e.g., sales trends, stock levels, in-house consumption).
Create visual elements like charts/graphs that represent key data points effectively.
Ensure that the sheet is user-friendly and intuitive, even for people who may not be familiar with the underlying data.
Usability & Security:
Make sure the worksheet is well-organized and easy for non-expert users to interact with.
Advanced proficiency in Excel (formulas, pivot tables, charts, etc.).
Knowledge of data validation, conditional formatting, and creating user-friendly interfaces in Excel.
Experience with designing custom reports or dashboards within Excel.
Ability to simplify complex data and present it in an easy-to-understand way.
Strong attention to detail to avoid errors in data and formulas.
The goal is to make the data more actionable, trackable, and visually appealing, allowing us to better manage both the in-house usage and sales of the material.
Project Requirements:
Data Enhancement:
Optimize and clean up the raw data (if necessary).
Ensure all columns are clearly labeled, structured, and easy to navigate.
Interactive Elements:
Create dropdown lists, checkboxes, or other interactive elements that improve user input.
Implement dynamic charts or dashboards that update based on the data.
Advanced Formulas:
Use complex formulas like VLOOKUP, INDEX-MATCH, SUMIFS, or custom formulas to automate calculations.
Implement conditional formatting to highlight trends, low stock levels, or discrepancies.
Track in-house usage and sales in a way that’s easy to compare, forecast, and analyze.
Visualization & Reporting:
Generate summary reports (e.g., sales trends, stock levels, in-house consumption).
Create visual elements like charts/graphs that represent key data points effectively.
Ensure that the sheet is user-friendly and intuitive, even for people who may not be familiar with the underlying data.
Usability & Security:
Make sure the worksheet is well-organized and easy for non-expert users to interact with.
Advanced proficiency in Excel (formulas, pivot tables, charts, etc.).
Knowledge of data validation, conditional formatting, and creating user-friendly interfaces in Excel.
Experience with designing custom reports or dashboards within Excel.
Ability to simplify complex data and present it in an easy-to-understand way.
Strong attention to detail to avoid errors in data and formulas.