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
Про проект
Доручено:
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 Більше
73 фрілансерів(-и) готові виконати цю роботу у середньому за €41
"""""""""""""""""""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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
Hi Sir, I have worked as a finance manager in local NGOs, Schools, Chartered Accountant Company & Super Markets, and I have over 15 years of experience. My qualification is an MBA (Master of Business Administration) Більше
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 Більше
