PractiseSkills

Take the free test →

Practice exercises by topic

Excel exercises, Python exercises and AI prompting exercises by topic: 706 short, real tasks in 75 topics. Write the formula, code or prompt and get instant feedback — pick a topic, or take a free test to find your weakest one.

Free Excel test → Free Python test

Excel 510 exercises

Fundamentals

Basic Arithmetic Formulas10 exercises Cell References Basics10 exercises Relative References10 exercises Absolute References10 exercises Mixed References10 exercises Order of Operations10 exercises Numbers + Text in Formulas10 exercises

Math & Rounding

SUM10 exercises ROUND10 exercises ROUNDUP / ROUNDDOWN10 exercises ABS10 exercises INT and MOD10 exercises POWER and SQRT10 exercises

Counting & Averaging

COUNT and COUNTA10 exercises COUNTIF10 exercises COUNTIFS10 exercises AVERAGE10 exercises AVERAGEIF10 exercises MAX, MIN, LARGE, SMALL10 exercises COUNTIF Wildcards & Operators10 exercises

Conditional Logic

Basic IF10 exercises Nested IF10 exercises IFS10 exercises AND / OR / NOT10 exercises IFERROR10 exercises IF with AND / OR10 exercises IF Cell Is Blank10 exercises

Conditional Aggregation

SUMIF10 exercises SUMIFS10 exercises SUMPRODUCT10 exercises AVERAGEIFS, MAXIFS, MINIFS10 exercises

Lookups

VLOOKUP10 exercises XLOOKUP10 exercises INDEX and MATCH10 exercises HLOOKUP10 exercises Nested Lookups10 exercises Lookups With Multiple Criteria10 exercises

Text Functions

LEFT, RIGHT, MID10 exercises LEN10 exercises UPPER, LOWER, PROPER10 exercises TRIM and CLEAN10 exercises CONCATENATE / TEXTJOIN10 exercises FIND and SUBSTITUTE10 exercises TEXT (number formatting)10 exercises Split First and Last Names10 exercises

Ranking & Statistics

RANK10 exercises Percentages and Percent Change10 exercises Weighted Averages10 exercises

Combining Techniques

Formulas Inside Formulas10 exercises IF + Lookup Combos10 exercises Error-Safe Lookups10 exercises

AI prompting 160 exercises

Fundamentals

What Makes a Good Prompt10 exercises Vague vs. Specific10 exercises

Context & Roles

Give Claude Context10 exercises Set a Role and Audience10 exercises Reusable Prompt Templates10 exercises

Shaping the Output

Control the Format10 exercises Show an Example10 exercises Rewrite, Shorten and Change Tone10 exercises

Everyday Work Tasks

Summarise Long Text10 exercises Write Emails and Messages10 exercises Meeting Notes and Action Items10 exercises Spreadsheets and Data10 exercises Finance and Operations Tasks10 exercises

Better Answers

Think Step by Step10 exercises Check the AI's Work10 exercises Refine With Follow-Ups10 exercises

Python & code 36 exercises

HTML

HTML3 exercises

Python

Python Basics5 exercises Python Strings5 exercises Python Lists5 exercises Python Dictionaries5 exercises Python Loops & Conditions5 exercises Python Functions5 exercises

Excel VBA Macros

Excel VBA Macros3 exercises