Power Excel Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/power-excel/ Bestselling Excel and Power BI Courses Fri, 08 Dec 2023 14:38:36 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Power Excel Tutorials - Xelplus - Leila Gharani - Leila Gharani https://www.xelplus.com/tutorials/excel/power-excel/ 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.

]]> Import Power BI Data into Excel https://www.xelplus.com/power-bi-in-excel/ Thu, 14 Sep 2023 09:00:00 +0000 https://www.xelplus.com/?p=18646 Learn how to export data from Power BI and use it in Excel. The data can be enhanced by Excel and receive updates from Power BI when new data is added to the Power BI Data Model.

The post Import Power BI Data into Excel appeared first on Xelplus - Leila Gharani.

]]> You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query https://www.xelplus.com/power-query-10-hidden-features/ Thu, 24 Aug 2023 15:17:55 +0000 https://www.xelplus.com/?p=17723 Learn 10 of the most productivity increasing "hidden" features of Power Query to take your skills to the next level.

The post You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query 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 Do Many-to-One Side Calculations in Data Models with DAX https://www.xelplus.com/dax-many-to-one-side-calculations/ Thu, 10 Mar 2022 10:00:00 +0000 https://www.xelplus.com/?p=9406 In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

The post How to Do Many-to-One Side Calculations in Data Models with DAX appeared first on Xelplus - Leila Gharani.

]]> DAX CALCULATE Function Made Easy to Understand https://www.xelplus.com/dax-calculate-function/ Thu, 09 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=1491 If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.

The post DAX CALCULATE Function Made Easy to Understand appeared first on Xelplus - Leila Gharani.

]]> 3 Hidden Tips for Excel Power Pivot https://www.xelplus.com/3-hidden-tips-for-power-pivot/ Tue, 30 Nov 2021 08:17:00 +0000 https://www.xelplus.com/?p=9707 These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

The post 3 Hidden Tips for Excel Power Pivot 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.

]]> How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick 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.

]]>