Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports

Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports

ExcelIsFun via YouTube Direct link

) Add Number Formatting to Values area

8 of 10

8 of 10

) Add Number Formatting to Values area

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) What Excel can do: 1) Calculations, Data Analysis
  3. 3 ) What is Data Analysis?
  4. 4 ) What is a Proper Data Set?
  5. 5 ) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
  6. 6 ) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
  7. 7 ) Format PivotTable with Tabular Layout
  8. 8 ) Add Number Formatting to Values area
  9. 9 ) Compare SUMIFS and PivotTable
  10. 10 ) Summary - Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.