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.
Category: Excel
Yes!!! Define Your Own Linked Data Types in Excel! Episode 2378
It is like the Christmas where you got almost every thing you asked for. The Excel team has given us almost everything I asked for with the new data types. You can now create your own data types in Excel, Continue reading “Yes!!! Define Your Own Linked Data Types in Excel! Episode 2378”
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”
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”
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”
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”
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”
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”
ExcelHash Wrap-up discussion
ExcelHash participants discuss lessons learned and memorable moments.
#ExcelHash #Excel #MicrosoftExcel
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”