Tag: Excel Tutorials

Quick Excel Trick to Unstack Data from one Column to Multiple Columns

If you try to unstack data in excel from one column to multiple columns, you’ve probably noticed it’s not as easy as you might have thought. You might google it, and you’re going to find many different solutions to this. Starting from Vba to power query to control shift enter array formulas, index formulas, and…

Read MoreView 100 Comments

GUESS what’s HIDDEN in Excel? (Cool Trick)

What does Excel and this… (applausing) And now, here’s the star of Concentration! Have in common? What we’re going to do today is bring some fun to your team meetings or to your Excel lectures. But don’t thank me for all the fun. Thank Robert Palechek. He’s the one who sent me this idea. (typing)…

Read MoreView 100 Comments