Dynamic Excel Sales Dashboard Creation
€8-30 EUR
Paid on delivery
I have an Excel file with multiple tabs, each representing a month of the year. Within each tab, my products are listed in one column, and the days of the month are represented in rows. The cells that intersect contain a number representing the quantity of products sold on the corresponding day.
I need a new dynamic tab created that has at least two columns: one for products that have sold at least one unit, and another for the total number of items sold. Products that have no sales on a given day should not be displayed.
This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector that filters the products accordingly.
Specific Requirements:
- The new tab should be formatted as a simple table
- The project is in Excel 2016 or earlier
- The day selector should use a calendar input
Ideal skills and experience for the job:
- Proficient in Excel with experience in creating dynamic tabs and using data validation rules
- Attention to detail to ensure accuracy in sales data
- Ability to create clear and simple layouts for easy navigation
Project ID: #38977773
About the project
32 freelancers are bidding on average €62 for this job
"""""""""""""""""""ADVANCE EXCEL EXPERT"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOAR More
-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, Formulas, building an excel file, excel dashbo More
Hi there, I can create Dynamic Sales Dashboard in excel based on your requirements. I've been working as a full-time Excel consultant for over a decade, with particular expertise in Excel VBA and data analysis. With More
Hello employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Dynamic Excel Sales Dashboard Creation ". I have more than 3 years of professional experience in stati More
Hey, I would be happy to work on your job immediately. If you want fast accurate and timely delivery to your task just ping me. I am here and ready to help you. Send me a quick message and we can figure out if we are More
I'm Hira and with over 17+ years of experience in developing business documents, I have the Excel skills you need to create an articulate and powerful sales dashboard. My extensive experience with data manipulation and More
With a comprehensive 5-year experience in Data Analysis, I have successfully tackled similar projects that necessitate consolidating and displaying data in dynamic, easy-to-navigate ways excellently. I am well-versed i More
Hi! As an expert who has extensively worked with Excel and Microsoft Office, I excel at transforming raw data into meaningful insights. Your project title couldn't have caught my attention more effectively! I understan More
Dedicated Freelancer Ready to Elevate Your Project for Dynamic Excel Sales Dashboard Creation. I have a solid background in Microsoft Office and Excel, I bring valuable expertise to your project. I have successfully c More
Greetings, I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. There I am ready to start now. I will make More
Hi, I am a UK-qualified ACCA accountant with seven years of experience in financial analysis, bookkeeping, and Excel-based reporting. With expertise in creating dynamic and user-friendly Excel solutions, I can desig More
Hello, As an experienced full-stack developer and software engineer, I possess a strong command over Excel, proficient in data analysis and visualization. Your project essentially requires careful organization and dyn More
Can do Excel 2016 or Earlier Dashboard Tab: Consolidate the other tabs into summary dashboard. This new tab should be dynamic, allowing me to see which products have sold on a given day. There should be a day selector More
I want to do, I want to do this, can you give it to me? I'll do it for you for free. If you like it, you can give me more work later, and then you can pay.
Hola, soy Camilo y me gustaría postularme para crear la pestaña dinámica que necesitas en tu archivo Excel. Tengo experiencia trabajando con Excel, especialmente en la creación de pestañas dinámicas, tablas y el uso de More
With extensive experience in Excel, I specialize in creating dynamic and interactive spreadsheets that simplify complex data. I am adept at using advanced features such as formulas, pivot tables, and data validation to More
Hello, I propose creating a dynamic tab in Excel with a simple table that updates based on a day selector. This will involve using a combination of formulas, filters, and data validation. The calendar input for day se More
