Named Range Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/named-range/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 00:55:04 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Named Range Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/named-range/ 32 32 How to Create Excel Interactive Charts with Dynamic Arrays https://www.xelplus.com/excel-da-dynamic-sorted-chart/ Thu, 19 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11421 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 https://www.xelplus.com/generate-barcodes-excel/ Thu, 06 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11492 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 https://www.xelplus.com/excel-calendar-with-holidays-and-appointments/ Mon, 30 Dec 2019 14:10:00 +0000 https://www.xelplus.com/?p=9328 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.

]]> Excel Dependent Combo Box Solves an Annoying Problem https://www.xelplus.com/dependent-combo-box/ Sat, 08 Dec 2018 01:41:00 +0000 https://www.xelplus.com/?p=9841 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 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.

]]> Lookup on Pictures in Excel https://www.xelplus.com/excel-lookup-on-pictures/ Tue, 12 Jun 2018 09:15:00 +0000 https://www.xelplus.com/?p=10270 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.

]]>