Intro to LAMBDA - Lesson 16 - Simple Corkscrew
I could use your help.
I am preparing a virtual work session for FMI on "Intro to LAMBDA." I decided to try something new, or at least, new to me: an interactive workbook that takes a student from basic to intermediate LAMBDAs and I wonder if this is a good path to take.
The workbook currently has 19 interactive worksheets that explain a LAMBDA or a dynamic array function and then challenges the learner to complete a small assignment that implements that function. It is perhaps easier to understand visually. Here is a video of lesson 16 that creates a simple corkscrew function.
You may have noticed that the lesson listed several prerequisites. This is, after all, the 16th lesson. Prior lessons helped prepare a beginner how to use functions like SCAN() and DROP() before getting to this point. So keeping in mind that this particular lesson is bit more advanced than beginner...
Does this look like a good way to learn LAMBDA?
In the video, where we see lines being typed, that would be where the learner makes entries. The prompts on the left side offer assistance when incorrect entries are made or when required items are omitted. Start a line with an = where we shouldn't? The prompt tells us not to. Forget an argument? The prompt tells us to add it. Leave a comma off the end of a LET() step? The prompt reminds us it is required. A lot of work went into crafting prompts that anticipate what could go wrong and adapting to different ways students may type their answers. They are there to be me, when I can't be there to help the student.
Would this work for you? Please let me know in the comments below. Thanks, and keep XL'n my friends.
Founder at Taglo | Creating Better Financial Models | Strategy Consultant
2wHi Craig. Bit of late feedback. I've just watched your FMI video, which is great. In the downloadable workbook, the solution checks are reliant on the REGEXTEST function which I think is only available on Excel's Beta Channel, so unfortunately the formula doesn't work for users on Excel's Current Channel (like me). Hopefully it gets moved out of Beta soon, but you might need a workaround until then! Otherwise a fantastic resource 👏
Passionate Figma Designer | Expert in Web & Mobile UI/UX, Crafting Engaging, Results-Driven Designs
3wlooks great Craig!
Founder | Business & Commercial Advisor | Quantum Commerce Innovator | Ego-less Leadership Advocate |
3wLooking forward to this!
Technical Fellow at NAFEMS
4wHi Craig The presentation is polished and the content is good. Sometimes I think it would be easier to teach the new if old tricks could be erased first! Where there may be problems arising from the pace at which the presentation cracks on. In use, breaks are required to ensure that the user can assimilate the set tasks and reflect upon what they achieve. As Diarmuid says, the spokesperson is somewhat spooky, but the messaging is clear.
Finance | Modelling | Know the number | Craft the story
4wI've been looking for ways to advance my LAMBDA skills and I think this would be a good approach that is step by step. I think it reinforces what each of the individual functions do. Quick question, I couldn't help but notice the circular references notification. I presume this has nothing to do with this particular LAMBDA example?