Spreadsheet

Introduction 0:09

Accessing Google Sheets 0:52

Navigating in Cells and Menus 3:41

Keyboard Shortcuts 6:08

Editing Cell Contents 8:48

Templates 11:21

Using Explore 13:43

Opening and Saving Sheets 16:58

Using Google Drive with Google Sheets 19:38

Showing and Using the Formula Bar and Gridlines 22:11

Basic Formulas 24:10

Using Autofill to Copy Formulas 27:19

Using Autofill to Create Redundant Data 28:59

Simple Formulas 31:11

Formulas with Absolute References 34:27

Cut, Copy, and Paste 39:21

Inserting Rows and Columns 42:15

Wrapping Text, Rotating, and Aligning Cells 45:00

Cell Formatting 47:48

Hiding Rows and Columns 50:49

Freeze Panes and Full Screen View 54:47

Spell Check and Printing 56:54

Sharing and Emailing Sheets 1:00:07

Publishing to Web 1:02:53

Conclusion 1:04:46 

1. Introduction 0:03

2. Single and Multi-Level Sorting 0:11

3. Filtering Records in a List 3:47

4. Search Filter and Filter by Condition 7:32

5. Custom Filter Views 10:07

6. Inserting Data Charts 13:15

7. Formatting and Editing Chart Elements 14:58

8. Adding and Removing Data from Charts 22:48

9. Inserting Sparklines 25:11

10. Alternating Colored Rows 30:46

11. Alternating Colors Button 34:08

12. Creating a Pivot Table 35:30

13. Creating a Pivot Chart 44:21

14. Filtering Within Pivot Tables Using Slicers 46:48

15. Using the IF Function 49:12

16. Introduction to Nesting Functions 57:13

17. VLOOKUP Function 1:00:39

18. Using the IFERROR Function 1:08:01

19. Creating and Applying Names in a Worksheet 1:11:02

20. Summary-Based Functions SUMIF(S) and AVERAGEIF 1:13:02

21. Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns 1:19:41

22. Sharing and Managing Permissions 1:24:52

23. Macros 1:28:14