Today, Bill has data where the amount of indent is telling him some data. He shows how to use VBA and IndentLevel to add a column of data showing the indent level. Then, a second technique, using the Group button Continue reading “Excel Indent Levels As Data – 2411”
Category: Excel
New Accessibility Tab In Excel Ribbon – 2410
May 20th, 2021 is Global Accessibility Awareness Day. It is a great day to take a look at the new Check Accessibility tab in the Excel ribbon.
XLMiner Is A Better Replacement For Excel Analysis ToolPak – 2409
Are you trying to use the Analysis ToolPak dialog box?
There is a better version, for free, from Frontline Systems.
Running into a bug? Microsoft knows about the problem.
George Mount’s book: https://amzn.to/3ygyK5z
Dan Fylstra’s XLMiner info: rel=”nofollow”>https://appsource.microsoft.com/en-us/product/office/WA104379190
Four Excel Features To Maybe Avoid – 2408
In an episode guaranteed to hack off many of my friends, Bill and Ann K. Emery discuss some Excel features they don’t like, such as:
The Action Pen
Shoot a Photo Of Your Data
Ctrl+T Tables
Conditional Formatting Data Bars with a Gradient.
Check out Continue reading “Four Excel Features To Maybe Avoid – 2408”
Emergency Services Analytics – Power BI Challenge #14 Has Launched!
The Power BI Challenges have been the best learning experience for our Enterprise DNA members and even for non-members who join our challenges. Our aim is to bring you great scenarios and data problems which would resonate with an industry Continue reading “Emergency Services Analytics – Power BI Challenge #14 Has Launched!”
How To Extract Record Field Values From Lists
For today’s video, I’d like to demonstrate how you can extract record field values from nested lists and combine those into a single text string.
Melissa
***** Video Details *****
00:00 Introduction
00:25 The problem
01:13 Reference source query
01:22 Create custom column
01:36 List.Transform
02:28 lookupvalue
04:09 Text.Combine
***** Continue reading “How To Extract Record Field Values From Lists”
Introduction to Enterprise DNA Power BI Accelerator
We’re happy to announce that we’re rolling out a new initiative within the Enterprise DNA community — the Power BI Accelerator! One of the things we’ve learned, both through research and experience, is that while you can learn a lot by Continue reading “Introduction to Enterprise DNA Power BI Accelerator”
Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI
Virtual tables are my personal favorite DAX topic because I think they’re the key to unlocking the full power of DAX. Virtual tables are the only type of tables within Power BI that are fully dynamic, and there are problems Continue reading “Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI”
Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to calculate Moving Annual Total in Excel worksheet with the SUMIFS function.
Topics:
1. (00:00) Introduction.
2. (00:26) Painter excelisfun Intro.
3. (00:50) SUMIFS & EOMONTH function solution solution. Works in any version of Excel.
4. (02:27) Continue reading “Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724”
Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to use Conditional Format your spilled array formula so that if the formula spills new values, the formatting spills also!
Topics:
1. (00:00) Introduction
2. (00:25) Formula #1. Logical Formula that uses NOT Operator and Continue reading “Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723”
Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Using Microsoft 365 Excel, learn how to use Excel formulas to create formula number incrementors to show 1,1,1,2,2,2,3,3,3… or 1,2,3,1,2,3,12,3,… using the SEQUENCE, INT and MOD functions.
Method for Any Version of Excel: <a href="https://www.youtube.com/watch?v=AIQbJAPMrEg" Continue reading “Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722”
Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to add the text numbers at the end of a description to get a Sales Total using Power Query User Interface. This trick comes from YouTuber Excel Teammates Peets and Software Train.