← All modules
Week 3
Spreadsheets II
IF, SUMIFS and COUNTIFS, XLOOKUP and VLOOKUP, conditional formatting, pivot tables and charts, in both Excel and Google Sheets
Output: An inquiry tracker with a summary dashboard, built on sample data
Video lessons
About 70 minutes in total, at your own pace
- 1.IF, SUMIFS and COUNTIFS25 min
- 2.XLOOKUP and VLOOKUP20 min
- 3.Pivot tables, charts and conditional formatting25 min
Lessons play inside the portal for accepted interns.
Module outline
Goals
- Use IF, SUMIFS and COUNTIFS
- Look up values with XLOOKUP and VLOOKUP
- Highlight with conditional formatting
- Summarize with pivot tables and charts, in Excel for the web and Google Sheets
Exercise
Build an inquiry tracker from the sample data your supervisor shares, then a one-screen dashboard: inquiries per week, per service and per channel.