WebHerramientas

Excel Practice

Learn Excel with 55 interactive exercises, an exam and a daily challenge, in English or Spanish: IF, VLOOKUP, FILTER, dates and more

Your first formula

Every formula starts with =. Instead of typing numbers, use references like B2: the letter is the column and the number is the row. When B2 changes, the result updates by itself. The operators are + - * / and ^ for powers.

Example=B2*C2

In D2, calculate the row total: price times quantity. Your formula will be copied down to D6, so use references, not numbers.

D2
ABCDE
1ProductPriceQuantityTotal
2Notebook354
3Pen1210
4Backpack4501
5Calculator2802
6Marker186
7

Tip: while typing, click a cell or drag across several to insert their reference.

Share this tool

If it helped, send it to someone who needs it too.

Keep going with

More in Business

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Advertising
Loading ad...

Ads help us keep WebHerramientas free for everyone

Free Online Excel Practice

Learn Excel by solving exercises in a spreadsheet inside your browser. Each lesson explains one idea, asks for a formula and checks it instantly. You can type function names in English or Spanish, with comma or semicolon separators, and every correct answer shows the same formula in the other language.

Why use Excel Practice

  • English or Spanish function names: SUM or SUMA, COUNT or CONTAR
  • Comma or semicolon argument separators
  • Explains mistakes: short ranges, misspelled functions or typed-in numbers
  • 55 lessons in 11 modules: from your first formula to XLOOKUP, DATEDIF and dynamic arrays (UNIQUE, FILTER, SORT)
  • A timed 10-question exam with a shareable result
  • Daily challenge with fresh data and a day streak
  • Progress saved in your browser, no account

How to use it in 3 steps

  1. 1

    Pick your Excel language

    Choose English Excel or Spanish Excel with a comma or semicolon separator.

  2. 2

    Read the lesson and task

    Each lesson explains a function with an example and tells you which cell to fill in.

  3. 3

    Type the formula

    Start with = and type in the formula bar. Click or drag across cells to insert references and ranges.

  4. 4

    Check and move on

    Press Check or Enter. If something is off you will see what to fix; if it is right, move to the next lesson.

Questions about Excel Practice

Why do some Excel formulas use ; instead of ,?

It depends on regional settings. Where the comma is the decimal mark, such as Spain or much of South America, Excel separates arguments with semicolons: =SUMA(A1;B1). English Excel and Mexican Spanish Excel use commas. This tool accepts both.

What are Excel functions called in Spanish?

Many are renamed: SUM is SUMA, AVERAGE is PROMEDIO, COUNT is CONTAR, COUNTA is CONTARA, IF is SI and VLOOKUP is BUSCARV. MIN and MAX keep their names. Each solved exercise shows your formula translated.

How does it check my formula?

It calculates your formula on the sheet and compares it with the expected result, then recalculates with different data, so a formula with typed-in numbers fails even if it matched once. Any correct approach works: =C2*B2 is as good as =B2*C2.

What is the daily challenge?

Every day a new sales table is generated with three questions, the same for everyone. Solving it adds a day to your streak; skip a day and the streak starts over. It is saved only in this browser.

Do I need Excel installed?

No. The sheet runs in your browser and evaluates formulas with its own Excel-like engine. Progress is saved only in this browser.

Is Excel Practice free?

Yes, Excel Practice from WebHerramientas is 100% free. No registration or subscription required. You can use it as many times as you need at no cost.

Is it safe to use Excel Practice online?

Yes, all information is processed directly in your browser. We do not store or send your data to any external server.

Does Excel Practice work on mobile?

Yes, the tool is fully responsive and works on any device: phone, tablet or computer with a modern browser.