Syntax and arguments
See the function’s exact syntax, which arguments are required, and what each input controls.
Inside the app
A complete learning loop: understand the formula, see it in a worksheet, practise it, and know what to review next.
Learn
Each of the 228 formula lessons is structured for quick understanding and practical recall.
See the function’s exact syntax, which arguments are required, and what each input controls.
Formulas appear in small, readable sheets so you can connect the expression to its result.
Practical guidance, common mistakes, tips, and related functions help you choose the right tool.
Browse ten formula families, search the full library, save favourites, and pick up where you stopped.
Practice
Eight question styles help you recognise, build, troubleshoot, and apply formulas in different ways.
Read the worksheet goal and identify the function that fits.
Place the right tokens and arguments into a partially finished formula.
Spot the incorrect expression, diagnose the mistake, and learn the correction.
Predict outputs, match formulas to results, select the correct arguments, and fill the missing worksheet cell.
Return to mistakes, drill favourites, focus on a category, or take a ten-question mixed set.
Progress
Progress turns each session into a clear next step.
Keep a light routine with one daily challenge and an optional local reminder.
Track exercises, accuracy, formulas mastered, best category, and study time.
See your active days and question volume without needing an account or cloud profile.
Celebrate concrete achievements while category progress shows where to focus next.
Private and calm
The complete formula catalogue and question set live on your device. The app does not collect or transmit personal data.
Excel Formula Trainer supports Android 7.0 and newer.