Download Excel File: https://excelisfun.net/files/EMT1732.xlsx
Learn how to:
1. (00:00) Introduction
2. (00:36) PivotTable and Pivot Charts in just one click!
3. (02:50) X Y Scatter Chart has NEVER been better!
4. (04:06) Summary, Closing and Video Links
Month: August 2021
Create PivotTable in Excel Online. Excel Magic Trick 1733.
Download Excel File: https://excelisfun.net/files/EMT1733.xlsx
Open Excel Online: https://office.live.com/start/excel.aspx
Learn how to build a PivotTable in Excel Online.
In the comments, let me know what you think about this : )
Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.
Download Excel File: https://excelisfun.net/files/EMT1734.xlsx
Learn how to:
1. (00:00) Introduction
2. (00:19) Power Query Create Data Types
3. (01:46) Records in Cell. View Car. Add Column
4. (02:07) Data Validation to select a full record in a Continue reading “Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.”
Lesson 6: Amazing Power BI Mobile features 📱- 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
Have you tried the power bi mobile Continue reading “Lesson 6: Amazing Power BI Mobile features 📱- Power BI 101”
Lesson 5: Intro to Power BI Service – 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
Now that you have a better idea Continue reading “Lesson 5: Intro to Power BI Service – Power BI 101”
Lesson 4: Power BI Desktop Main Components – Power BI 101
Now that you know how to get Power BI Desktop and you know which version to get, let’s go in a little bit more detail of what Power BI Desktop is and what it can Continue reading “Lesson 4: Power BI Desktop Main Components – Power BI 101”
Lesson 3: Intro to Power BI Desktop – 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
Now that you have a better understanding Continue reading “Lesson 3: Intro to Power BI Desktop – Power BI 101”
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”
Power BI Deployment: Strategy, Planning & Governance – Brand New Course
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”
Why Hiding Pages Make Your Power BI Reports More Application-Like – Power BI Design Tips
For this video, I’d like to talk about how you can make your Power BI reports look more application-like by simple hiding pages. This is a methodology that I’ve seen being used in many of Continue reading “Why Hiding Pages Make Your Power BI Reports More Application-Like – Power BI Design Tips”
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”
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”