Tag: Advanced Excel tricks

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

Another 15 Excel 2016 Tips and Tricks

Here’s another 15 Excel 2016 Tips & Tricks. This is a compliation of 15 additional Excel 2016 tips and tricks that didn’t make it in my previous Top 25 Excel tips and tricks video. If you haven’t seen it, you’ll want to click the link listed at the end of this video, in the description…

Read MoreView 100 Comments

SURPRISING Advanced Filter TRICK in Excel (You’ve Never Heard Of!)

Today’s video is about a hidden feature in Excel’s advanced filter that I never knew about. I found out about this last week. It came packaged nicely as an email and video from Bryon. Now I know Bryon quite well, so when I read this sentence… (light upbeat music) I knew there’s something good in…

Read MoreView 100 Comments

Top 15 Advanced Excel 2016 Tips and Tricks

This is the top 15 advanced Excel 2016 tips and tricks. As a follow up from the top 25 Excel 2016 tips and tricks video, here’s some additional advanced features. If you missed the original top 25, follow the link at the end of this video and be sure to check out my tips and…

Read MoreView 4 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