Lesson 8: Everyday Office & Spreadsheet Tasks
Troubleshoot spreadsheet formulas, clean messy text lists, and organize data tables safely.
AI is an exceptional tool for translating what you want to do into exact spreadsheet formulas (e.g. 'How do I calculate total hours worked minus lunch breaks in Google Sheets?').
Always use dummy/sample numbers when asking for spreadsheet help on public AI tools.
Hands-On Workplace Exercise
Ask an AI how to format a phone number column in Excel or Google Sheets using 3 rows of fake numbers.
Knowledge Check
Test your understanding with this short self-check. Feedback is instant.