Create A Dynamic Traffic Light Visual For Your Excel Dashboards
I learnt a cool new trick in PowerPoint yesterday. I learnt about merging shapes. Like Excel,...
Read More
Integrating Power BI And PowerApps
Learn how to integrate Power BI and PowerApps. Embed a PowerApp into a Power BI dashboards or embed a Power BI visual into PowerApps.
Read More
Bulk Find And Replace In Power Query
Learn how to do a bulk find and replace in power query based on a list of values.
Read More
Replicate Excel’s TRIM Function In Power Query
Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.
Read More
Summarizing Text Data With Pivot Tables
Learn how to summarize text data in the values area of a pivot table using the data model and DAX formulas.
Read More
Introduction To Power Query M Code
Learn the basics of power query’s M code language with this complete guide to M code.
Read More
Create Amazing Key Performance Indicator Data Cards In Excel
Learn how to create some super cool key performance indicator (KPI) data cards in Excel to show off important metrics in your dashboards.
Read More
Sending SMS Text Messages From Excel
In this post we are going to learn how to send SMS text messages from Excel… because why...
Read More
Consulting
Newsletter
Microsoft MVP
Recent Posts
Newsletter