Download Excel File: https://excelisfun.net/files/EMT1742.xlsx
Learn how to create a Day of Week Totals Sales and Average Sales reports using PivotTable, Sorting, Conditional Formatting, Worksheet Formulas and much more. Learn keyboards, PivotTable, Standard Formulas and Array Formulas.
1. (00:00) Introduction
2. (00:17)
3. (00:27) Add Helper Column using TEXT function.
4. (02:08) PivotTable to create report.
5. (03:35) Sort PivotTable by calculations in values area.
6. (03:50) Add Conditional Formatting to PivotTable.
7. (04:43) Create Days of Week in Worksheet.
8. (05:12) SUMIFS Function.
9. (05:51) AVERAGEIFS function.
10. (06:12) Add Sort & Filter buttons to formula report.
11. (06:42) Add Conditional Formatting to cells with formulas.
12. (07:07) Add Total Row to formula report.
13. (07:48) Array Formula that does not require a helper column. Use SUMPRODUCT function and other array formula elements. See one formula to add and one formula to calculate an average.
14. (10:59) Summary, Closing and Video Links