Power Query Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/power-query/ Bestselling Excel and Power BI Courses Thu, 21 Dec 2023 13:41:28 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Power Query Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/power-query/ 32 32 5 Hidden Excel Features for Busy People https://www.xelplus.com/excel-useful-features/ Fri, 08 Dec 2023 14:38:35 +0000 https://www.xelplus.com/?p=19832 Learn five amazing time-saving features in Excel that you likely have never tried or even knew existed. Turn hours of work into seconds.

The post 5 Hidden Excel Features for Busy People appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> How to Use Power BI – Beginner’s Guide https://www.xelplus.com/how-to-use-power-bi/ Thu, 16 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=9644 Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!

The post How to Use Power BI – Beginner’s Guide appeared first on Xelplus - Leila Gharani.

]]> How to Repeat Table Values x Times Using Power Query https://www.xelplus.com/repeat-combine-values-excel/ Thu, 07 Oct 2021 08:00:00 +0000 https://www.xelplus.com/?p=9788 With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

The post How to Repeat Table Values x Times Using Power Query appeared first on Xelplus - Leila Gharani.

]]> Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> How To Remove Duplicates in Excel (3 Easy Ways) https://www.xelplus.com/excel-remove-duplicates/ Wed, 28 Jul 2021 17:27:00 +0000 https://www.xelplus.com/?p=9932 These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It's a very common task for data cleaning and also a very common job interview question... BUT one of the methods returns a different result. Make sure you understand why.

The post How To Remove Duplicates in Excel (3 Easy Ways) appeared first on Xelplus - Leila Gharani.

]]> How to Create a Pivot Table from Multiple Sheets in Excel https://www.xelplus.com/create-pivot-table-from-multiple-sheets/ Thu, 01 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9978 Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.

The post How to Create a Pivot Table from Multiple Sheets in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Import Emails from Outlook to Excel with Power Query https://www.xelplus.com/import-outlook-to-excel-with-power-query/ Thu, 13 May 2021 08:00:00 +0000 https://www.xelplus.com/?p=10112 Learn how to easily export your Outlook emails into Excel. No VBA or Add-ins are necessary. I'll show you how to create a connection to any Outlook folder (or your full inbox) so you can easily import Outlook data to Excel.

The post How to Import Emails from Outlook to Excel with Power Query appeared first on Xelplus - Leila Gharani.

]]> How to Create a Pivot Table Based on Multiple Sheets and Tables https://www.xelplus.com/relationships-pivot-tables-multiple-sheets/ Thu, 29 Oct 2020 17:18:00 +0000 https://www.xelplus.com/?p=10572 This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

The post How to Create a Pivot Table Based on Multiple Sheets and Tables 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.

]]>