As part of a mini series that I’m doing on Power BI’s November 2021 updates, I’d like to tackle the Sort Legend feature for today’s video. It’s a nice functionality that they’ve added to the program, so I want to Continue reading “Sort Legend Tutorial And Review – Power BI November 2021 Updates”
Month: November 2021
Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions
ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Download CSV File: https://excelisfun.net/files/Ch01-ESA-AutoData.csv
Learn about how to use Power Query to import and transform CSV File data Continue reading “Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions”
Enterprise Analytics Summit – Text Analytics & Sentiment Analysis in Python
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 5 – Text Analytics & Sentiment Analysis in Python
When is it?
November 25th, 3pm New York (EDT), 12pm Los Angeles (PDT), 8pm London (GMT)
November 26th, 7am Sydney (AEDT), Continue reading “Enterprise Analytics Summit – Text Analytics & Sentiment Analysis in Python”
Enterprise Analytics Summit – Advanced Data Storytelling Features In Power BI
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 6 – Advanced Data Storytelling Features In Power BI
When is it?
November 25th, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (GMT)
November 26th, 9am Sydney (AEDT), Continue reading “Enterprise Analytics Summit – Advanced Data Storytelling Features In Power BI”
Reverse A Column In Excel – With Mike Girvin – Duel 196
You have a column of data in Excel. You need to reverse the column, bottom to top.
How can you do this? Can you do it without a helper column?
Bill Jelen and Mike Girvin compare six ways
Table of Contents
(0:00) Description Continue reading “Reverse A Column In Excel – With Mike Girvin – Duel 196”
Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun
Download Excel File: http://excelisfun.net/files/Flip_A_Column_In_Excel_Duel_196.xlsx
Learn how to flip on column in Excel. See Microsoft 365 Excel formulas, Worksheet Formulas that work in any version of Excel, Spilled Array with Old School functions, Custom List and Secret Sort Trick, Continue reading “Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun”
Enterprise Analytics Summit – Handling Mismatched Granularities in Power BI
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 3 – Handling Mismatched Granularities in Power BI – A Toolkit for Business and Financial Analyses
When is it?
November 24th, 3pm New York (EDT), 12pm Los Angeles (PDT), Continue reading “Enterprise Analytics Summit – Handling Mismatched Granularities in Power BI”
Enterprise Analytics Summit – Python For Excel
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 4 – Python For Excel
When is it?
November 24th, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
November 25th, 9am Sydney (AEDT), 11am Auckland (NZDT)
Where Continue reading “Enterprise Analytics Summit – Python For Excel”
Find The Last One In A Series Of 1s And Zeroes With Dan Mayoh – 2445
There is a classic Financial Modeling problem in Excel. You are checking values in each month and you end up with a row of zero and one values. How can you find the last month where you have a one?
Dan Continue reading “Find The Last One In A Series Of 1s And Zeroes With Dan Mayoh – 2445”
Enterprise Analytics Summit – Increasing Your Development Speed & Productivity In Power BI
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 1 – Increasing Your Development Speed & Productivity In Power BI
When is it?
November 23rd, 3pm New York (ET), 12pm Los Angeles (PT) , 8pm London (GMT)
November 24th, Continue reading “Enterprise Analytics Summit – Increasing Your Development Speed & Productivity In Power BI”
Enterprise Analytics Summit – Create An Expense Reporting & Approval App in Power Apps
EVENT DETAILS – https://enterprisedna.co/power-platform-summit-november-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 2 – Create An Expense Reporting & Approval App in Power Apps For Your Organization
When is it?
November 23rd, 5pm New York (ET), 2pm Los Angeles (PT) , Continue reading “Enterprise Analytics Summit – Create An Expense Reporting & Approval App in Power Apps”
Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765
Download Excel File: https://excelisfun.net/files/EMT1765.xlsx
Learn how to convert a horizontal range of labels to a vertical numbered list of labels. Learn how to do it with a formula in Microsoft 365 Excel and an “Old School” method that Continue reading “Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765”