Get & Transform Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-transform/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 11:44:52 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Get & Transform Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-transform/ 32 32 How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily https://www.xelplus.com/excel-text-transformation-power-query/ Thu, 11 Jun 2020 09:00:00 +0000 https://www.xelplus.com/?p=11298 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.

The post How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily appeared first on Xelplus - Leila Gharani.

]]> How to Easily Import Data from Web to Excel https://www.xelplus.com/import-data-from-web-to-excel/ Sun, 15 Dec 2019 02:53:00 +0000 https://www.xelplus.com/?p=11661 Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you'll just need to "refresh" the data in Excel to get the latest information. It's super easy!

The post How to Easily Import Data from Web to Excel appeared first on Xelplus - Leila Gharani.

]]>