Practicar
¿Eres nuevo?
Arma tu plan en 60 segundos y empieza tu primer ejercicio.
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 completoTotals, 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 completoYes/no checks, nested IF, IFS and SWITCH
0 de 8 hechos
COUNTIF and SUMIF
Plan completoCOUNTIF(S), SUMIF(S), AVERAGEIFS, MAXIFS, MINIFS
0 de 11 hechos
Lookups
Plan completoXLOOKUP, VLOOKUP, INDEX + MATCH, IFNA, not-found values
0 de 8 hechos
Text extraction
Plan completoLEN, 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 completoTRIM, CLEAN, VALUE, TEXT, IS functions, text dates
0 de 9 hechos
Dates
Plan completoDATE, YEAR, MONTH, WEEKDAY, EOMONTH, date maths
0 de 7 hechos
Workdays and date gaps
Plan completoEDATE, DAYS, DATEDIF, NETWORKDAYS, WORKDAY
0 de 6 hechos
Statistics and ranking
Plan completoMEDIAN, LARGE, SMALL, RANK, PERCENTILE, QUARTILE, STDEV
0 de 8 hechos
Summary tables
Plan completoPivot-style tables with SUMIFS and COUNTIFS grids
0 de 10 hechos
Lookups II
Plan completoBands, two-way INDEX/MATCH, combined keys, CHOOSE
0 de 7 hechos
SUMPRODUCT and conditions
Plan completoWeighted averages and multi-condition maths
0 de 6 hechos
Broken sheets
Plan completoFix #N/A, #VALUE!, #DIV/0!, #REF! and rule columns
0 de 7 hechos
Finance and what-if
Plan completoPMT, FV, PV, NPER, NPV, IRR, scenarios
0 de 8 hechos
Dynamic arrays
Plan completoFILTER, SORT, SORTBY, UNIQUE, SEQUENCE, TAKE
0 de 10 hechos
Summary tables II
Plan completoSummaries that grow with UNIQUE and E2# references
0 de 6 hechos
LET
Plan completoName the steps of a long formula
0 de 4 hechos