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”