Practise your weak spots
Mark what you find difficult and get new exercises every time, with feedback and an explanation. Anything that goes wrong comes back until it sticks.
Got two minutes? Go over functions, the ribbon, shortcuts and error messages with the flashcards.
Your next exercises
Mark below what you find difficult, or take the placement test. Mistakes in the lessons count too.
- Adding two cells New to you
- Adding up a short column New to you
- Calculating with cells New to you
- Order of operations and brackets New to you
On the free plan you practise ten basic questions each day, with new data every time. Unlimited practice, per skill and matched to your mistakes, is part of the modules.
Basics
- Adding two cellsBeginner
- Adding up a short columnBeginner
- Calculating with cellsBeginner
- Order of operations and bracketsBeginner
- Adding up with SUMBeginner
- Working out an averageBeginner🔒 Beginner
- Highest and lowest valueBeginner🔒 Beginner
- VAT and percentagesBeginner🔒 Beginner
- Percentage growthBeginner🔒 Beginner
- Locking references with $Beginner🔒 Beginner
- Percentage of an amountBeginner🔒 Beginner
- Price after a discountBeginner🔒 Beginner
- Share of the totalBeginner🔒 Beginner
- Taking VAT out of an amountBeginner🔒 Beginner
- Profit marginBeginner🔒 Beginner
- Mixed referencesBeginner🔒 Beginner
- Calculating with another sheetBeginner🔒 Beginner
- Adding up part of a columnBeginner🔒 Beginner
- Finding a value on the sheetBeginner🔒 Beginner
- Counting the cells in a rangeBeginner🔒 Beginner
- Typing in a cellBeginner🔒 Beginner
- Subtracting two cellsBeginner🔒 Beginner
- Dividing by a cellBeginner🔒 Beginner
- Brackets in an averageBeginner🔒 Beginner
- SUM over two rangesBeginner🔒 Beginner
- Gap between highest and lowestBeginner🔒 Beginner
- Empty cells in an averageBeginner🔒 Beginner
- Share of a fixed totalBeginner🔒 Beginner
- Fixing a typo in a functionBeginner🔒 Beginner
- Fixing a reference to an empty cellBeginner🔒 Beginner
- References after deleting a columnBeginner🔒 Beginner
- Circular referencesBeginner🔒 Beginner
- Adding up a range on another sheetBeginner🔒 Beginner
- Comparing two sheetsBeginner🔒 Beginner
- A sheet name with a spaceBeginner🔒 Beginner
- A fixed value on another sheetBeginner🔒 Beginner
- Adding up the same cell across sheetsBeginner🔒 Beginner
- A difference without a minus signBeginner🔒 Beginner
- Compound interest with POWERBeginner🔒 Beginner
- The side of a square with SQRTBeginner🔒 Beginner
Counting and adding with conditions
- Counting rowsBeginner🔒 Beginner
- Counting by textBeginner🔒 Beginner
- Counting with greater or less thanBeginner🔒 Beginner
- Counting with two conditionsAdvanced🔒 Advanced
- Adding up with a conditionBeginner🔒 Beginner
- Adding up with two conditionsAdvanced🔒 Advanced
- Average per groupAdvanced🔒 Advanced
- Counting with wildcardsAdvanced🔒 Advanced
- Counting numbersBeginner🔒 Beginner
- Counting empty cellsBeginner🔒 Beginner
- Counting what something isn'tBeginner🔒 Beginner
- A condition from a cellBeginner🔒 Beginner
- Adding up above a limitBeginner🔒 Beginner
- Summary per groupBeginner🔒 Beginner
- Highest or lowest per groupAdvanced🔒 Advanced
- Average with two conditionsAdvanced🔒 Advanced
- What share is filled in?Beginner🔒 Beginner
- Share of a groupBeginner🔒 Beginner
- Counting between two limitsAdvanced🔒 Advanced
- Counting with criteria from cellsAdvanced🔒 Advanced
- Adding up with a group and a limitAdvanced🔒 Advanced
- Adding up with criteria from cellsAdvanced🔒 Advanced
- Counting what ends in somethingAdvanced🔒 Advanced
- Adding up with a wildcardAdvanced🔒 Advanced
- Group against the averageAdvanced🔒 Advanced
- The share per groupExpert🔒 Expert
Decisions
- IF with two resultsBeginner🔒 Beginner
- IF with a calculationBeginner🔒 Beginner
- Catching errorsAdvanced🔒 Advanced
- More than two resultsAdvanced🔒 Advanced
- Combining conditionsAdvanced🔒 Advanced
- Comparing: TRUE or FALSEBeginner🔒 Beginner
- IF based on textBeginner🔒 Beginner
- IF inside an IFAdvanced🔒 Advanced
- Choosing from a list of valuesAdvanced🔒 Advanced
- Checking whether something is a numberAdvanced🔒 Advanced
- Catching empty cellsAdvanced🔒 Advanced
- Comparing with a limit in a cellBeginner🔒 Beginner
- Comparing with the averageBeginner🔒 Beginner
- IF with a limit in a cellBeginner🔒 Beginner
- IF with a calculation and fixed cellsBeginner🔒 Beginner
- Catching errors down a columnAdvanced🔒 Advanced
- An average without an error messageAdvanced🔒 Advanced
- Labels with limits in cellsAdvanced🔒 Advanced
- Several results with a calculationAdvanced🔒 Advanced
- AND with criteria from cellsAdvanced🔒 Advanced
- AND inside ORAdvanced🔒 Advanced
- Reversing a test with NOTAdvanced🔒 Advanced
- Predicting AND and ORAdvanced🔒 Advanced
- Catching an empty cell with ISBLANKAdvanced🔒 Advanced
- Spotting text where a number belongsAdvanced🔒 Advanced
- Catching only #N/A with IFNAAdvanced🔒 Advanced
- What ISERROR tells youAdvanced🔒 Advanced
Lookups
- Looking up a valueBeginner🔒 Beginner
- Looking up in bandsAdvanced🔒 Advanced
- Looking up to the leftAdvanced🔒 Advanced
- Name with the highest valueExpert🔒 Expert
- Looking up horizontallyAdvanced🔒 Advanced
- Looking up with your own messageAdvanced🔒 Advanced
- Finding the position in a listExpert🔒 Expert
- Looking up on another sheetBeginner🔒 Beginner
- Looking up without an errorBeginner🔒 Beginner
- Name with the lowest valueExpert🔒 Expert
- Calculating with a looked-up valueBeginner🔒 Beginner
- Discount from a band as an amountAdvanced🔒 Advanced
- Price after a discount from a bandAdvanced🔒 Advanced
- HLOOKUP without an error messageAdvanced🔒 Advanced
- HLOOKUP with MATCHExpert🔒 Expert
- Calculating with XLOOKUPAdvanced🔒 Advanced
- The name for the highest value with XLOOKUPAdvanced🔒 Advanced
- INDEX with MATCH twiceExpert🔒 Expert
- Approximate HLOOKUPAdvanced🔒 Advanced
- The group with the highest totalExpert🔒 Expert
- A total with a looked-up priceExpert🔒 Expert
- An order form without error messagesExpert🔒 Expert
Text
- Taking part of a textAdvanced🔒 Advanced
- Joining textBeginner🔒 Beginner
- Cleaning up textBeginner🔒 Beginner
- Replacing textExpert🔒 Expert
- Splitting text at a characterExpert🔒 Expert
- Taking characters from the endAdvanced🔒 Advanced
- Taking characters from the middleAdvanced🔒 Advanced
- Counting charactersAdvanced🔒 Advanced
- Capitals and lower caseBeginner🔒 Beginner
- Joining a listBeginner🔒 Beginner
- Replacing by positionExpert🔒 Expert
- Formatting numbers as textExpert🔒 Expert
- Formatting dates as textExpert🔒 Expert
- Turning text into a numberExpert🔒 Expert
- Making initialsBeginner🔒 Beginner
- Splitting first name and surnameExpert🔒 Expert
- Cleaning up a name completelyBeginner🔒 Beginner
- Only the first letter in capitalsBeginner🔒 Beginner
- Calculating with part of a codeAdvanced🔒 Advanced
- Building a new codeAdvanced🔒 Advanced
- Counting extra spacesAdvanced🔒 Advanced
- Counting wordsAdvanced🔒 Advanced
- Making a sentence with IFBeginner🔒 Beginner
- Taking everything after a characterExpert🔒 Expert
- The part between two charactersExpert🔒 Expert
- Deleting characters with SUBSTITUTEExpert🔒 Expert
- Turning text back into a numberExpert🔒 Expert
- The first name after a commaExpert🔒 Expert
- Swapping surname and first nameExpert🔒 Expert
- An amount in a sentenceExpert🔒 Expert
- A date in a sentenceExpert🔒 Expert
- A number from messy textExpert🔒 Expert
- Searching with case sensitivityExpert🔒 Expert
- Joining with CONCATBeginner🔒 Beginner
Numbers
- RoundingBeginner🔒 Beginner
- Always rounding upBeginner🔒 Beginner
- Finding the top 3Advanced🔒 Advanced
- Remainders and full unitsExpert🔒 Expert
- Always rounding downBeginner🔒 Beginner
- Rounding to a multipleExpert🔒 Expert
- The middle valueAdvanced🔒 Advanced
- The most common valueAdvanced🔒 Advanced
- Place in a rankingAdvanced🔒 Advanced
- Even or oddExpert🔒 Expert
- PowersBeginner🔒 Beginner
- Rounding a totalBeginner🔒 Beginner
- Calculate first, then roundBeginner🔒 Beginner
- Adding up the top 3Advanced🔒 Advanced
- Average against medianAdvanced🔒 Advanced
- How often the mode appearsAdvanced🔒 Advanced
- Rounding down to a multipleExpert🔒 Expert
- Paying for full boxesExpert🔒 Expert
- Minutes as hours and minutesExpert🔒 Expert
- A price with two ratesExpert🔒 Expert
- Rounding to tens and hundredsBeginner🔒 Beginner
- The second-lowest valueAdvanced🔒 Advanced
- A ranking with the lowest firstAdvanced🔒 Advanced
- Insight: LARGE with duplicate valuesAdvanced🔒 Advanced
- Insight: how MEDIAN worksAdvanced🔒 Advanced
- Rounding to the nearest 0.05Expert🔒 Expert
- Charging in 15-minute blocksExpert🔒 Expert
- Insight: up, down or nearestExpert🔒 Expert
- Insight: MOD and INTExpert🔒 Expert
- Even or odd with ISEVENExpert🔒 Expert
- PMT without interestExpert🔒 Expert
- The monthly payment on a loanExpert🔒 Expert
- The total interest on a loanExpert🔒 Expert
- How much you can borrow with PVExpert🔒 Expert
- Saving every month with FVExpert🔒 Expert
- How long it takes to pay off a loanExpert🔒 Expert
- Will you reach your savings goal in time?Expert🔒 Expert
- Letting an amount grow with FVExpert🔒 Expert
Dates
- Calculating with datesBeginner🔒 Beginner
- Year, month and day of the weekAdvanced🔒 Advanced
- Years between two datesExpert🔒 Expert
- Counting working days and monthsExpert🔒 Expert
- Putting a date togetherBeginner🔒 Beginner
- Last day of the monthExpert🔒 Expert
- Date after a number of working daysExpert🔒 Expert
- Days until a deadlineBeginner🔒 Beginner
- Adding up from a dateBeginner🔒 Beginner
- Full weeks between two datesBeginner🔒 Beginner
- On time or lateBeginner🔒 Beginner
- Building a date and calculating onBeginner🔒 Beginner
- The quarter of a dateAdvanced🔒 Advanced
- Weekend or weekdayAdvanced🔒 Advanced
- The week number of a dateAdvanced🔒 Advanced
- Whole months between two datesExpert🔒 Expert
- A duration in years and monthsExpert🔒 Expert
- Age as of todayExpert🔒 Expert
- Working days without days offExpert🔒 Expert
- Working days after the end of the monthExpert🔒 Expert
- The number of days with DAYSBeginner🔒 Beginner
- The day from a dateAdvanced🔒 Advanced
- The ISO week numberAdvanced🔒 Advanced
- TODAY or NOWBeginner🔒 Beginner
- Time worked between start and endExpert🔒 Expert
- Time worked without the breakExpert🔒 Expert
- The hour from a timeExpert🔒 Expert
- The minutes from a timeExpert🔒 Expert
- Which number Excel uses for a timeExpert🔒 Expert
- Hours worked as a numberExpert🔒 Expert
- Pay for the hours workedExpert🔒 Expert
- The total for a week, above 24 hoursExpert🔒 Expert
- Building a time with TIMEExpert🔒 Expert
- A night shift past midnightExpert🔒 Expert
- Overtime after eight hoursExpert🔒 Expert
Summaries
- SortingBeginner🔒 Beginner
- Sorting by two columnsBeginner🔒 Beginner
- Filtering by textBeginner🔒 Beginner
- Filtering by numbersBeginner🔒 Beginner
- Adding up visible rowsAdvanced🔒 Advanced
- Making the right chartBeginner🔒 Beginner
- Building a PivotTableBeginner🔒 Beginner
- Chart with two seriesAdvanced🔒 Advanced
- Taking PivotTables furtherExpert🔒 Expert
- Sorting by a text columnBeginner🔒 Beginner
- Filtering on two valuesBeginner🔒 Beginner
- An average of what's visibleAdvanced🔒 Advanced
- The share of the filtered rowsAdvanced🔒 Advanced
- Two series in a line chartAdvanced🔒 Advanced
- A PivotTable for a questionBeginner🔒 Beginner
- Locking the source of a drop-down listAdvanced🔒 Advanced
Excel 365
- A list without duplicatesExpert🔒 Expert
- Sorting with a formulaExpert🔒 Expert
- Filtering with a formulaExpert🔒 Expert
- Calculating row by rowExpert🔒 Expert
- Sorting a unique listExpert🔒 Expert
- Filtering by a number with a formulaExpert🔒 Expert
- SUMPRODUCT with a conditionExpert🔒 Expert
- Counting different valuesExpert🔒 Expert
- Sorting a whole list with a formulaExpert🔒 Expert
- A position from a sorted listExpert🔒 Expert
- FILTER with two conditionsExpert🔒 Expert
- Filtering and sorting in one formulaExpert🔒 Expert
- SUMPRODUCT with two conditionsExpert🔒 Expert
- Sorting by another columnExpert🔒 Expert
- Splitting text into columns with TEXTSPLITExpert🔒 Expert
- Splitting text into rows with TEXTSPLITExpert🔒 Expert
- Counting items with TEXTSPLITExpert🔒 Expert
- One part of a code with TEXTSPLITExpert🔒 Expert
- The position in a list with XMATCHExpert🔒 Expert
- The last position with XMATCHExpert🔒 Expert
- Looking up with INDEX and XMATCHExpert🔒 Expert
- The right discount with XMATCHExpert🔒 Expert
- Choosing columns with CHOOSECOLSExpert🔒 Expert
- The last column with CHOOSECOLSExpert🔒 Expert
- Choosing and sorting columnsExpert🔒 Expert
- Naming an intermediate result with LETExpert🔒 Expert
- The difference from the average with LETExpert🔒 Expert
- What LET calculatesExpert🔒 Expert
- Choosing rows with CHOOSEROWSExpert🔒 Expert
- A top three with SORT and TAKEExpert🔒 Expert
- The last rows with TAKEExpert🔒 Expert
- Dropping a column with DROPExpert🔒 Expert
Understanding
- Reading cell addressesBeginner🔒 Beginner
- Understanding rangesBeginner🔒 Beginner
- Predicting the order of operationsBeginner🔒 Beginner
- Which function counts what?Beginner🔒 Beginner
- What happens when you fill a formula?Beginner🔒 Beginner
- What does $ lock?Beginner🔒 Beginner
- Predicting the result of IFBeginner🔒 Beginner
- Predicting text functionsAdvanced🔒 Advanced
- Predicting roundingBeginner🔒 Beginner
- Understanding dates as numbersBeginner🔒 Beginner
- Understanding MATCHExpert🔒 Expert
- Which function does what?Beginner🔒 Beginner
- Conditional formattingAdvanced🔒 Advanced
- Drop-down listsAdvanced🔒 Advanced
- Recognising error messagesBeginner🔒 Beginner
- Keyboard shortcutsBeginner🔒 Beginner
Worksheets and formatting
- Calculating with a named rangeAdvanced🔒 Advanced
- A series with SEQUENCEAdvanced🔒 Advanced
- Random numbersAdvanced🔒 Advanced
- A table of random numbersAdvanced🔒 Advanced
- Workbooks, protection and enabling macrosExpert🔒 Expert
- What you need to know about macrosExpert🔒 Expert
- Understanding what-if analysisExpert🔒 Expert
- Custom formats and rules with $Expert🔒 Expert
- Using a table column in a formulaAdvanced🔒 Advanced
- Calculating with [@column]Advanced🔒 Advanced
- Calculating with a name in two functionsAdvanced🔒 Advanced
- A name inside IFAdvanced🔒 Advanced
- A block of numbers with SEQUENCEAdvanced🔒 Advanced
- SEQUENCE inside SUMAdvanced🔒 Advanced
- Counting in a table columnAdvanced🔒 Advanced
- A share with column namesAdvanced🔒 Advanced
- What RAND givesAdvanced🔒 Advanced
Frequently asked questions
Are the exercises really different every time?
Yes. Every exercise gets new data and a different situation, such as a bike shop or a class at school. That way you can't learn a solution off by heart. That's true on the free plan too.
How does the site know what I find difficult?
You mark it yourself. The site also takes into account your mistakes in exercises and lessons, and your result in the placement test.
How often does something come back?
What went wrong comes back the same day. What went well comes back later and later: after a day, three days, a week and three weeks. That way you remember it better with less practice.
Is this free?
On the free plan you practise ten basic questions each day, with new data every time. Unlimited practice, per skill and in a session tailored to your mistakes, comes with the modules: you practise the skills in your modules.