Working with Excel spreadsheets
34 USD Hello. There is an Excel table where orders are entered. The frequency of orders is weekly. On average, there are 30-40 clients per week.
Task:
1 It is necessary to divide the total array of orders for 8 months into weekly ones. That is, create 32 tables (8x4=32)
2 Write formulas that will show: the total amount of all orders for the week, the number of new customers for the entire period, the average number of repeat orders for the period, the average order check, the share of each product in weekly/monthly revenue.
-
1 day11 USD
1 day11 USD
Hello, I will help you complete the task. My experience and skills are suitable. Feel free to reach out.
-
2 days22 USD
421 13 0 2 days22 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
Winning proposal3 days34 USD
4467 102 0 Winning proposal3 days34 USD
Good day. I will be happy to help. I will complete everything quickly and efficiently!
-
7 days30 USD
957 19 0 7 days30 USD
Good day.
I understand the task. First, I need to review the records, bring everything into one format, and divide it by weeks.
I can calculate the total amounts each week and in the overall file. It is also possible to add overall statistics by weeks (fluctuations in amount, number of orders, etc.)
Send the table, and during the work, I will suggest how to optimize/automate the processes.
-
1 day36 USD
928 14 0 1 day36 USD
Ready to take on your task.
Everything can be calculated and also provided in graphical form.
Feel free to reach out.
-
3 days22 USD
567 28 2 3 days22 USD
Good evening... I can complete your project. I have similar completed projects where order statistics were compiled. Write to me and we will discuss.
-
Приветствую. Предлагаю не извращаться и автоматизировать это в Power BI на бесплатном тарифе. Там можно не только все это автоматизировать, но и создать визуализации. Сделаю быстро, обращайтесь. Пример возможностей Power BI тут: https://data-tigers.com/salons/
-
Здравствуйте Алан !
Только в в Excel ?
М.б. подойдёт другой способ ? -
Charlotte