How does Formulo check your formula?
Formulo calculates your formula on the exercise's data and then on other copies of the table that you don't see. If it's right on all of them, it's right. If you type the result by hand, or the formula only works for that data, it tells you and explains why.
- 01
You read the case
A table with data from a shop, a payroll or some grades, and a yellow cell where your formula goes.
- 02
You type the formula
Like in your Excel: IF or IFERROR, with commas. Enter, Tab, F4 and drag-down all work.
- 03
Formulo tests it
With your data and with other copies of the table. If it fails, it says which cell and why. If it's right, it explains why it works.
What Formulo says when something fails
1100You typed the result by hand in D2It would be right today, but it wouldn't update if the data changed. Type a formula.=BUSCARV(A2,Rates,3,FALSE)In English Excel, BUSCARV is called VLOOKUPWith a name from another language, English Excel shows #NAME?. Change it to VLOOKUP.=B2*C1When you dragged, the reference movedThe first row is fine, but in D3 the formula is =B3*C2. Lock C1 with $: select it in the formula and press F4.=VLOOKUP(A2,Rates,3)Right here, but it fails with other dataWithout FALSE, VLOOKUP does an approximate lookup and needs a sorted table. We tried it on an unsorted copy and it gave a different result. Add FALSE at the end.=VLOOKUP(A2,Rates,3,FALSE)CorrectAnd it works with other data too: we checked it on another copy of the table.
Real messages from the checker, as they appear in the exercise.
Who is Formulo for?
Formulo is for anyone who uses Excel and wants to practice with real formulas: before an Excel test in an interview, for a timed skills test or for everyday work.
You have an Excel test in an interview
What gets asked most: looking up with VLOOKUP, deciding with IF, summing with conditions using SUMIF and counting with COUNTIF.
Do the first exerciseYou're preparing for a timed Excel assessment
Mock exams of 10 exercises in 30 minutes, no hints and with a score. The questions are our own, not official.
See the mock examsYou use Excel at work
Matching two lists, summing sales by region, counting days between dates and cleaning imported text.
See the syllabusYou've never written a formula
Topic 1 starts with what a cell is and how to write SUM. Every exercise has hints and an explanation when you get it right.
Start with topic 1
What does Formulo include, and what doesn't it?
Formulo covers the formulas asked for most in tests and offices: from SUM to XLOOKUP, conditions, text and dates. It doesn't yet cover pivot tables, charts, Power Query or macros.
Includes
- First formulas12
- Absolute and mixed references13
- Decide with IF12
- VLOOKUP14
- Count and sum with conditions12
- Combined conditions12
- Look up data without VLOOKUP12
- Working with text12
- Dates and deadlines12
- Rounding and review10
- Timed, no-hints mock exams
- A guide to 19 functions
- A certificate for each topic, with a link to check it
- Keyboard shortcut practice
Doesn't include yet
- Pivot tables
- Charts
- Conditional formatting and data validation
- Power Query and macros (VBA)
For those, Microsoft's Excel help or a course will serve you better today. If you need them in Formulo, write to us: that's how we decide what comes next.
How is Formulo different from an Excel course?
A course explains Excel. Formulo makes you type the formula and checks it. Plenty of people use both: they learn a topic from an explanation and then practice it until it comes without looking.
| Formulo | Excel course | PDF exercises | |
|---|---|---|---|
| You type the formula yourself | Yes, in every exercise | Depends on the course | Yes, in your Excel |
| It checks it instantly | Yes, cell by cell | No | You look at the solution at the end |
| It tests the formula on other data | Yes | No | No |
| Explains long topics, like pivot tables | No, not yet | Yes | Sometimes |
| Needs Excel installed | No | To practice, yes | Yes |
| Works offline | No | Depends | Yes |
| Best for | Practicing and getting to a test with ease | Learning a new topic from someone teaching it | Practicing offline |
Comparing Formulo with a specific site? See the comparisons, with the same criteria for all of them.
How much does Formulo cost?
The first 3 exercises are free. After that there are two ways to pay for the same access: the monthly plan, at $7.99 a month, or the 3-month pass, at $14.99 in one payment that doesn't renew.
| Plan | Price | What it includes |
|---|---|---|
| Free | $0 | The first 3 exercises, the function guide and the shortcuts |
| Monthly | $7.99a month | The whole syllabus, the mock exams and the certificates. Cancel whenever you want |
| 3 months | $14.99one payment | The same for 90 days. Doesn't renew by itself |
Every detail, point by point, on pricing.
Who writes the Formulo exercises?
Excel experts write the Formulo exercises so you practice with real cases: the tables and tasks asked for at work, in a selection test and in timed assessments. Each one has hints and an explanation when you get it right. The examples in the function guide are checked in Excel. If you find a mistake, write to us and we'll fix it.
What else is on Formulo?
These are the main pages of getformulo.com, in case you want to go straight to something.
- Free Excel exercisesThe first 3, with no account and no card.
- All exercises121 exercises in 10 topics.
- Excel mock exam10 exercises in 30 minutes, no hints.
- Excel functionsSyntax, examples and the Spanish name.
- Excel shortcutsThe shortcuts of your Excel, in a real sheet.
- PricingWhat each plan includes.
- ComparisonsFormulo next to other sites for learning Excel.
- BlogGuides and short answers about Excel.
- ContactA person answers, not a bot.
Frequently asked questions about Formulo
- Is Formulo free?
- The first 3 exercises are, with no account and no card: they're in free Excel exercises. The rest of the syllabus, the mock exams and the certificates come with a plan.
- Are Formulo and getformulo.com the same thing?
- Yes. Formulo is the name and getformulo.com is its web address.
- Do I need Excel installed to use Formulo?
- No. Formulo is a spreadsheet that runs in your browser, including on your work laptop. The formulas you practice are typed the same way in your Excel.
- Does Formulo help with the Excel test in a job interview?
- Yes. The exercises train what selection tests usually ask: VLOOKUP, IF, SUMIF and references with $. The mock exams add the clock and remove the hints.
- Does Formulo have timed mock exams?
- Yes. Each mock exam has 10 exercises in 30 minutes, no hints and a score at the end. The questions are our own, not an employer's.
- What if my Excel uses semicolons instead of commas?
- Formulo checks the formula either way. You choose the separator of your Excel in the sheet's status bar and, if you use the other one, it warns you that it would give an error in your Excel.
- Can I type the functions in Spanish?
- Formulo's English site uses English Excel names. If you type BUSCARV, it tells you that in English Excel it's called VLOOKUP. Every function in the function guide also carries its Spanish name.
- Is the Formulo certificate official?
- No. It's a Formulo certificate, one for each topic you finish, with its own link so anyone can check it's yours. It doesn't replace an official degree.
- Is it Formulo or Fórmulo?
- Formulo, with no accent and a capital F.
Not here? Write to us and a person will answer.