Tech Skills Beginner · 3h · English

Excel for Work: Zero to Productive

Master the Excel skills hiring managers actually look for.

About this course

Learn the Excel skills that show up in 80% of job ads: formulas, pivot tables, charts, and data cleaning. Built for office, admin, and entry-level analytics roles.

What you'll learn

✓Navigate Excel efficiently with shortcuts
✓Use essential formulas: IF, VLOOKUP, INDEX/MATCH, SUMIFS
✓Clean messy data and spot errors
✓Build pivot tables and charts that tell a story

Requirements

Any version of Excel (2016+) or Google Sheets

Syllabus

3 modules · 8 lessons

▶ 1. The Excel interface Preview 10m

▶ 2. Shortcuts that save hours 15m

▶ 1. IF, AND, OR in practice 20m

▶ 2. VLOOKUP and INDEX/MATCH 25m

▶ 3. SUMIFS and COUNTIFS 20m

▶ 1. Cleaning messy data 20m

▶ 2. Pivot tables from scratch 25m

▶ 3. Charts that communicate 20m

Instructor

Brian Otieno

Data analyst and trainer. Former BI lead at a pan-African fintech.