Create A Thermometer Visual To Display Actual Versus Target
In this post, we’re going to take a look at how we can build a custom thermometer visual to...
Read More
37 Awesome Excel Mouse Tips & Tricks You Should Know
While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.
Read More
Copy And Paste Data From Excel Into Power BI
Learn how to copy and paste data from an Excel workbook or text file into Power BI using the Enter Data feature.
Read More
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
Consulting
Newsletter
Excel Functions eBook
Microsoft MVP
Recent Posts
Newsletter