Dynamic Excel Sales Dashboard Creation
€8-30 EUR
착불
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
프로젝트 ID: #38977773
프로젝트 소개
이 일자리에 대한 프리랜서 54 명의 평균 입찰가: €46
"""""""""""""""""""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 기타
-------------------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 기타
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 기타
I have reviewed the file and can create a fully dynamic new tab that displays: 1. The products sold. 2. The total number of items sold. This tab will allow you to dynamically filter and view which products were sold on 기타
Ready to create the required dynamic tab functioning as you described. Total sales for items YTD (none zero sales items only) and a date picker to view total sale of items in a specific day (none zero sales items only) 기타
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 기타
Hi sir, I have a lot experience I can be the best for your project. I will do this project without any mistake. You can trust me. Please give me a chance so that I can show you my skill and tell you about my hard work 기타
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 기타
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 기타
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 기타
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 기타
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 기타
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 기타
Hola, Estaría encantado de ayudarte a crear una pestaña dinámica en Excel adaptada a tus necesidades para el seguimiento de las ventas de productos. Con años de experiencia trabajando en proyectos de análisis de datos 기타
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 기타
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 기타
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 기타
