-
Excel Tutorials – HSTACK
Read More: Excel Tutorials – HSTACKExcel HSTACK Stop squinting at columns. Start stacking stuff sideways. So What the Heck Is HSTACK? Okay, imagine you’ve got two lists. Maybe one is first names, the other is last names. You want them side by side — like a proper table. Normally you’d copy-paste, or use some janky INDEX/MATCH. But HSTACK is like…
-
Excel Tutorials – VSTACK
Read More: Excel Tutorials – VSTACKExcel VSTACK Stack ’em up, stack ’em down — combine ranges vertically like a pro. So What Is VSTACK, Anyway? Okay, picture this: you’ve got two (or three, or twelve) lists of data. Maybe it’s sales from Q1 in one sheet and Q2 in another. Or names from your morning class and names from your…
-
Excel Tutorials – TEXTBEFORE
Read More: Excel Tutorials – TEXTBEFOREExcel TEXTBEFORE Grab everything before a comma, a space, or any delimiter — without the headache. Wait, What Does TEXTBEFORE Even Do? Okay, picture this: you’ve got a list of full names like “Smith, John” and you just want “Smith”. Or maybe you have email addresses like “jdoe@company.com” and you need the username before the…
-
Excel Tutorials – TEXTAFTER
Read More: Excel Tutorials – TEXTAFTERExcel TEXTAFTER Stop wrestling with text. Start grabbing exactly what you need. What Even IS TEXTAFTER? Alright, picture this. You’ve got a column of emails like “john.doe@company.com” and you just want the domain part. Or you have product codes like “ABC-123-XYZ” and you need the bit after the second dash. Before TEXTAFTER, you’d use a…
-
Excel Tutorials – MAP
Read More: Excel Tutorials – MAPExcel MAP Turn a whole list into a new list — without dragging formulas down 500 rows. So What’s MAP, Anyway? Okay, imagine you have a list of numbers — test scores, prices, whatever. And you want to do the SAME thing to every single item. Like, add 10 points to each score, or double…
-
Excel Tutorials – SCAN
Read More: Excel Tutorials – SCANExcel SCAN Running totals, compound stuff, and that one weird trick with arrays. So What’s SCAN, Anyway? Okay, imagine you have a list of numbers. You want to add them up, but you don’t just want the final total — you want to see the running total after every step. Like, “after the first number,…
-
Excel Tutorials – LET
Read More: Excel Tutorials – LETExcel LET Stop repeating yourself. Start naming your intermediate calculations. What Even IS LET? Alright, picture this. You’ve got this formula. It calculates something. And in the middle of it, you need the same sub-calculation three different times. Like, you’re calculating a discount, and you need “price * quantity” for the subtotal, then again for…
