If you've never heard of Excel's Power Query feature, you're not alone. Here's how to get started using it and gain a huge productivity boost.

In this tutorial, I’ll show you how to use Power Query to generate a list of sheet names that you can then load into Excel and use to navigate the workbook.

Learn Power BI basics in this beginner tutorial. Master the interface, connect data sources, clean data, and build your first data model.

It took three entries for Power Query to catch up with the pattern. In this basic example, you don’t gain much; however, if you have dozens or even thousands of records, this feature comes in handy.