Office 2016 16

Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports

DESCRIPTION

Topics in this video:
(00:01) Introduction
(01:22) What Excel can do: 1) Calculations, Data Analysis
(01:58 and 03:22) What is Data Analysis?
(04:00) What is a Proper Data Set?
(06:26) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
(18:32) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
(21:31) Format PivotTable with Tabular Layout
(22:18) Add Number Formatting to Values area
(30:00) Compare SUMIFS and PivotTable
(32:40) Summary – Conclusion

NOTES

WORKBOOKS

Download “Office 2016 Video 16” EB04-SUMIFSandPivotTables.xlsx – Downloaded 5 times – 506 KB







Be the first to comment

Leave a Reply