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

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

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

Full Transcript

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB04-SUMIFSandPivotTables.xlsx Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class16-ExcelBasics04-IntroductionToExcel04.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm 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!