-
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…
-
Excel Tutorials – LAMBDA
Read More: Excel Tutorials – LAMBDAWhat Even IS LAMBDA? Alright, picture this. You’ve got this formula you use all the time. Maybe it calculates a letter grade from a percentage. Maybe it pulls the first name out of a full name. You copy it from cell to cell, sheet to sheet, and every time you tweak one little thing you…
-
Excel Tutorials – TEXTSPLIT
Read More: Excel Tutorials – TEXTSPLITWhat Is TEXTSPLIT? The TEXTSPLIT function (available in Excel 365 and Excel 2021) splits a text string into multiple columns and/or rows based on specified delimiters. It simplifies tasks that previously required complex formulas using LEFT, RIGHT, MID, FIND, or the Text to Columns wizard. Syntax =TEXTSPLIT(text, [col_delimiter], [row_delimiter], [ignore_empty], [match_mode], [pad_with]) text — The…
-
Excel Functions You’ve Never Heard of – Least Popular Excel Functions
Read More: Excel Functions You’ve Never Heard of – Least Popular Excel FunctionsAs a popular spreadsheet software, Microsoft Excel has a wide range of functions that can help users perform various tasks and calculations. While some functions like SUM and AVERAGE are widely used on a daily basis, there are many other functions that are not as commonly used. In this blog post, we will take a…
