Author: Bb

Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas

Posted on by Bb

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” →

Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741

Posted on by Bb

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 Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals

Posted on by Bb

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” →

Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.

Posted on by Bb

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.” →

Lesson 2: The four Pillars of Power Bi – Power BI 101

Posted on by Bb

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” →

Lesson 1: What is Power BI? – Power 101

Posted on by Bb

Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW

Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139

Power BI is a collection of tools, Continue reading “Lesson 1: What is Power BI? – Power 101” →

Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!

Posted on by Bb

Excel Data Analysis 02 files:
https://excelisfun.net/files/EDA02-Start.xlsx
https://excelisfun.net/files/EDA02-FinishedAfterVideoFilmed.xlsx
https://excelisfun.net/files/EDA-02-CSVFiles.zip
https://excelisfun.net/files/EDA02-PowerPivotImport.pbix
This is a comprehensive and complete lesson in how to use Power Pivot & DAX Formulas to create reports Continue reading “Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!” →

Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1740.xlsx
Learn how to use “ALL” as a condition in SUMIFS function to add whole column of numbers, but when a specific product is selected, the SUMIFS adds for just Continue reading “Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740” →

Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts

Posted on by Bb

Excel Data Analysis 01 files:
https://excelisfun.net/files/EDA01-Start.xlsx
https://excelisfun.net/files/EDA01-FinishedAfterVideoFilmed.xlsx
https://excelisfun.net/files/fSales.txt
https://excelisfun.net/files/fSales-WithExtraYearData.txt
In this video learn the basics of Data Analysis using Microsoft PivotTables, Power Query, Worksheet Formulas and Charts. Learn Continue reading “Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts” →

SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1739.xlsx
Learn how to create the most awesome SUMIFS function solution possible. Add a dynamic data validation dropdown list that updates when new products are added to data set and Continue reading “SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739” →

Lesson 0: High Level introduction to Power BI – Power BI 101

Posted on by Bb

Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW

Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139

Who is this tutorial for?

If you are Continue reading “Lesson 0: High Level introduction to Power BI – Power BI 101” →

Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738.

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1738.xlsx
Get three lowest prices. Power Query.
Use Power Query to dynamically extract the three lowest prices and the transporter names, including ties for the third position. This Power Query solution Continue reading “Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738.” →