For today’s video, I wanted to spend some time highlighting a fantastic new free resource collection available to both Enterprise DNA members and non-members. I’ll also be particularly demonstrating a tool called Data Randomizer, which can be used to build Continue reading “Free Power BI Resource Collection Including Dataset Builder Tool”
Author: Bb
Bakersfield to Stockton via Excel Hash – 2386
Today, Excel is offering all sorts of support for Geography, from 3D Map, Filled Map, Geography Data Type, and Location Data Types. But there was a secret project way back in 2005 that dabbled in Geography. In this entry Continue reading “Bakersfield to Stockton via Excel Hash – 2386”
Super Bowl Squares Percentages with Rocket Mortgage Change – 2385
Free to enter at: https://mrx.cl/rocket2021
It is Super Bowl week in America, which means that people are playing the popular Super Bowl Squares gambling game. But this year, Rocket Mortgage is offering a different version of the game. Continue reading “Super Bowl Squares Percentages with Rocket Mortgage Change – 2385”
Rearrange A Pivot Table In Excel (Rocket Mortgage Super Bowl Squares) – 2387
The numbers for the Rocket Mortgage Super Bowl Squares are out. It is super easy to rearrange a pivot table in Excel by simply typing.
For more about how I generated the pivot table in the first place, see episode 2385.
ExcelHash Wrap-up discussion
ExcelHash participants discuss lessons learned and memorable moments.
#ExcelHash #Excel #MicrosoftExcel
Why Don’t These Cells Match In Excel – 2384
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”
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)”
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”
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”
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”
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.