Google スプレッドシート 徹底攻略 Overview Welcome Module 1 Module 2 Module 3 Module 4 Module 5 Module 6 Module 7 Module 8 Module 9 Module 10 Module 11 Module 12 Start Learning Google スプレッドシート 徹底攻略 Welcome: Google Sheets Deep Dive (Educator Edition) Start Course Now COURSE MODULES Welcome: Google Sheets Deep Dive (Educator Edition) Module 1: Splitting and joining text and removing duplicates Module 2: Calculating percentages and automatically allocating grades using vlookup Module 3: Calculating average marks and ranking student achievement Module 4: Conditional formatting, inserting images and using checkboxes to trigger conditional formatting. Module 5: Data validation and using named ranges Module 6: Creating and using filters Module 7: Protecting sheets and ranges Module 8: Creating a data summary section by using data validation, vlookup and match Module 9: Analysing data using pivot tables and slicers Module 10: Importing data from other sheets Module 11: Automating your work with macros Module 12: Making your sheets visually attractive by formatting them and using custom number formatting SCOREBOARD POINTS COURSE CHAT