Power Query | How To Excel

Apr 14, 2020

Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.

Apr 30, 2019

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

Jan 28, 2019

Learn how to do a bulk find and replace in power query based on a list of values.

Jan 17, 2019

Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.

Dec 23, 2018

Learn the basics of power query’s M code language with this complete guide to M code.

Sep 27, 2018

Learn how to remove unwanted space characters from text data in Excel using various methods.

Get the Latest Microsoft Excel Tips

Subscribe for awesome Microsoft Excel videos 😃