learning
Power Query tutorial: build your first refreshable report
The single highest-return thing an Excel user can learn — replacing a four-hour monthly cleanup with a refresh button, step by step from a raw export.
Updated
All tutorials
learning
SQL joins explained with row counts and common mistakes
Joins taught through what happens to your row count, which is how you actually catch a wrong result — plus the two mistakes that silently corrupt totals.
Updated
How to actually learn from a tutorial
Reading a tutorial and following a tutorial produce very different results, and the difference shows up the first time you try to build something nobody has written a walkthrough for.
Type it, do not copy it
Copying a code block gets you a working result and almost no retention. Typing it out means meeting every syntax error yourself, and those errors are most of the learning — a missing colon or a wrong indent teaches you something a correct paste never does.
Break it deliberately
When a tutorial works, change something and predict what will happen before you run it. Rename a variable. Remove a filter. Feed it a value it does not expect. If the result surprises you, that gap is the thing worth understanding, and it is invisible while everything works.
Rebuild it from nothing a day later
This is the step almost everyone skips and the one that decides whether the knowledge survives. Close the tutorial and build the same thing from memory. What you cannot reproduce is what you did not learn, and finding that out the next day is far cheaper than finding it out in an interview.
Then change the problem
A tutorial teaches a technique using somebody else's example. Apply it to your own data or your own question, and the technique becomes yours. Every tutorial here is written with that step in mind, which is why each one ends with something running rather than something read.
Tutorials teach a technique. A course teaches the order techniques go in, and why one is chosen over another — which is a different thing and the reason self-taught learners often have gaps in surprising places. If a tutorial here interests you, the course it belongs to is linked at the bottom of it.
Next step
Talk to a course advisor
Tell us what you want to learn and we will help you pick the right course, batch and mode.