When you create a power query in Excel to import or transform your data, Excel...
How To Parameterize Your Power Query
read more
All Posts
How To Create A Hyperlink To The Current Workbook Folder
This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.
How To Get The Current Workbook Folder Path
This formula will return the folder path where the current workbook is saved.
How To Query A Query In Power Query
Today I was using power query to import external data in a CSV file and then...
How To Extract Data From Multiple Webpages With Power Query
Excel's Power Query (or Get & Transform since Excel 2016) is a great tool...
How To Calculate The Volume Of A Sphere
This formula will calculate the volume of a sphere given its radius.
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
