Leila Gharani explores the new LET function in Excel.

Excel’s new LET function can make your formulas easier to read and it can improve the performance of your formulas so they run faster. This applies to formulas that use the same expression (e.g. formulas, values) multiple times.

Time Stamps

  • 00:00 Why use Excel’s LET function
  • 01:07 Availability and Syntax of Excel LET Function
  • 03:12 Example of LET Function with IF Conditions
  • 06:53 Example of LET Function with Multiple IF Conditions and Symbols
  • 08:55 Does Excel LET Function REALLY Improve Performance?
  • 11:03 LET Function with Excel Dynamic Arrays
  • 14:46 Performance of Excel LET Function with Dynamic Arrays

In this video Leila Gharani covers the Best 6 FREE Excel Add-Ins to improve your reporting, data analysis and make your life a LOT easier.

Time Stamps:

  • 00:00 Best FREE Excel Add-Ins
  • 00:55 How to Install Add-Ins in Excel
  • 01:45 QR4Office
  • 02:47 Web Video Player
  • 03:41 Visio Data Visualizer
  • 07:16 People Graph
  • 09:14 Mini Calendar and Date Picker
  • 10:49 Bing Maps

Leila Gharani explains why PowerQuery is such a powerful tool.

Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform. Unfortunately many people haven’t explored what it has to offer! They continue doing things the old “manual” way, Or the “complex” way with difficult formulas.

Leila Gharani shares a unique Excel formula.

It’s safe to say this Excel formula syntax has NEVER been seen before. My team and I, did an extensive search on this mysterious Excel formula syntax, but found no information about it. It’s a super short formula in Excel to count cells with text and ignore blank cells, numbers and also formula cells that result in blank cells or empty strings.

This is one of a kind Excel formula hack.