The Round menu option in Power Query does not round the same way that Excel rounds. This is a shorter video covering the same information that Excel MVP Celia Alves covered in episode 2391. In order to have Power Query Continue reading “How to ROUND in Power Query To Match Excel – 2396”
Author: Bb
Tom Hanks From A Lambda And Let Function In Excel – 2397
Here is a cool example of a LAMBDA function with a LET and XMATCH function. Point to two cells that contain movie names and the function will find the cast who is in common between the two movies and provides Continue reading “Tom Hanks From A Lambda And Let Function In Excel – 2397”
How To Run A Scheduled Flow In Power Automate
Our new Power Automate Masterclass course, will jump start your learning journey on Microsoft’s Power Automate. This course is developed and taught by Enterprise DNA Expert, Henry Habib, wherein you can discover how to add powerful workflow automation directly in Continue reading “How To Run A Scheduled Flow In Power Automate”
How We Built A Dynamic Learning Map Recommendation Application In Power BI
For today’s video. I’m going to share something that we’ve been doing internally over at Enterprise DNA. I’d like to mainly showcase a couple of things – how amazing Power BI is to build world-class, dynamic and customizable applications, as Continue reading “How We Built A Dynamic Learning Map Recommendation Application In Power BI”
How To Create Flows From Scratch Using Power Automate
Our new Power Automate Masterclass course, will jump start your learning journey on Microsoft’s Power Automate. This course is developed and taught by Enterprise DNA Expert, Henry Habib, wherein you can discover how to add powerful workflow automation directly in Continue reading “How To Create Flows From Scratch Using Power Automate”
How To Fix Matrix Totals In Power BI
For this tutorial, I’m going to show how you can fix matrix totals in Power BI, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. I want to tackle this problem as it Continue reading “How To Fix Matrix Totals In Power BI”
INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.
Download Excel File: https://excelisfun.net/files/EMT1712.xlsx
Learn how create a re-usable function to append tables with an Excel Formula. This tgrick comes from Excel Online Teammate cr gr0912.
Topics:
1. (00:00) Introduction.
2. (00:30) New excelisfun introduction from Geert, the Exceleer.
3. (00:51) Online Continue reading “INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.”
Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021.
Nick Roth, and Magic get rad at Green Lake Lower Woodland Skatepark Seattle, January 3, 2021 in the pouring rain.
Rain does not stop the rad action!
Not Big Air. No Big Tricks. Just getting rad with BMX in the rain on Continue reading “Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021.”
Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713
Download Excel File: https://excelisfun.net/files/EMT1713.xlsx
Learn how append tables that contain a small amount of data using the following functions: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. Learn a great trick in the row_num argument of INDEX function to unwind Continue reading “Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713”
Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.
Download Excel Files: https://excelisfun.net/files/EMT1714.xlsx
https://excelisfun.net/files/EMT1714Answer.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrent.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrentAnswer.xlsx
https://excelisfun.net/files/EMT1714GradeTables.zip
3 methods to append / Combine Tables in Excel Power Query: 1) Power Query Append Feature, 2) Excel.CurrentWorkbook function to combine all Continue reading “Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.”
Bob Umlas Interpolate Using Fill Series in Excel – 2398
Bob Umlas has a new book out. https://www.mrexcel.com/products/cool-excel-shit/ While I was working on indexing and layout of the book, I learned a lot of new Excel techniques, including this cool way to interpolate values.
If you enter Continue reading “Bob Umlas Interpolate Using Fill Series in Excel – 2398”
Excel Power Query Adds Support For Dynamic Arrays – 2400
We noticed it first on April 20, 2021… the Get & Transform Data group’s “From Table/Range” changed to “From Sheet”. Hover over the tooltip, and you will discover that they now support arrays!
This is great news. Power Query is the Continue reading “Excel Power Query Adds Support For Dynamic Arrays – 2400”