Name Manager Archives - Xelplus - Leila Gharani

5 Hidden Excel Features for Busy People

Leila Gharani — Fri, 08 Dec 2023 14:38:35 +0000

Learn five amazing time-saving features in Excel that you likely have never tried or even knew existed. Turn hours of work into seconds.

The post 5 Hidden Excel Features for Busy People appeared first on Xelplus - Leila Gharani.

Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor)

Leila Gharani — Fri, 04 Mar 2022 12:31:00 +0000

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel.
It's a "new" version of Name Manager and hopefully it could replace Name Manager in the future.

The post Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor) appeared first on Xelplus - Leila Gharani.

How to Use Radio Buttons in Excel to Create Interactive Dashboards

Leila Gharani — Thu, 17 Jun 2021 08:00:00 +0000

Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Radio Buttons in Excel to Create Interactive Dashboards appeared first on Xelplus - Leila Gharani.

How to Create Excel Interactive Charts with Dynamic Arrays

Leila Gharani — Thu, 19 Mar 2020 10:00:00 +0000

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

The post How to Create Excel Interactive Charts with Dynamic Arrays appeared first on Xelplus - Leila Gharani.

How to Read and Create Barcodes in Excel

Leila Gharani — Thu, 06 Feb 2020 10:00:00 +0000

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Read and Create Barcodes in Excel appeared first on Xelplus - Leila Gharani.

Create an Excel Calendar with Holidays and Appointments

Leila Gharani — Mon, 30 Dec 2019 14:10:00 +0000

Download this free Monthly Excel Calendar with holidays and appointments. It automatically adds standard holidays like Easter and New Year's - you can also use it to keep track of your appointments.

The post Create an Excel Calendar with Holidays and Appointments appeared first on Xelplus - Leila Gharani.

How to Find Formulas that use External Links in Excel

Leila Gharani — Thu, 24 Oct 2019 09:00:00 +0000

Get a list of all your external links in your Excel file with a trick that combines the past with the future. This way you can make sure all your links are pointing to the right files.

The post How to Find Formulas that use External Links in Excel appeared first on Xelplus - Leila Gharani.

Excel Dependent Combo Box Solves an Annoying Problem

Leila Gharani — Sat, 08 Dec 2018 01:41:00 +0000

Combo boxes are a good alternative to data validation drop-down lists in Excel. Learn how to create a dependent combo box in Excel. This combo box ends up solving an annyoing Excel "reset" problem.

The post Excel Dependent Combo Box Solves an Annoying Problem 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.

Excel INDIRECT Function

Leila Gharani — Tue, 28 Mar 2017 11:51:00 +0000

The INDIRECT() function comes very handy when need to feed different ranges to certain formulas, especially when you refer to ranges in other sheets. This tutorial explains how the INDIRECT() function works and how to use in a real-life scenario, gathering data from different tabs.

The post Excel INDIRECT Function appeared first on Xelplus - Leila Gharani.