Dropdown Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dropdown/ Bestselling Excel and Power BI Courses Tue, 25 Apr 2023 17:02:54 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Dropdown Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dropdown/ 32 32 How to Improve Data Analysis in Power BI with Slicers https://www.xelplus.com/power-bi-slicers/ Wed, 21 Dec 2022 10:42:00 +0000 https://www.xelplus.com/?p=8862 Power BI Slicers add interactivity to your reports. Managers love to slice and dice. But which Power BI slicers are available? Which should you choose? This tutorial will make you a master in Power BI slicers.

The post How to Improve Data Analysis in Power BI with Slicers appeared first on Xelplus - Leila Gharani.

]]> Create Searchable Drop-Down Lists in Excel with ZERO Effort https://www.xelplus.com/default-searchable-drop-down-lists-in-excel/ Thu, 27 Jan 2022 10:00:00 +0000 https://www.xelplus.com/?p=9525 It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

The post Create Searchable Drop-Down Lists in Excel with ZERO Effort 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 Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Setup Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-dependent-drop-down-lists/ Tue, 08 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10395 Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

The post How to Setup Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Use the Google Sheets FILTER Function https://www.xelplus.com/google-sheets-filter-function/ Tue, 24 Nov 2020 12:00:00 +0000 https://www.xelplus.com/?p=10434 Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

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

]]> How to Create Excel Searchable Drop-Down Lists for Every Row https://www.xelplus.com/excel-searchable-drop-down-every-row/ Thu, 16 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11372 Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row appeared first on Xelplus - Leila Gharani.

]]> Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) https://www.xelplus.com/searchable-drop-down-list/ Fri, 25 Jan 2019 16:16:00 +0000 https://www.xelplus.com/?p=12998 This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) appeared first on Xelplus - Leila Gharani.

]]> First Excel Hash Challenge between 6 MVPs https://www.xelplus.com/excelhash_1/ Tue, 04 Sep 2018 08:33:00 +0000 https://www.xelplus.com/?p=10431 This Chick's Trouble is my recipe for Excel Hash. It includes the FREQUENCY & MAX functions, 3D Models & Form Controls. You'll be surprised what comes out...

The post First Excel Hash Challenge between 6 MVPs appeared first on Xelplus - Leila Gharani.

]]> Expandable Conditional Drop Down Lists in Excel https://www.xelplus.com/excel-dynamic-dependent-drop-down-lists-exclude-blanks/ Fri, 20 Jul 2018 07:16:00 +0000 https://www.xelplus.com/?p=10085 Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

The post Expandable Conditional Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

]]>