Tag: Excel 2016

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

Intermediate Excel Skills, Tips, and Tricks Tutorial

In this video tutorial we’re going to take a look at the intermediate Skills tips and tricks that you need to know in order to use excel Properly and efficiently if you haven’t already watched my other excel video. It’s called the Beginner’s guide to Excel and I highly recommend that you start with that…

Read MoreView 100 Comments

Top 25 Excel 2016 Tips and Tricks

After years of using Excel in a corporate environment here are my top 25 Excel 2016 tips and tricks. Welcome to Sele training. I’m about to show you some useful tips and tricks for Excel 2016. They’re in no particular order so be sure to watch all the way through to the end of the…

Read MoreComment

Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total

Read MoreView 8 Comments

Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop

Welcome to Excel magic trick number 1,443. Hey, if you want to download this Excel workbook, either the start file or finished file so you could follow along, click on the link below the video. Hey, we’ve got to see how to create a DAX formula for calculating sales per working day. And of course,…

Read MoreView 22 Comments

Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years

Welcome to Excel Magic Trick number 1,449. Hey, if you want to download this Excel file so you can follow along, click on the link below the video. Hey, we got to see how to create a DAX measure for percentage change, both for month over month and year over year when we have incomplete…

Read MoreView 33 Comments

Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions

Read MoreView 11 Comments