¿Qué deberíamos agregar después?

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.

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! 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.

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.

Good news, this one is already here. COUNTIFS is lesson 27: /practice/27. Ten screens on a real grid, starting with two conditions and working up to criteria like ">1". If you would rather build up to it, COUNTIF with a single condition is lesson 26, and lesson 56 is a longer practice run once it clicks. Sorry you had to ask for something we already had. That one is on us.

Fixed and live. You were right, and it turned out to be two bugs rather than one. The lesson now reopens on the question you stopped at, with a note saying so and a Start over button if you would rather take it from the top. The second one was worse and we would not have found it without your report. XP was only ever recorded for the FIRST question of a lesson if you answered everything correctly. A perfect run of a ten-question lesson paid 10 XP instead of 100, and getting an answer wrong was the only thing that unstuck it. That is also why reopening dropped you at the beginning: the site only ever remembered question one. Both are fixed. Try it here: /practice/1

There you go /courses

All attachments are now working, hope it helps.

Construido y en vivo. Abre /leaderboard y cambia a la pestana Amigos: ahi esta tu enlace de invitacion. Quien lo abra entra en tu lista y tu en la suya, sin solicitudes ni esperas. La tabla muestra solo a ustedes, ordenada por XP, con la racha de cada uno. Tus amigos ven exactamente lo que la tabla publica ya muestra de ti: nombre, XP y racha. Nada mas. Puedes quitar a alguien cuando quieras, y desapareces tambien de su lista. Gracias por pedirlo: era la idea abierta mas votada y por eso se construyo primero.