Clean up and summarize data
How to calculate a weighted average price when quantities differ
Multiply quantity by unit price, sum by product and divide total cost by total quantity. Check why a simple price average can give the wrong answer.
Clean up and summarize data
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.