ExcelHash participants discuss lessons learned and memorable moments.
#ExcelHash #Excel #MicrosoftExcel
Category: Excel
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.
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”
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”
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”