← All modules
Week 2
Spreadsheets I
Data entry standards, formatting, SUM, AVERAGE and COUNT, sorting and filters, data validation, sharing and version history
Output: A content calendar sheet
Video lessons
About 55 minutes in total, at your own pace
- 1.Clean data entry15 min
- 2.SUM, AVERAGE and COUNT20 min
- 3.Sort, filter, validation and sharing20 min
Lessons play inside the portal for accepted interns.
Module outline
Goals
- Enter clean data: one fact per cell, consistent dates
- Use SUM, AVERAGE and COUNT
- Sort, filter and add data validation (drop-down lists)
- Share a sheet safely and use version history
Exercise
Build a content calendar in Google Sheets for 4 weeks: date, platform, pillar, caption idea, status (drop-down). Use sample data only.