A simple improvement to Excel appeared in November 2020: You can now unhide multiple worksheets at once. This feature is rolling out to Office 365 subscribers.
Month: August 2021
Look Ahead Selecting Names From List in Excel – 2380
Excel has supported the List option in Data Validation for a decade. But let’s face it: it is not easy to select from the list. You can’t start typing and have the list shorten to just the matches, also known Continue reading “Look Ahead Selecting Names From List in Excel – 2380”
Lambda Functions Debut In Excel – 2381
New! Post your LAMBDA functions to https://www.mrexcel.com/board/forums/excel-lambda-functions.40/
Ground-breaking news in Excel. The partner to the LET function was just released. Check out the new LAMBDA function in Excel. This makes the Excel formula language Turing Complete. Store formula Continue reading “Lambda Functions Debut In Excel – 2381”
Goal Seek Replaces Algebra – 2283
Check out Rob Collie’s Raw Data podcast: https://powerpivotpro.com/rawdatapodcast/
Today, I ran across an unanswered question in a Math board. No one really needs to know this answer. It is a high school math teacher trying to trick people Continue reading “Goal Seek Replaces Algebra – 2283”
Achieving Project Balance In Power BI – Problem Of The Week #11 Solution
Greg Philps leads Problem of the Week #11. A not-uncommon problem that almost every Power BI user experiences is maintaining project balance. A project expands in scope over time, and when one side of the “Project Management Triangle” changes, at Continue reading “Achieving Project Balance In Power BI – Problem Of The Week #11 Solution”
New Modern Visual Tooltips For Power BI
For today’s video, I’d like to talk about the new Modern Visual Tooltips released just yesterday. The May 2021 Power BI updates is not a hugely exciting update but the Modern Visual Tooltips in particular is a feature that I Continue reading “New Modern Visual Tooltips For Power BI”
Free Power BI Resource Collection Including Dataset Builder Tool
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”
Top 10 Power BI Best Practices
Today, I’m going to share my personal Top 10 Best Practices for Power BI. Over the past months, I’ve released a series of videos showcasing a number of best practices addressing the 4 pillars in Power BI report development. I Continue reading “Top 10 Power BI Best Practices”
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”
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”
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”
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.