93 тысяч подписчиков
263 видео
Is Typing going to be a skill of the past? GPT4 and Analyzing Excel with speech.
Power Query Challenge Bananas Split - Splitting multiple related records from multiple columns
Combining Multiple Files from a folder using Power Query in Excel or Power BI ( ⚠️see description )
How to Rename Column Headings with Power Query - the quick automated way
DAX and the Start Date End Date Problem aka Events In Progress
Adding Public Holidays to your Power BI Calendar
Power BI: Show Last Refresh - Using UtcNow
Combine Files from SharePoint folder and sub folders ( Easily enter a File Path )
Folders in Power BI Workspaces
Power Query Columns and Text - The Survey Challenge
Faster SharePoint folder consolidation using Incremental Refresh (see warning in the notes)
Referencing Dynamic Arrays with Tables
Highlighting Duplicate Values in Excel - adding alerts with Dynamic Array Formulas
Power BI searchable Slicer
Get started with Python in Excel with GPT4 guidance
[see update in description] How to create an Excel Table linked to a Power BI dataset
Excel Dynamic Arrays - Excel Challenge Solution
XLOOKUP v Power Query v Power Pivot in Excel
Visual Calculations in Power BI
NEW! Power BI Now with Auto Refresh in PowerPoint
Power BI connected Excel Pivot Table embedded in App
How to Start & Stop Fabric Capacity automatically, and how to purchase Fabric.
Power BI Continuous Date Hack with your own Date table
EXCEL LAMBDA tips (see description for link to intro video)
What is a Date Table / Calendar table in Power BI / Excel
Upgrade your Excel Toolbar now with Chat GPT buttons!
How to find, remove and hide unused Measures and Columns in Power BI
Excel self-updating Drop Down List for Data Validation
Excel Copilot is not great - yet…
Power Query Pivot and adding an Index column to a Grouped Field
WHAT is POWER BI ? What Why How to learn Power BI
Consolidate and Hyperlink to Files on SharePoint
How to display an image from SharePoint or OneDrive in Excel
Excel and Power BI Stacking Grouped Columns Challenge
Simple Excel Dates Fix - US Format issue
What is Microsoft Fabric? A simple explanation for non-technical people.
Power BI how to un-filter a Single Page
Using DAX to create Conditional Formatting Icons
Practical use case for Power Query metadata
How to hide Power BI pages from specific people
How to create your own Power BI visual using Deneb
Deneb lesson - Part 2 - Conditional Formatting and adding extra layers
Great tricks when loading Files From Folder if sheet names are different
Group Uniques - Power Query Challenge
Excel Quick Compare Ranges
New Chat GPT4 Feature - add your own GPTs (see code in description)
Power BI On Off switch wth the new slicer buttons
#PowerBI
How to hide a Power BI page securely
Better Excel Dashboard and how to build your own GPT with GPT4
