Excel practice exercises

Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.

2 exercises — Beginner · for Data Analyst

Sort:Recommended Difficulty Newest

BeginnerText Functions
Check code length with LEN
Use LEN to validate that product codes are the right length.
LEN
3 min10 points
BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
2	Check code length with LENHarbor Supply — product code import	LEN	Beginner	3 min	10 pts
3	Split a full name with LEFT and FINDHarbor Supply — CRM contact export	LEFT · FIND	Beginner	7 min	15 pts

Clear all filters

Excel practice exercises

Check code length with LEN

Split a full name with LEFT and FIND

Check code length with LEN

Split a full name with LEFT and FIND