Dynamic Excel Sales Dashboard Creation

オープン 投稿 53 分前 着払い 終了日 6 日
オープン 着払い 終了日 6 日

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

プロジェクトについて

42個の提案 入札可能 リモートプロジェクト アクティブ 最近

42人のフリーランサーが、平均€53 で、この仕事に入札しています。

AccountantArman

"""""""""""""""""""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 もっと

€30 EUR 1日以内
(309件のレビュー)
7.5
rahulg5466

-------------------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 もっと

€30 EUR 1日以内
(83件のレビュー)
5.8
ravinderkumar248

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 もっと

€30 EUR 2日以内
(163件のレビュー)
6.1
stheven19

As a seasoned Excel and VBA expert with an emphasis on creating dynamic, user-friendly dashboards, I am thrilled to offer my skills for your sales dashboard creation task. Having successfully completed over 45 projects もっと

€30 EUR 1日以内
(31件のレビュー)
5.5
monicawriter99

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 もっと

€97 EUR 3日以内
(20件のレビュー)
4.7
abdulrehmanabid2

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 もっと

€8 EUR 1日以内
(39件のレビュー)
4.3
najmulhosaon08

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 もっと

€19 EUR 1日以内
(2件のレビュー)
3.9
HiraFFreelancer

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 もっと

€200 EUR 7日以内
(2件のレビュー)
4.0
fazalimamnuttkan

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 もっと

€19 EUR 7日以内
(12件のレビュー)
3.9
GraphicsHub2k24

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 もっと

€8 EUR 1日以内
(5件のレビュー)
3.5
FardinkhanBoss

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 もっと

€19 EUR 7日以内
(5件のレビュー)
3.4
Sunitav36

Hi, I have 13+ years of experience. I'll provide you quality work according to your instructions. Please award me the project so that we can discuss it more. Below are the my services Excel | Power Pivot | PPT | Das もっと

€19 EUR 1日以内
(22件のレビュー)
3.9
aqsaishrat

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 もっと

€50 EUR 1日以内
(3件のレビュー)
3.7
tauqeer0307

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 もっと

€20 EUR 1日以内
(レビュー1件)
3.6
farooqwaseem

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 もっと

€30 EUR 1日以内
(レビュー1件)
1.7
sehrisha48

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 もっと

€976 EUR 16日以内
(0件のレビュー)
0.0
pcworkshops

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 もっと

€25 EUR 7日以内
(0件のレビュー)
0.0
Suns786

Hello, I am skilled in Excel and can create a dynamic Monthly Sales MIS Report. I will design a new tab with a simple table showing products that sold at least one unit, with a day selector to filter sales data by day もっと

€19 EUR 7日以内
(0件のレビュー)
0.0
raja0746

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.

€19 EUR 7日以内
(0件のレビュー)
0.0
CamiloOchoa20

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 もっと

€24 EUR 1日以内
(0件のレビュー)
0.0