To address one of the most common requests from Enterprise DNA members to provide a straightforward, practical framework for Power BI implementation, Enterprise DNA CEO and Founder, Sam McKay has personally developed a new course Continue reading “Power BI Deployment: Strategy, Planning & Governance – Brand New Course”
Category: Excel
Column From Examples – My Favorite Feature Within The Power Query
For today’s video, I want to share by far my favorite feature inside the Power Query editor. When I look at my data sets now, I always think of how I can expand on them, Continue reading “Column From Examples – My Favorite Feature Within The Power Query”
Custom Theming In Power BI
For this video, I’d like to add another installment to my mini-series about Theming in Power BI. For this video, we’ll do a quick review of the customizations you can make by directly editing and Continue reading “Custom Theming In Power BI”
Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.
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.”
Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data
Four video release dates:
Mon, April 12: Data Analysis Class 00: Intro to PivotTable, Power Query, Power Pivot, Power BI & Visualizations, https://youtu.be/mFusmAyagsk
Mon, April 19: Excel Data Analysis Class 01: PivotTable, Power Query, Continue reading “Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data”
Average Excluding Min and Max Values -TRIMMEAN function in Excel formula
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”
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 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”
11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
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”
Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747
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”
IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
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”
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
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 Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas
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”