Alternative of pivot table- Excercise-3

[rkbisht2019]

Hi All,
I need solution for below four questions without pivot table. I am just a beginner in excel, your solution will given an idea for learning it with example.

Please find attached dummy dataset for exercise.

Which is the best sales channel basis the total revenue - offline or online

calculate the count of orders & value of revenue basis the order priority

Calculate the city wise profit amount and %

calculate year wise revenue and show the growth % over the years

Prepare the city wise chart for total revenue in primary axis % in secondary axis

 

[vletm]

rkbisht2019
... tries to do own Excercise per

Filter Records and find out average selling price per year

Hi All, I need to find out the average selling price of each seller in Year 2020 vs Year 2021? I need to use function not taking help of pivot table. Seller Year-2020 Year-2021 Deepak Rahul Amit Rashmi Vinay Prateek

chandoo.org

reply.
And if there are huge challenges, then rkbisht2019 will ask help again.