Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn about how to create a single cell revenue formula that lookups up all prices and multiplies by all quantities and then adds.
Topics:
1. (00:00) Introduction
2. (00:49) About Revenue Calculation
3. (00:59) Three Step Method
4. (01:27) XLOOKUP & SUMPRODUCT
5. (01:32) LOOKUP & SUMPRODUCT
6. (03:06) Summary
7. (03:21) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula