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

Top Excel Functions for Engineers

Leila Gharani — Thu, 23 Dec 2021 10:00:00 +0000

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

Office 2021 – New Functions and Enhancements

Leila Gharani — Thu, 14 Oct 2021 08:10:00 +0000

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

The post Office 2021 – New Functions and Enhancements appeared first on Xelplus - Leila Gharani.

Use Outlook Search the Right Way

Leila Gharani — Wed, 10 Mar 2021 08:33:00 +0000

Outlook Search feature has improved! If you use it correctly you can find exactly what you're looking for. You can even search for words inside attachments! Read the full article to learn how to use Outlook Search correctly.

The post Use Outlook Search the Right Way appeared first on Xelplus - Leila Gharani.

Google Sheets vs. Excel – Is Google Sheets Better?

Leila Gharani — Thu, 24 Sep 2020 09:00:00 +0000

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

The post Google Sheets vs. Excel – Is Google Sheets Better? appeared first on Xelplus - Leila Gharani.

How to Create Excel Searchable Drop-Down Lists for Every Row

Leila Gharani — Thu, 16 Apr 2020 09:00:00 +0000

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.

Excel Function to Check IF a Cell Contains Specific Text

Leila Gharani — Sat, 01 Jun 2019 22:31:00 +0000

How can you use wildcards in Excel's IF Function - with this method you can easily check for a partial text match. It's a clever method to get the IF function to check if the cell value contains a word.

The post Excel Function to Check IF a Cell Contains Specific Text appeared first on Xelplus - Leila Gharani.