00:00 Introductions
00:47 Create a use mapping and generate a table
02:42 VLOOKUP function with the Formula Wizard
04:46 Working with errors using the IFERROR function
00:00 Introduction
00:25 Insert a pivot and copy paste values
01:15 Sort data and sequence
01:01 Replace the amount values divided by 1,000
02:40 Review of the steps - Check your work
Demonstration of using a Google Sheet to organize grading of student presentations and using Jonathan's Python script to collate instructor and student feedback for distribution to the teams. …