Formulas Tutorials - Xelplus - Leila Gharani - Leila Gharani

Excel’s Checkboxes Are Incredibly Cool! Here’s why

Leila Gharani — Tue, 21 Nov 2023 16:18:58 +0000

Excel's new Checkbox feature makes lists and interactive reports easier than ever. See how to add, customize, and use the new checkbox feature in a creative and interesting ways.

The post Excel’s Checkboxes Are Incredibly Cool! Here’s why appeared first on Xelplus - Leila Gharani.

Insert Image in Excel Cell (and Lookup Images)

Leila Gharani — Tue, 26 Sep 2023 14:58:44 +0000

Learn how to use the new "Image in Cell" feature in Excel to store and lookup images from cells.

The post Insert Image in Excel Cell (and Lookup Images) appeared first on Xelplus - Leila Gharani.

Number Rows in Excel – Dynamic Solution with SEQUENCE

Leila Gharani — Tue, 26 Sep 2023 14:08:36 +0000

Learn how to create self-numbering lists for Excel tables and traditional lists using the SEQUENCE function.

The post Number Rows in Excel – Dynamic Solution with SEQUENCE appeared first on Xelplus - Leila Gharani.

Excel Find and Highlight Duplicates

Leila Gharani — Thu, 24 Aug 2023 15:12:21 +0000

Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

The post Excel Find and Highlight Duplicates appeared first on Xelplus - Leila Gharani.

How To Use Excel FILTER Function With Multiple Criteria

Leila Gharani — Thu, 24 Aug 2023 15:02:59 +0000

Learn to use Excel's FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

The post How To Use Excel FILTER Function With Multiple Criteria appeared first on Xelplus - Leila Gharani.

Excel’s TAKE Function – Real World Examples

Leila Gharani — Wed, 12 Jul 2023 14:56:00 +0000

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.

How to Use TEXTBEFORE and TEXTAFTER Functions in Excel

Leila Gharani — Mon, 24 Oct 2022 07:48:00 +0000

Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want.

The post How to Use TEXTBEFORE and TEXTAFTER Functions in Excel appeared first on Xelplus - Leila Gharani.

Excel VSTACK Function – The One Excel Formula to Append Them All

Leila Gharani — Thu, 26 May 2022 23:55:00 +0000

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

How to use Excel’s LOOKUP Function

Leila Gharani — Thu, 05 May 2022 08:00:00 +0000

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

The post How to use Excel’s LOOKUP Function appeared first on Xelplus - Leila Gharani.

How to Properly Use the Excel TEXTSPLIT Function

Leila Gharani — Thu, 31 Mar 2022 08:00:00 +0000

Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

The post How to Properly Use the Excel TEXTSPLIT Function appeared first on Xelplus - Leila Gharani.