Download Excel File: https://excelisfun.net/files/EMT1736.xlsx
Learn how to extract an ID number between a start and end space delimiter.
Topics:
1. (00:00) Introduction
2. (00:32) Worksheet Formula with 6 functions.
3. (02:21) LET function to remove formula elements Continue reading “Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.”
Download Excel File: https://excelisfun.net/files/EMT1744.xlsx
Learn how to calculate the average while excluding the min and max values. See how to use TRIMMEAN function to exclude a given percentage of high and low data. Continue reading “Average Excluding Min and Max Values -TRIMMEAN function in Excel formula”
Download Excel File: https://excelisfun.net/files/EMT1745.xlsx
Learn how to create and spill random normally distributed values using the NORM.INV and Continue reading “Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values”
Download Excel File: https://excelisfun.net/files/EMT1745.xlsx
Learn how to create a random monthly sales data set with the fields: Date, Continue reading “11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745”
Download Excel File: https://excelisfun.net/files/EMT1747.xlsx
Where is the VLOOKUP or XLOOKUP function in Power Query? Learn how to perform Continue reading “Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747”
Download Excel File: https://excelisfun.net/files/EMT1746.xlsx
Learn how to create an OR Logical Test to make an aggregate calculation depending Continue reading “IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746”
Download Excel File: https://excelisfun.net/files/EMT1743.xlsx
Learn about aggregate calculations with conditions and criteria. Learn about an AND Logical Test, and then see how the FILTER function can help with OR Logical Tests and advanced Continue reading “OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743”
Excel Data Analysis 04 files:
https://excelisfun.net/files/EDA04-Start.xlsx
https://excelisfun.net/files/EDA04-Finished.xlsx
https://excelisfun.net/files/EDA04-ReportsFinished.pbix
https://excelisfun.net/files/EDA03-Reports-FinishedAfterVideoFilmed.pbix
Download Power BI Desktop: https://powerbi.microsoft.com/en-us/desktop/
Topics in the video:
1. (00:00) Intro
2. (00:38) Overview of data and visuals Continue reading “Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas”
Download Excel File: https://excelisfun.net/files/EMT1741.xlsx
Learn how to.
1. (00:00) Introduction
2. (00:04) TEXTJOIN function.
3. (00:34) ARRAYTOTEXT function to deliver text separated by commas. If no empty cells, this method is faster.
4. (01:00) When TEXTJOIN to Continue reading “Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741”
Excel Data Analysis 03 files:
https://excelisfun.net/files/EDA-03-ExcelFiles.zip
https://excelisfun.net/files/EDA03-Reports-FinishedAfterVideoFilmed.pbix
Download free Power BI Desktop: https://powerbi.microsoft.com/en-us/desktop/
Learn about Power BI Desktop (and online too) as the perfect compliment to your Excel Data Analysis Continue reading “Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals”
Download Excel File: https://excelisfun.net/files/EMT1737.xlsx
Learn how to lookup and display the three lowest transportation prices and transporter name from a large lookup table with From Location, To Location and Size of Truck. There-way Continue reading “Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.”
The four Pillars of Power BI
Congratulations! You have passed this lesson.NEXT LESSON
CONTACT LESSON TEACHER
Now that you know what Power BI is, let’s talk about the four main components that you have in Power BI Continue reading “Lesson 2: The four Pillars of Power Bi – Power BI 101”