Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.
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.
Learn how to do a bulk find and replace in power query based on a list of values.
Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.
Learn the basics of power query’s M code language with this complete guide to M code.
Learn how to remove unwanted space characters from text data in Excel using various methods.