What should we add next?

Thanks again for asking for this. Last time I said an English LAMBDA guide was worth doing, and it is now live: https://logicexcel.com/functions/lambda-function-excel It covers what LAMBDA is for, the test call in brackets that clears the #CALC! error almost everyone hits first, saving your function in the Name Manager so you can call it by name, and a worked example from start to finish. There is a short table of the errors and what each one usually means. One thing worth knowing before you try it: LAMBDA is in Microsoft 365 and Excel for the web only, so on Excel 2019 or 2021 it will not be there at all. There is still no marked LAMBDA exercise, so this card stays open and I will update it when we build one. In the meantime the logic inside most custom functions is ordinary Excel, and those you can practise today: https://logicexcel.com/practice/9 for IF and https://logicexcel.com/practice/64 for IFS.

¡Gracias por pedirlo! Todavía no hay un ejercicio de VBA, pero ya puedes empezar con la guía /es/tutorials/excel-vba-macros: enseña a mostrar la pestaña Programador, grabar tu primera macro sin escribir código, ejecutarla, leer el VBA que escribe Excel y escribir un Sub sencillo por tu cuenta. Los ejercicios de macros están en la lista, y actualizaré esta tarjeta cuando estén listos.

Thanks for asking for these. Until there is an exercise for them, you can already do the same job with FIND together with LEFT or MID: lesson 35 (/practice/35) teaches FIND, lesson 50 (/practice/50) teaches MID, and the guide at /functions/extract-first-word shows LEFT and FIND pulling out the text before a space. TEXTBEFORE and TEXTAFTER do that in one step, and they are on the list. I will update this card when the exercise is up.

Thanks for asking for this. There is no running total exercise yet, but two pages will get you there today. /functions/offset builds a running total step by step. And if your numbers are in a PivotTable, /tutorials/pivot-tables covers the Running Total In setting, which does it without a formula at all. The exercise we want to add is the everyday one, =SUM($B$2:B2) filled down the column. It is on the list, and I will update this card when it lands.

¡Gracias por pedirlo! Mientras tanto, tenemos una guía en /functions/lambda-function-excel que explica cómo crear tu propia función con LAMBDA, probarla en una celda, guardarla en el Administrador de nombres y corregir los errores #CALC! y #VALUE!. Por ahora la guía está en inglés. Todavía no hay un ejercicio práctico de LAMBDA y nos parece una muy buena idea. Queda en la lista y actualizaré esta tarjeta cuando esté listo. ¡Sigue enviando ideas!

Danke für deinen Wunsch, das ist eine schöne Idee! Zum Festigen kannst du heute schon jede abgeschlossene Lektion noch einmal durchgehen, dein Fortschritt bleibt dabei erhalten. Alle Aufgaben auf einen Blick findest du unter /practice/excel-exercises. Eine Funktion, die dir regelmäßig neue Aufgaben zum Wiederholen gibt, gibt es noch nicht. Sie steht jetzt auf unserer Liste, und ich schreibe hier, sobald sie da ist.

Danke für deinen Wunsch! Das Prozentformat kannst du schon heute üben: In Lektion 77 unter /practice/77 formatierst du Zahlen mit einer Tastenkombination als Prozent, gleich am Anfang der Lektion. Eine eigene Übung zum Rechnen mit Prozenten, also Anteile oder Veränderungen in Prozent, gibt es noch nicht. Sie steht auf unserer Liste, und ich schreibe hier, sobald sie da ist.

Thanks for asking for this, and for the vote! GROUP BY, HAVING and subqueries are the natural next step after our SQL lessons, so it is a good one to ask for. The closest thing on the site today is the four aggregate lessons: MIN and MAX at /sql/ps15, COUNT at /sql/ps16, AVG at /sql/ps19 and SUM at /sql/ps20. GROUP BY runs those same functions once for each group instead of once for the whole table, so they are the best warm up. There is no lesson on GROUP BY, HAVING or subqueries yet. It is on the list, and I will update this card when it lands.

Yes, and it is being worked on. We are building out deeper premium content at the moment, and downloadable resources are part of that: workbooks and printable exercise sets, rather than a flat PDF of the screens, which would lose the grid you actually type into. No date yet and I would rather not invent one. The 95 practice lessons stay free in the browser whatever happens to the downloads.

Thanks for asking! Good news, this one is already on the site. Our guide at /functions/text-functions shows how TEXT turns a number or a date into neatly formatted text, alongside LEFT, RIGHT, MID, LEN, TRIM, SUBSTITUTE, CONCAT and TEXTJOIN, each with examples you can copy. To practise hands on, lesson 13 covers LEN, LEFT and RIGHT, lesson 15 is CONCAT and lesson 18 is TEXTJOIN. Enjoy, and keep the ideas coming!

¡Gracias por pedirlo! Buena noticia: las tablas dinámicas ya están aquí. La lección 37 en /practice/37 te enseña paso a paso a crear tu primera tabla dinámica, y la lección 38 (/practice/38) te da más práctica. Las dos se hacen en tu propio Excel con un archivo que descargas en la misma lección. Si no tienes Excel, también funcionan gratis en Google Sheets o en Excel para la web. ¡Que las disfrutes!

Danke für deinen Wunsch! Gute Nachricht: Pivot-Tabellen gibt es schon. Lektion 37 unter /practice/37 zeigt dir Schritt für Schritt, wie du deine erste Pivot-Tabelle erstellst, und Lektion 38 (/practice/38) übt das weiter. Beide Lektionen machst du in deinem eigenen Excel mit einer Datei, die du direkt in der Lektion herunterladen kannst. Viel Spaß beim Ausprobieren!

Thanks for asking for this! The Excel Functions Guide at /functions does just that: each guide takes one function, like SUMIFS or VLOOKUP, and explains what it does, what each part of the formula means, and works through examples you can follow. Guides marked "Has practice" link to an exercise, so you can try the formula straight after reading about it. Have fun exploring!

Thanks for asking! Good news: all three are already here. SUMIFS is lesson 30 at /practice/30, pivot tables start at lesson 37 (/practice/37), and XLOOKUP is lesson 63 (/practice/63). Each one has more practice after it too: SUMIFS again in lesson 61, and a second pivot table lesson at 38. Enjoy!