Advance Google Sheets
📄Advance Google Sheets Objectives
https://docs.google.com/document/d/1h...
🔗GoogleHelp-Iowa Sheets Page
https://sites.google.com/a/iowa.gov/g...
Contents in Video
0:00 - Welcome
0:35 - Objective 1: Make a Copy
📄https://docs.google.com/document/d/1h...
3:09 - Objective 2: Let’s Sort
📄https://docs.google.com/document/d/1h...
12:28 - Objective 3: Let’s Filter
📄https://docs.google.com/document/d/1h...
35:35 - Objective 4: Let’s do a Pivot Table
📄https://docs.google.com/document/d/1h...
46:55 - Objective 5: Let’s Explore and Add a Chart
📄https://docs.google.com/document/d/1h...
59:07 - Objective 6: Let’s Add a Slicer
📄https://docs.google.com/document/d/1h...
1:06:00 - Objective 7: Prepare for Functions and Formulas
📄https://docs.google.com/document/d/1h...
1:07:11 - Objective 8: Create a Vlookup
📄https://docs.google.com/document/d/1h...
1:25:03 - Objective 9: Conditional Formatting and Alternating Colors
📄https://docs.google.com/document/d/1h...
1:31:40 - Objective 10: Let’s Macro
📄https://docs.google.com/document/d/1h...
1:38:18 - Objective 11: Let’s Importrange and Query
📄https://docs.google.com/document/d/1h...