A large portion of Microsoft’s Ignite 2021 premier conference was devoted to updates to the Power Platform, but what exactly was covered? What updates were made? In this video, we’ll go through what I think are the top key updates Continue reading “Top Updates To Power Apps & Power Automate – Microsoft Ignite 2021”
Month: November 2021
Excel Statistical Analysis 01: Data & Statistics
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:54) Use File Explorer, Show File Extensions, Create Folder for class
(02:59) Use People Web Site to download files for this class
(05:58) How to open Excel files using File Explorer
(04:28) Define Data Continue reading “Excel Statistical Analysis 01: Data & Statistics”
The Different Types Of Flows In Power Automate And When To Use Them
Confused about Power Automate flows? In this video, we go through the similarities and differences between the different types of flow, and we determine when to use each flow. We go through a simple decision-making process (just 3 questions) that Continue reading “The Different Types Of Flows In Power Automate And When To Use Them”
How To Build A Scrolling KPI Ticker In Your Power BI Report
For this video, I’d like to go through a custom visual I used in the report I developed for my eDNA Power BI Challenge 16 entry that’s called a KPI ticker. It’s a pretty eye-catching visual and so I got Continue reading “How To Build A Scrolling KPI Ticker In Your Power BI Report”
Why Learn Another Language To Augment Power BI And Which One? — eDNA Experts Round Table
To fully unlock the analytical and visualization capabilities of Power BI, it’s necessary to couple it with another language — either Python or R.
In this video, we’ll discuss questions related to the decision of which language to choose, when in Continue reading “Why Learn Another Language To Augment Power BI And Which One? — eDNA Experts Round Table”
Paste Across Computers But Not Paste All – 2440
The Windows Clipboard (in Windows 10 or Windows 11) can now sync across devices. Copy from one computer and paste to another computer! No more mailing stuff to yourself just to get from this computer to the other. (Here at Continue reading “Paste Across Computers But Not Paste All – 2440”
First N Business Days Revisited – DAX Solution And Dynamic Titles
For this video, let’s go back to a mini-series I recently started that explores different ways to solve a problem from an Enterprise DNA forum entry asking how to compare data by billable days instead of calendar days. This is Continue reading “First N Business Days Revisited – DAX Solution And Dynamic Titles”
Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
Download Excel File: https://excelisfun.net/files/EMT1764.xlsx
This video exposes the misleading Microsoft terminology for ‘Blanks’. This video examines empty cells, cells with double quotes (zero length text strings) and all the ramifications for Excel worksheet formulas. See the functions: ISTEXT, Continue reading “Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764”