Your VLOOKUP isn’t working or the Sync Slicers isn’t working. You look at the data and it *looks* the same, but it is not really the same. This video shows how to use MID and CODE to find out why Continue reading “Why Don’t These Cells Match In Excel – 2384”
Category: Excel

Intro To Power Apps Masterclass
Our new course, Power Apps Masterclass, will jump start your learning journey on Microsoft’s Power Apps. This course is developed and taught by Enterprise DNA Expert, Henry Habib. Get a step-by-step guide that will help you create, share, and deploy applications Continue reading “Intro To Power Apps Masterclass”

Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)
You might be wondering, didn’t we create a Perpetual Holiday Calendar already? And the answer is, yes we sure did! That was eDNA’s maiden POTW DAX Challenge and now we get to do it all over again using only Power Query/M Continue reading “Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)”

Power Apps & Power Automate Masterclass Course Rollout
We have a couple of new course modules this month that will jump start your learning journey on Microsoft’s Power Apps and Power Automate. Join Sam and Brian as they introduce these 2 pioneer courses developed and taught by Enterprise Continue reading “Power Apps & Power Automate Masterclass Course Rollout”

Using Charticulator To Conditionally Highlight Bar Chart
In this video, I’ll share the solution I came up with for creating the highlighted Max Value and bringing in this measure into the Charticulator. This is a problem encountered by an Enterprise DNA member who was going through the Bar Continue reading “Using Charticulator To Conditionally Highlight Bar Chart”

IF Based On Word Count in Excel – 2388
Nas T has to convert sport names to a 4-letter abbreviation. If the sport name has one word, then use the left four characters. But, if the sport name has two words, use the left 3 letters from the first Continue reading “IF Based On Word Count in Excel – 2388”

Power Query Defaults To Bankers Rounding Featuring Celia Alves – 2392
A very detailed discussion today about how Excel rounds. We were all taught in school that 8.4 rounds to 8 and 8.5 rounds to 9. But not in Power Query.
Without letting you know, Power Query defaults to a rounding mode Continue reading “Power Query Defaults To Bankers Rounding Featuring Celia Alves – 2392”

Three Ways to Reverse The Letters In An Excel Cell – 2391
Three ways to write a function to reverse the characters in a cell in Excel.
Fast Excel from Charles Williams offers a REVERSE function: https://mrx.cl/speedv4
Table of Contents
(0:00) Welcome and set up
(1:09) Using a VBA macro to reverse the Continue reading “Three Ways to Reverse The Letters In An Excel Cell – 2391”

Solving Slugify With Recursive Lambdas In Excel – 2390
Building a SLUGIFY function in Excel using the brand new recursive LAMBDA function. This video shows how to use an Index argument to act as a loop counter in an Excel formula. Thanks to Smozgur who posted this example at Continue reading “Solving Slugify With Recursive Lambdas In Excel – 2390”

New Cut Out People In Excel – 2389
There are now 925 poses of 41 different cutout people available in Excel, Word, and PowerPoint. Four have been cut from the cast. Nine have been made harder to find. Tips on using the new cutout people.

How To Simulate Dynamic Theming In Power BI Reports
In this tutorial, I’d like to demonstrate how you can simulate dynamic theming in your Power BI reports. As of May 2021, only a single theme JSON file can be used in a Power BI report and a page can Continue reading “How To Simulate Dynamic Theming In Power BI Reports”

How To Create A Power Apps Account
Our new course, Power Apps Masterclass, will jump start your learning journey on Microsoft’s Power Apps. This course is developed and taught by Enterprise DNA Expert, Henry Habib. Get a step-by-step guide that will help you create, share, and deploy applications Continue reading “How To Create A Power Apps Account”