Do you want to show your prospective employers that you know Power Platform? Are you confused by what all the different Power Platform certifications mean? Why is PL-900 easier than PL-200? In this video, Henry answers those questions and goes Continue reading “Why You Should Get Microsoft Certifications For Power Platform”
Month: March 2022
COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777
Download Excel File: https://excelisfun.net/files/EMT1777.xlsx
Learn about the situations where you can spill results from SUMIFS, COUNTIFS, MINIFS, MAXIFS and AVERGAEIFS.
Learn how to.
1. (00:00) Introduction
2. (00:50) COUNTIFS function example that CANNOT Spill
3. (01:44) COUNTIFS function example that CAN Spill
4. Continue reading “COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777”
Three Crazy AutoSum Tricks In Excel – 2473
Antony in Toronto brings us two more Excel AutoSum Oddities.
This was part of my hour-long session on Excel Oddities, Curiousities and Mysterious Wonders for the Vancouver Modern Excel Users Group. Watch the entire hour here:
https://youtu.be/H7rSetB7IRo?t=277
REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022)
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do Continue reading “REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022)”
Calculate Age In Excel – 2462
Doug from Boston needs to calculate an age in Excel.
Two easy formulas today: YEARFRAC and DATEDIF.
Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method – EMT 1776
Download Excel File: https://excelisfun.net/files/EMT1776.xlsx
Learn how to build a simple formula to automatically extract invoices that are 1 to 30 days past .
Topics:
1. (00:00) Introduction
2. (00:27) History about how to do it in Any Version of Excel.
3. (02:02) Continue reading “Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method – EMT 1776”
F2 To Bring Selected Object Back Into View in Excel – 2471
Today’s question from Ken: I’ve lost a slicer. I know it is somewhere on the worksheet, but how can I find it?
Thanks to Lou Pham, we have an answer. Use Home, Find & Select, Selection Pane. Select the object. Press Continue reading “F2 To Bring Selected Object Back Into View in Excel – 2471”
Power Query Masterclass For Power BI
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
March 3rd – 4pm New York (ET), 1pm Los Angeles (PT), 9pm London (GMT)
March 4th – 8am Sydney (AEDT), 10am Auckland (NZDT), 2:30am India (IST)
How long is it?
Session will run for approximately Continue reading “Power Query Masterclass For Power BI”
Dealing with orphaned Power BI workspaces
What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script!
Delete Group/Workspace API:
https://docs.microsoft.com/rest/api/power-bi/groups/delete-group
AddUserAsAdmin API
https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin
Power Continue reading “Dealing with orphaned Power BI workspaces”
Create Hybrid Tables with Tabular Editor for Power BI? YES!!!
Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor!
–This Year
let
Source Continue reading “Create Hybrid Tables with Tabular Editor for Power BI? YES!!!”
How To Schedule A Power Automate Desktop Flow To Run Through Power Automate Online
Jarrett got a request during his session at the recently concluded Enterprise Analytics Summit for a tutorial on how to schedule a Power Automate desktop flows. In this video, Jarrett will demonstrate how you can do exactly that and run Continue reading “How To Schedule A Power Automate Desktop Flow To Run Through Power Automate Online”
Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775
Download Excel File: https://excelisfun.net/files/EMT1775.xlsx
Learn 3 formula methods to add the top three values.
Learn how to.
1. (00:00) Introduction
2. (00:12) Look at the issues that make this problem difficult
3. (00:59) 1st solution: SUM, LARGE and SEQUENCE solution
4. (01:10) 1st Continue reading “Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775”