List Archives - Xelplus - Leila Gharani

Create Searchable Drop-Down Lists in Excel with ZERO Effort

Leila Gharani — Thu, 27 Jan 2022 10:00:00 +0000

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.

Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values)

Leila Gharani — Thu, 29 Jul 2021 08:00:00 +0000

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 Use Checkboxes in Excel

Leila Gharani — Thu, 15 Jul 2021 08:00:00 +0000

Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas or conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

The post How to Use Checkboxes in Excel appeared first on Xelplus - Leila Gharani.

How to Use Microsoft Teams for Teachers

Leila Gharani — Tue, 09 Mar 2021 23:54:00 +0000

This Microsoft Teams guide for teachers, highlights 10 important features and tools of Teams for Education. These quick tips will make distance learning easier for teachers and students.

The post How to Use Microsoft Teams for Teachers appeared first on Xelplus - Leila Gharani.

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)

Leila Gharani — Fri, 25 Jan 2019 16:16:00 +0000

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.

Expandable Conditional Drop Down Lists in Excel

Leila Gharani — Fri, 20 Jul 2018 07:16:00 +0000

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.

Lookup on Pictures in Excel

Leila Gharani — Tue, 12 Jun 2018 09:15:00 +0000

Create impressive Excel reports by adding a dynamic lookup to your image. This way, every time a cell value changes, your image changes. Download the Excel Workbook and use it to quickly get started.

The post Lookup on Pictures in Excel appeared first on Xelplus - Leila Gharani.

Data Validation in Excel

Leila Gharani — Thu, 10 May 2018 16:46:00 +0000

Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation in Excel appeared first on Xelplus - Leila Gharani.