Tagged “tutorial”
2 entries.
Writing
Window functions, explained without the jargon
Running totals, rankings and "compare each row to its group" — all without a self join.
#sql #tutorial
VLOOKUP, INDEX/MATCH, XLOOKUP — which to actually use
Three ways to do the same job, twenty years apart. Only one is worth learning today.
#excel #tutorial