Search Results

With Power Query, you can quickly turn messy data into smart decisions – fast! Automate repetitive tasks and create reports in a fraction of the time.

Learn 10 of the most productivity increasing “hidden” features of Power Query to take your skills to the next level.

Get step-by-step recipes for real-world automation problems. Learn Power Query and Power Automate solutions for SharePoint, PDFs, and workflows – apply them immediately to save hours.

With Power Query, you can quickly turn messy data into smart decisions – fast! Automate repetitive tasks and create reports in a fraction of the time.

With this trick you can easily combine and repeat blocks of values together in Excel. You don’t need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I’ll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import Outlook data to Excel.

Working with time in Excel – for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more. Excel Power Query has powerful text transformation options.

Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose – just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.