Tag: Excel

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

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

Function Wizard

In this section you’ll learn how to activate the FUNCTION WIZARD, use the FUNCTION WIZARD to find Excel’s inbuilt functions, and how they can help you. You can avoid having to remember the complex syntax for each function, and to find out more about functions you come across in spreadsheets. FUNCTION WIZARD is Excel’s ways…

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 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report

Read MoreView 11 Comments

Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables

Welcome to Excel Magic Trick number 1,407. Hey, if you want to download this Excel workbook Excel Magic Trick 1,407 finished file or the start file so you can follow along, click on the link below the video. Hey, back in Excel Magic Trick 1,405, we saw how to create a monthly revenue and add…

Read MoreView 11 Comments

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

Welcome to Excel Magic Trick number 1394. If you want to download this Excel workbook, Excel Magic Trick 1393-94 so you could follow along, click on the link below the video. Wow, we have a crazy video here. We’ve got to calculate formulas for traditional pivot table calculations, such as percentage of column total, percent…

Read MoreView 14 Comments

Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns

Welcome to Excel Magic Trick number 1,420. Hey, if you want to download this Excel workbook, the start file or the finished file so you can follow along, click on the link below the video. Ranking in Power Query? Is it possible? Well, I actually searched all over to try to find a ranking function…

Read MoreView 17 Comments

Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer

Welcome to Excel Magic Trick number 1418. Hey, if you want to download this Excel workbook so you could follow along, click on the link below the video. Hey, last video, we saw how to rank for unit profit and total profit, either for products or products within manufacturer. But in the last video, we…

Read MoreView 15 Comments

Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)

Welcome to Excel magic trick number 1,408. Hey, if you want to download this Excel workbook, Excel magic 1,408 start file or the finished file, so you can follow along, click on the link below the video. Hey, back at Excel magic trick 1,406, we were trying to calculate a moving 12 month average. Here’s…

Read MoreView 20 Comments