Make it Easier to Share Power Query Relative File Location (Text or TXT)

If you share Excel files with Power Query queries, you notice that it can be "broken" if you the source data is referenced outside of the worksheet itself. This video will cover how to get around an simple query that references a text (.txt) file. There will be another video later because this is the simpler solution that involves adjusting the Power Query privacy setting to get around the Formula.Firewall error message.

Create a Progress Circle Chart in Excel

Have you seen those infographic charts that have concentric circles broken into smaller segments to represent a part of a whole? Like 50 percent of the concentric circle is shown to show like people like 50 percent of something? Plus there are multiple circles that represent additional series of data. This progress circle chart or progress ring chart is actually a doughnut chart and it's pretty easy to create so check out the video to learn how!

Simulate the Tabular Form Pivot Table Layout in Power Query

Sometimes our stakeholders want a table to looks like the Tabular format that comes from a Pivot Table but they don't want to see all that extra functionality from the Pivot Table. They want to see the Tabular format without repeating values in some of the columns so it looks "cleaner". We can actually simulate this using Power Query but it involves some M code (just a little bit).