Advanced Excel Formula Creation
Budget: ₹100 – ₹400 INR
I'm looking for an expert in Excel to develop a formula capable of performing a combination of basic arithmetic operations (addition, subtraction, multiplication, division), statistical analysis (sum, average, median), and logical operations (IF statements, conditional formatting) on a large dataset containing more than 1000 cells. The entire work will only involve a single worksheet.
Skills and Experience:
- In-depth knowledge of Excel
- Proficiency in Excel functions and formulas
- Experience handling large datasets
- Understanding of statistical analysis
Your task will involve:
- Creating a user-friendly, efficient formula
- Testing the formula rigorously on provided data
- Ensuring accuracy and prompt delivery
Please only apply if you are highly skilled in Excel and comfortable working with large datasets. Your work should be accurate, precise, and timely.
Shaun is a Sales Director, Food Services Division at a major Food & Beverages Manufacturer. He has just been promoted into his role for top notch sales performance as well his keen analytic aptitude.
True to his nature, he’s constantly on the lookout for newer sources of data to drive business (other than the sales data that comes from internal systems). In a review with his team, he landed on what he thought was right in this space (see attached a sample of this). The spreadsheet has 3 tabs, that have the following:
1) Total spend of his customers (restaurants) across various F&B categories, along with % share of purchases from Shaun’s company
2) Data about non-commercial establishments such as hospitals, schools across different geographic areas.
3) Retail outlets spread across similar geographies.
Shaun would like to use this to perform an “Opportunities Analysis”. He has an annual conference coming up in less than a week to prepare for, but wanted to get this started without delay.
He jotted down a few bullets to convey what he has in mind as the charter for the analysis.
- Get a quick view of share of total spends and F&B spends for existing customers (restaurants)
- What are the adjacent opportunities from the non-commercial establishments to additionally sell into (note that there are no customers currently in the non-commercial segment)
- Retailers is a different business division and hence out of scope for me (Shaun), but some of my customers / prospects could be buying from these retailers – so getting a view of retailer presence adjacent to his customers & prospects will help understand how much of these opportunities are being met / unmet.
- I would like the analyses to be simple, intuitive as well as give me a picture at different levels of geographic granularity as well as by different business segments. In short, “it should the tell a story around where are our biggest opportunities”
Please put together an analysis based on the above brief – not exceeding 10 slides.
Skills and Experience:
- In-depth knowledge of Excel
- Proficiency in Excel functions and formulas
- Experience handling large datasets
- Understanding of statistical analysis
Your task will involve:
- Creating a user-friendly, efficient formula
- Testing the formula rigorously on provided data
- Ensuring accuracy and prompt delivery
Please only apply if you are highly skilled in Excel and comfortable working with large datasets. Your work should be accurate, precise, and timely.
Shaun is a Sales Director, Food Services Division at a major Food & Beverages Manufacturer. He has just been promoted into his role for top notch sales performance as well his keen analytic aptitude.
True to his nature, he’s constantly on the lookout for newer sources of data to drive business (other than the sales data that comes from internal systems). In a review with his team, he landed on what he thought was right in this space (see attached a sample of this). The spreadsheet has 3 tabs, that have the following:
1) Total spend of his customers (restaurants) across various F&B categories, along with % share of purchases from Shaun’s company
2) Data about non-commercial establishments such as hospitals, schools across different geographic areas.
3) Retail outlets spread across similar geographies.
Shaun would like to use this to perform an “Opportunities Analysis”. He has an annual conference coming up in less than a week to prepare for, but wanted to get this started without delay.
He jotted down a few bullets to convey what he has in mind as the charter for the analysis.
- Get a quick view of share of total spends and F&B spends for existing customers (restaurants)
- What are the adjacent opportunities from the non-commercial establishments to additionally sell into (note that there are no customers currently in the non-commercial segment)
- Retailers is a different business division and hence out of scope for me (Shaun), but some of my customers / prospects could be buying from these retailers – so getting a view of retailer presence adjacent to his customers & prospects will help understand how much of these opportunities are being met / unmet.
- I would like the analyses to be simple, intuitive as well as give me a picture at different levels of geographic granularity as well as by different business segments. In short, “it should the tell a story around where are our biggest opportunities”
Please put together an analysis based on the above brief – not exceeding 10 slides.