SheetTutor

SheetTutor organizes Excel by what you're trying to get done. Instead of browsing a list of functions, you pick a task like "Sum amounts that meet several conditions" or "Clean spaces and line breaks in imported text", and the lesson teaches whichever functions solve it. There are 90 tasks across categories such as Clean & compare, Find & reference, Dates & calendars, Loan cash flows and LAMBDA workflows, each labeled with a level such as Starter or Growing and an estimated time.

Each lesson runs in three tabs. Try the example shows the finished result. See the steps walks through the formula one piece at a time on a real worksheet, highlighting the part being explained, so in the SUMIFS lesson you watch the sum range go in before each condition is added. Your turn hands you the sheet to build it yourself. You can switch between sample datasets, reset the worksheet, and download the workbook to practice in Excel itself.

It suits beginners and people who use spreadsheets at work but only know a handful of functions. The task framing helps when you know the outcome you want and not the name of the function that does it. Beyond single lessons there are short courses, workshops, a shortcuts reference and a formula game linked from lessons.

Everything is free with no sign-up. The privacy page says example data and formulas are processed in your browser and that no feature uploads your worksheet inputs. Lesson progress, bookmarks and practice drafts stay in local storage on that device, so they won't follow you to another computer. It's an independent site, not affiliated with Microsoft, and it teaches Excel's formula language without needing Excel installed.