“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

In the Profit Analysis worksheet:
a. Create a Pivot Table using numeric data from Profit column.
b. Display the total profit for each of the four classes of cars.
c. Display the total profit for Airport as well as the Downtown location.
d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.

Solved by T. D. in 23 mins

calculate (using profit calculator) minimum sale price needed to achieve set profit margin for various cost price increments

Solved by S. H. in 23 mins

I would like to create a spider web chart using a quadratic equation and a combo chart for linear equation.

Solved by V. U. in 27 mins

I have a table in excel that has:
Location Car Class Revenue NumberofCars Overhead Profit Profit per car
Downtown Economy $804,931 5,564 $278,200 $526,731 94.67
Airport Economy
Airport Premium
Downtown Premium
I need to do a pivot table that will display the Average profit per car for Economy as well as Premium
Then showing the average profit per location
Then Average profit per car for all cars
I am not clear on how to use Average with the pivot table

Solved by Z. D. in 16 mins

I need help in doing my assignment with search function excel VBA solver (search for maximum profit)

Solved by V. Y. in 11 mins