Practisheet

Practicar

¿Eres nuevo?

Arma tu plan en 60 segundos y empieza tu primer ejercicio.

Empieza gratis →

Proyectos

Lecciones

Sheet basics

Cells, rows and cell addresses

0 de 3 hechos

Simple formulas

+ − × ÷, cell references, copying a formula down

0 de 9 hechos

SUM, AVERAGE, COUNT, MIN and MAX

Plan completo

Totals, averages, counts, the biggest and smallest value

0 de 7 hechos

Percentages and fixed references

Plan completo

% of total, % change, $ references, ROUND, ROUNDUP, IFERROR

0 de 7 hechos

IF, AND, OR, IFS

Plan completo

Yes/no checks, nested IF, IFS and SWITCH

0 de 8 hechos

COUNTIF and SUMIF

Plan completo

COUNTIF(S), SUMIF(S), AVERAGEIFS, MAXIFS, MINIFS

0 de 11 hechos

Lookups

Plan completo

XLOOKUP, VLOOKUP, INDEX + MATCH, IFNA, not-found values

0 de 8 hechos

Text extraction

Plan completo

LEN, LEFT, RIGHT, MID, FIND, SEARCH

0 de 7 hechos

Joining text

Plan completo

&, CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, SUBSTITUTE

0 de 6 hechos

Data cleaning

Plan completo

TRIM, CLEAN, VALUE, TEXT, IS functions, text dates

0 de 9 hechos

Dates

Plan completo

DATE, YEAR, MONTH, WEEKDAY, EOMONTH, date maths

0 de 7 hechos

Workdays and date gaps

Plan completo

EDATE, DAYS, DATEDIF, NETWORKDAYS, WORKDAY

0 de 6 hechos

Statistics and ranking

Plan completo

MEDIAN, LARGE, SMALL, RANK, PERCENTILE, QUARTILE, STDEV

0 de 8 hechos

Summary tables

Plan completo

Pivot-style tables with SUMIFS and COUNTIFS grids

0 de 10 hechos

Lookups II

Plan completo

Bands, two-way INDEX/MATCH, combined keys, CHOOSE

0 de 7 hechos

SUMPRODUCT and conditions

Plan completo

Weighted averages and multi-condition maths

0 de 6 hechos

Broken sheets

Plan completo

Fix #N/A, #VALUE!, #DIV/0!, #REF! and rule columns

0 de 7 hechos

Finance and what-if

Plan completo

PMT, FV, PV, NPER, NPV, IRR, scenarios

0 de 8 hechos

Dynamic arrays

Plan completo

FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, TAKE

0 de 10 hechos

Summary tables II

Plan completo

Summaries that grow with UNIQUE and E2# references

0 de 6 hechos

LET

Plan completo

Name the steps of a long formula

0 de 4 hechos