Free Excel tools and calculators
Solve real Excel problems. Get the right formula, understand why it works, then practise it on realistic data.
- Quick and easyGet results instantly
- Learn as you goStep-by-step explanations
- Practise nextLinks to relevant exercises
- Copy and useStraight into your own sheet
Excel tools
Each one produces a formula you can paste straight into a sheet, explains what it does, and points at the exercise that drills it.
XLOOKUP Formula GeneratorGenerate XLOOKUP formulas with ease.IF Formula GeneratorCreate IF, IFS and nested IF formulas.SUMIFS Formula GeneratorBuild SUMIFS formulas for multiple criteria.Percentage CalculatorCalculate increase, decrease and difference.Date Formula GeneratorGenerate formulas for dates, age and workdays.
More tools are on the way — IF, SUMIFS, percentage and date generators are next.
A formula is the start, not the finish
Copying a formula solves today’s problem. Being able to write it from memory, on data you have not seen before, is what an interview tests. Every tool here ends at an exercise for that reason — 84 of them, free, with the diagnosis a generator cannot give you.