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”
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 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!”
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 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”
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”
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”
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.”
Download Excel File: https://excelisfun.net/files/EMT1742.xlsx
Learn how to create a Day of Week Totals Sales and Average Sales reports using PivotTable, Sorting, Conditional Formatting, Worksheet Formulas and much more. Learn keyboards, PivotTable, Standard Formulas Continue reading “Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742”