Get Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-data/ Bestselling Excel and Power BI Courses Mon, 18 Dec 2023 10:20:49 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Get Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-data/ 32 32 How to Bulk Combine PDF Files in Excel https://www.xelplus.com/bulk-import-pdf-files-to-excel/ Mon, 20 Jun 2022 14:18:00 +0000 https://www.xelplus.com/?p=9102 Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy, paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the data is immediately imported to Excel.

The post How to Bulk Combine PDF Files in Excel appeared first on Xelplus - Leila Gharani.

]]> Properly Convert PDF Files to Excel https://www.xelplus.com/import-pdf-to-excel/ Thu, 15 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10614 Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

The post Properly Convert PDF Files to Excel appeared first on Xelplus - Leila Gharani.

]]> What is Power Query and Why Should You Use It? https://www.xelplus.com/excel-power-query-course-preview/ Mon, 29 Jun 2020 17:50:00 +0000 https://www.xelplus.com/?p=10898 What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

The post What is Power Query and Why Should You Use It? appeared first on Xelplus - Leila Gharani.

]]> How to Combine Files From a Folder with Excel Power Query https://www.xelplus.com/power-query-combine-files-folder/ Thu, 21 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11329 Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

The post How to Combine Files From a Folder with Excel Power Query 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.

]]>