Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: https://people.highline.edu/mgirvin/Y...
Download Full Written Notes: https://people.highline.edu/mgirvin/Y...
Class web page link: https://people.highline.edu/mgirvin/A...
Topics in this video:
1. (00:01) Introduction
2. (01:22) What Excel can do: 1) Calculations, Data Analysis
3. (01:58 and 03:22) What is Data Analysis?
4. (04:00) What is a Proper Data Set?
5. (06:26) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
6. (18:32) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
7. (21:31) Format PivotTable with Tabular Layout
8. (22:18) Add Number Formatting to Values area
9. (30:00) Compare SUMIFS and PivotTable
10. (32:40) Summary - Conclusion
PivotTable Basics, PivotTables 101, PivotTable Lessons, Free PivotTable Lessons, Learn PivotTables Quickly, Efficient PivotTables, PivotTables Are Easy!

• #education
• #highline_college
• #busn_216
• #mike_girvin
• #excelisfun
• #excel_basics
• #learn_excel
• #excel
• #excel_2016
• #learn_excel_for_free
• #learn_excel_online
• #basic_excel
• #sumifs_function
• #relative_cell_references
• #absolute_cell_references
• #summary_reports_excel
• #pivottables
• #excel_pivottables
• #how_to_create_pivottable
• #pivottable_basics
• #number_formatting_to_values_area
• #format_pivottable_with_tabular_layout
• #pivottables_are_easy
• #compare_sumifs_to_pivottables
• #formulas_or_pivottables