Today, a quick tip for sorting left to right in Excel.
With the correct headings, it is a faster way to rearrange columns.
Check out all 12 expert tricks at: https://www.youtube.com/watch?v=nOIEeUHyye0
My course on Retrieve: https://mrexcel.retrieve.com/
Check out my Excel Guides on Retrieve: https://mrexcel.retrieve.com/#/
A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31?
This Continue reading “Excel Pivot Table Fiscal Year Date Rollups – 2452”
In this tutorial, we’re going to take a look at a piece of DAX code that you might have written in your DAX journey. You might also have been confused as to how this code is actually working, and how Continue reading “Dependency Of A Function On Row Context In DAX Explained With DAX Studio”
Download Excel File: https://excelisfun.net/files/EMT1767.xlsx
Learn how to count unique dates for each item four ways: PivotTable and DAX Implicit Measure, Spilled Array Formulas, FREQUENCY Function and LAMBDA function.
1. (00:00) Introduction
2. (00:18) Goal of unique count formula
3. (00:30) Data Continue reading “Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767”
We’re keeping the ball rolling with the 2nd installment of our end-of-year content countdown with the release of a 2-part course on Sharepoint developed and instructed by eDNA Expert and our lead in all things Power Apps and Power Automate, Continue reading “How Sharepoint Can Improve Your Power BI Development – Upcoming New Course”
EVENT DETAILS – https://enterprisedna.co/getting-started-with-power-apps-development-december-2021-registration/
When is it?
December 16th, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
December 17th, 9am Sydney (AEDT), 11am Auckland (NZDT)
Where is it? Join in from your laptop, desktop or connected Continue reading “Getting started with Power Apps Development – Enterprise DNA Webinar Series”
Download Excel File: https://excelisfun.net/files/EMT1766.xlsx
Learn how to.
1. (00:00) Introduction
2. (00:38) Why we build formulas in cells before pasting formula into Conditional Formatting Dialog Box
3. (01:19) Logic for formulas to find missing numbers in the incident number
4. (02:09) Create Continue reading “Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766”
How to create your own custom data types in Excel using ScriptLab and the Javascript API.
Important Links:
Try out the workbook with my custom data types: https://1drv.ms/x/s!As7G72Sl487JliYRnUs0P4hYYNQj?e=rIL25J
Github for the example using a Custom Function:
<a href="https://gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170" Continue reading “Wow! Excel Custom Data Types From JavaScript API – 2451”
The data types gallery with Geography, Stocks, Currency, and Wolfram is mildly interesting. But I think the real goal is to get your own company data in the Data Type. I want it to be a very rich experience, just Continue reading “Excel Custom Data Types From Power BI – 2450”
We continue our recent career series with a round table discussion today of what it takes to build a successful BI consultancy. Particularly as the future of work continues to evolve in the face of the ongoing pandemic, you Continue reading “What It Takes To Develop A Successful BI Consultancy – eDNA Experts Round Table”
The Excel team snuck a new feature into Excel and I didn’t realize it for a while. Thanks to Excel MVP Abiola David for realizing that you can left-click any number in the status bar to copy that number to Continue reading “New! Copy Any Status Bar Number To Clipboard In Excel – 2449”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about how to create X-Y Linear Data Scatter Charts from X-Y data in Excel using Excel Charts and the Microsoft Artificial Intelligence Data Analyze Button.
Topics:
1. (00:00) Introduction
2. (00:34) First X-Y Scatter Data Set: Continue reading “Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button?”