Download Excel File: https://excelisfun.net/files/EMT1751.xlsx
Learn how to Lookup Last Price In Column Based On Criteria In Other Columns.
1. (00:00) Intro
2. (00:30) Formula that works in any version, using LOOKUP function
3. (02:57) Microsoft 365 formula, using XLOOKUP
4. (03:56) Summary Continue reading “Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751”
For today’s video, I’d like to focus on something I’d like to call the “Hidden DAX Trap”. This is a situation that when you encounter without warning, will probably going to make you feel very confused because your DAX might Continue reading “The Hidden DAX Trap In Power BI”
This weekend, Fantasy Football teams will be doing their draft. If you are using the ESPN website to manage your draft, the Draft Recap Report could use some formatting.
Download our free Excel template from: http://www.mrexcel.com/download-center/2021/08/BetterESPNDraftRecap.xlsx
Watch the video Continue reading “Better ESPN Fantasy Draft Recap In Excel Free Download – 2426”
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-august-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 2 – Business Insights Deep Dive
When is it?
August 26th, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
August 27th, 7am Sydney (AEST), 9am Auckland (NZST)
Long ago, Excel offered a full screen mode. The Ribbon would completely disappear and you could get the maximum number of rows in the grid visible. The feature was removed in Excel 2013. Today, it is back! At least in Continue reading “Excel Full Screen Mode Returns – Episode 2425”
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-august-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 1 – Business Analytics w/Power BI
When is it?
August 25th, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
August 26th, 7am Sydney (AEST), 9am Auckland (NZST)
Where Continue reading “Airline Customer Satisfaction Analysis – Business Analytics With Power BI”
I have a problem in Excel. About a week ago, the vertical scroll bar on an Excel worksheet stopped working. I lost the scrolling ability from top to bottom. So when I try to drag the right scroll bar from Continue reading “Excel Vertical Scroll Bar Stops Working – 2423”
In this video, I want to show you one way of how you can split multiline cells into multiple rows. Sometimes you’ll get an Excel file where data inside the cell is split across multiple lines, and that can be Continue reading “Power Query To The Max – Splitting Multi-Lined Excel Cells In Power BI”
Download Excel File: https://excelisfun.net/files/EMT1750.xlsx
Learn how to compare to lists and extract items in both lists, or exact the items that are not in both lists. Formula #1: Extract items in List 1 that are in List 2. Continue reading “Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750”
For this tutorial, let’s take a closer look at the Enter Data option in Power BI and explore how to use it. By far, most cases will bring in data by connecting to a data source but Power BI also Continue reading “Demistifying Enter Data”
Download Excel File: https://excelisfun.net/files/EMT1749.xlsx
Learn how to use the 7 helper functions for the LAMBDA function. Learn how to use LAMBDA to create a re-usable function, and then how to use LAMBDA as a function value in the Continue reading “7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749”
Kartikey has 6800 rows of data. For each product in column A, he needs every combination of Column B with Column C. In this episode, Bill uses Power Query and a Full Outer Join to solve the problem.