solveandexcel

Two tips to recognize an Excel Table

Excel Template file type - When you should use it

Ways of recycling work in Power Query and saving time T0028

The easiest Excel Formula to get a sorted list of unique values . | Celia Alves - Microsft MVP

Import data from a Google Sheets file into Excel with Power Query without making the file public

Why my VLOOKUP formula is not working and how to fix it

Fast and easy way to copy a query to another workbook

How to add a File Picker in Excel to select the data source file for Power Query – T0019

How to unstack data in repeated groups of rows in the same column with Power Query in Excel

Compounding Time - how applying your time today can make your free time grow in the future

Conditional Format to hightlight the weekend days in Excel

Calculating the Invoice Due Date based on the Issuing Date and the Payment Terms

When does it make sense to use Power Query in Excel?

How to Copy a Power Query query from one Excel workbook to another one

How to make Power Query refresh on an Excel protected sheet

Make Power Query load all queries as Connection Only by default

How to display time values with text hrs in Excel

How to sort data in an Excel Table following any sorting criteria – T0023

How to work with two sheets of the same Excel file side by side on the screen

How to select shapes in Excel as in PowerPoint

How to append data with Vstack

How to change the Loading Destination of a Power Query query in Excel

What is Pivoted Data and why you should Unpivot it Learn how to unpivot using Power Query in Excel

How to Enable the Formula Bar in Power Query Editor in Excel