Excel exercises for beginners

Starting from scratch? Then you're in the right place. You discover how a sheet is laid out, type your first formulas and learn the functions every job application test asks for: IF, COUNTIF, SUMIF and VLOOKUP.

After Beginner you work with a list on your own: you calculate with references and percentages, count and add up with a condition, look things up with VLOOKUP and make a PivotTable.

★Earn your Beginner certificate. All 35 Beginner lessons, and passing the Beginner test. See the certificate

See the module

35 lessons in this module

• The worksheet: cells, rows and columnsBeginner, 13 minFree
• Getting started with formulasBeginner, 14 minFree
• Order of operations and bracketsBeginner, 14 minFree
• The SUM function14 min · first exercises freeBeginner
• MIN, MAX and AVERAGE14 min · first exercises freeBeginner
• Absolute and relative references19 min · first exercises freeBeginner
• Working with percentages18 min · first exercises freeBeginner
• Understanding error messages16 min · first exercises freeBeginner
• Working with several worksheets16 min · first exercises freeBeginner
• Cut, copy, paste and undoBeginner, 6 minFree
• Moving around quickly with the keyboard8 min · first exercises freeBeginner
• Formatting with shortcuts7 min · first exercises freeBeginner
• Selecting with the keyboard8 min · first exercises freeBeginner
• Shortcuts for formulas8 min · first exercises freeBeginner
• COUNT and COUNTABeginner, 15 minFree
• Counting with COUNTIF17 min · first exercises freeBeginner
• Adding up with SUMIF19 min · first exercises freeBeginner
• Comparing: TRUE or FALSEBeginner, 15 minFree
• The IF function20 min · first exercises freeBeginner
• Looking up with VLOOKUP22 min · first exercises freeBeginner
• UPPER, LOWER and PROPER16 min · first exercises freeBeginner
• Joining text16 min · first exercises freeBeginner
• ROUND, ROUNDUP and ROUNDDOWN18 min · first exercises freeBeginner
• Calculating with dates14 min · first exercises freeBeginner
• TODAY and DATE16 min · first exercises freeBeginner
• Freeze Panes and views14 min · first exercises freeBeginner
• Page setup and printing15 min · first exercises freeBeginner
• Formatting cells15 min · first exercises freeBeginner
• Paste Special, inserting and deleting13 min · first exercises freeBeginner
• Excel tables17 min · first exercises freeBeginner
• Sorting dataBeginner, 13 minFree
• Filtering dataBeginner, 14 minFree
• Creating a chart12 min · first exercises freeBeginner
• Sorting by several columns12 min · first exercises freeBeginner
• PivotTables17 min · first exercises freeBeginner

Test yourself

• Test: BeginnerTimer: 45 min🔒 Beginner

AdvancedExpert