Filter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/filter/ Bestselling Excel and Power BI Courses Wed, 08 Nov 2023 10:16:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Filter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/filter/ 32 32 Excel’s TAKE Function – Real World Examples https://www.xelplus.com/excel-take-function/ Wed, 12 Jul 2023 14:56:00 +0000 https://www.xelplus.com/?p=17473 Learn to properly use Excel’s TAKE function. With TAKE you’ll be able to extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction in combination with other Excel functions.

The post Excel’s TAKE Function – Real World Examples appeared first on Xelplus - Leila Gharani.

]]> Power BI – How to add Drill Through to Reports https://www.xelplus.com/power-bi-drill-through/ Thu, 17 Nov 2022 10:00:00 +0000 https://www.xelplus.com/?p=9171 Power BI’s Drill Through is a special filter that takes you from the overview page to the cross-filtered details page of the report. Learn how to set it up so that you're never taken by surprise during a presentation with requests to drill deeper into data.

The post Power BI – How to add Drill Through to Reports appeared first on Xelplus - Leila Gharani.

]]> How to Mail Merge from Excel https://www.xelplus.com/mail-merge-from-excel/ Thu, 22 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10143 Mail Merge is what you need if you'd like to create multiple letters, emails or documents with data from Excel. This way you can easily create invoices for your customers or send bulk personalized emails. You'll learn how to quickly get started with Merge. Merge and save a ton of time.

The post How to Mail Merge from Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets IMPORTRANGE Function https://www.xelplus.com/google-sheets-importrange/ Tue, 22 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=9021 Learn how to use IMPORTRANGE in Google Sheets. You can also use it together with QUERY to import and append data from multiple sheets. IMPORTRANGE is great when you'd like to import data from other spreadsheets.

The post How to Use Google Sheets IMPORTRANGE Function appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets Filters & Filter Views https://www.xelplus.com/google-sheets-filter-view/ Tue, 03 Nov 2020 13:08:00 +0000 https://www.xelplus.com/?p=10558 Learn how to use Filter and Filter Views in Google Sheets. A Filter View is really easy to create. Plus, you get to sort your data without changing the original sort order.

The post How to Use Google Sheets Filters & Filter Views appeared first on Xelplus - Leila Gharani.

]]>