Dynamic Excel Expertise Required
Budget: ₹1,500 – ₹12,500 INR
I'm in need of a seasoned MS Excel expert to breathe life into my static Excel sheets, turning them into dynamic, functional tools. Key areas you will be focusing on include:
- Data linking and synchronization: You will be tasked with linking my master sheet with approximately 60-70 other sheets. This will allow for effective reporting and data monitoring.
- Conditional formatting and formulas: I require an individual proficient in setting up conditional formatting and formulas to highlight key data points and streamline calculations.
- Interactive dashboards and charts: Visualizing the data is crucial. Thus, expertise in creating interactive dashboards and charts will be invaluable.
The master sheet you will be working with is of medium size, containing between 1000 and 10,000 rows of data. Prior experience in handling similar sized datasets will be advantageous.
- Data linking and synchronization: You will be tasked with linking my master sheet with approximately 60-70 other sheets. This will allow for effective reporting and data monitoring.
- Conditional formatting and formulas: I require an individual proficient in setting up conditional formatting and formulas to highlight key data points and streamline calculations.
- Interactive dashboards and charts: Visualizing the data is crucial. Thus, expertise in creating interactive dashboards and charts will be invaluable.
The master sheet you will be working with is of medium size, containing between 1000 and 10,000 rows of data. Prior experience in handling similar sized datasets will be advantageous.