RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
October 14th, 6pm New York (EDT), 3pm Los Angeles (PDT) , 11pm London (BST)
October 15th, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Crypto Dashboard PART 2 – Power BI Freestyle Session”
Download Excel File: https://excelisfun.net/files/EMT1761.xlsx
Learn how to use the XNPV function to discount non-periodic future cash flows to value investments.
This video answers the question: why does the NPV and XNPV function yield different answers. Look at the algorithm Continue reading “Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761”
For matriculating students in fall, 2021 at Highline College:
Excel & Statistics Busn 210, Week 4, Day 1, Fall Quarter, 2021
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
October 14th, 6pm New York (EDT), 3pm Los Angeles (PDT) , 11pm London (BST)
October 15th, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Power BI Freestyle Session w/ Sam McKay”
Can you use the MAX function in Excel to find the largest value across all worksheets? You can use a 3-D Reference or a spearing formula. In this episode, I will show you an easier way to create 3D Continue reading “Excel MAX Across All Worksheets – 2434”
We’re pleased to announce the upcoming release of our new course focusing on Python for Power BI users developed by one of our Enterprise DNA Experts, Gaelim Holland.
Python integration has been generally available in Power BI, which you can use Continue reading “Why Power BI Users Should Learn Python – Upcoming New Course”
Learn how to create an advanced array formula to spill two-way lookup results using INDEX and MATCH function.
Topics:
1. (00:00) Introduction.
2. (00:14) Formula
3. (02:03) Thanks to Excel Lambda for this formula!
Download Excel File: https://excelisfun.net/files/EMT1760.xlsx
Learn how to create an advanced array formula to spill two-way lookup results using VLOOKUP, MAP, LAMBDA and XMATCH Microsoft 365 functions. As of Monday, October 11, 2021, the MAP function is only in Continue reading “VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760”
In this video, I want to give you a sneak peek into something new that we’ve been working on at Enterprise DNA. The Team and I are all about empowering Power BI users across countries and nations as they hone Continue reading “Power BI Design Kits Are Coming! Check Out Our Latest Game Changing Initiative”
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Greenlake BMX Skatepark on Sunday Oct10, 2021. No big tricks, just Old Guy BMX fun!
Nick and I jump from bowl to bowl for first time. It Continue reading “Sunday Oct 10, 2021 Old Guy BMX Park Fun at Lower Woodland BMX Park”
Your manager asks if you can add a blank row after each subtotal. Episode 2433 shows you how to do this in Excel.
The first way, is clearly cheating: Increase the height of each row.
But the second way is the Continue reading “Excel Add A Blank Row After Each Subtotal – 2433”
For this video, I’d like to show how incredible the Key Influencers visualization is inside Power BI. I recently did a webinar wherein we ended up analyzing some health information to understand and even almost predict someone’s mortality or survival Continue reading “The Key Influencers Visual In Power BI Is Incredible & We Should Use It More”