Hi Mynda,
Can you explain to me how you manually calculated the "Average Cost Per Sale" under the heading "Marketing Cost Table", were did you get the data?
Cheers Valerie!
Hi Valerie,
On the Leads Data sheet in cells Y59:AE68 you'll see there are formulas that divide the values in the marketing cost PivotTable by the # of sales in the # of Sales PivotTable.
Mynda
Cheers Mynda,
Thanks for your prompt response!
Valerie!
Dear Mynda,
I am attempting to do a similar analysis of the above for my own business.
Would it be possible for you to attach a copy of a marketing cost table?
Many thanks!
Nick
Hi Nick,
The Marketing Cost table Valerie is referring to is available in the Excel Dashboard course working files and it's my version of the Homework assignment.
You should have already downloaded the zip file containing all of the working files (it's available to download from the link above the video from lesson 1.01 of the dashboard course) and the file is called mynda_homework_example.xlsx
Let me know if you can't find it.
Mynda
