Completed
Using Sumif 27:53
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Google Sheets for HR - Data Management and Analytics Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start 0:00
- 2 Introduction 0:09
- 3 Setting Up 1:48
- 4 Text to Columns and Smart Fill 3:46
- 5 Calculations and the Today Function 8:59
- 6 Calculating Gross Pay and Days Remaining 15:26
- 7 Using Countif 24:12
- 8 Naming Ranges For Efficient Queries 25:56
- 9 Using Sumif 27:53
- 10 Using Averageif 36:49
- 11 Using Xlookup 40:09
- 12 Xlookup Practice 46:10
- 13 Getting Started with Charts 48:54
- 14 Customizing Charts 53:11
- 15 Inserting Sparklines for Trend Analysis 1:00:24
- 16 Module 1 Recap 1:04:43
- 17 Intro to Module 2 1:05:07
- 18 Converting a List to a Table 1:06:20
- 19 Sorting Data 1:14:28
- 20 Filtering Data 1:19:08
- 21 Calculating Columns with the Table Footer 1:26:14
- 22 Conditionally Formatting Data 1:33:09
- 23 Using Cell Dropdowns to Validate Data 1:41:01
- 24 Editing Cell Dropdowns 1:47:03
- 25 Inserting Suggested Pivot Tables 1:52:25
- 26 Inserting Custom Pivot Tables 2:01:33
- 27 Adding data and filtering a Pivot Table 2:09:31
- 28 Conclusion 2:15:09
