Leila Gharani teaches us to pull live stock data in Excel with Stock data types.

With Excel’s stock data feature you can get live stock information. Stock data types allows users to quickly pull stock information into Excel from various exchanges.

In this tutorial I’ll show you how you can pull data related to stocks, bonds, currency, and even crypto-currency such as Bitcoin into your spreadsheet. This way you can easily calculate your portfolio value directly from within Excel. You’ll learn to build your very own stock portfolio in Excel. We’ll use Excel tables together with conditional formatting.
With stock data types you can retrieve stock prices, stock volume, 52 week high, 52 week low, shares and a lot more. If the stock data type is showing you an incorrect stock or the wrong exchange, you can easily change it. I’ll show you how to in the video.

Leila Gharani explores new Excel LAMBDA Function further.

[The Recursive Lambda function] allows you to create your own CUSTOM FUNCTION without any coding.

In this tutorial we’ll take it to the next level and I’ll show you how you can create a RECURSIVE Lambda in Excel. This is a function that’s continuously looping through your data until it reaches a point of exit.

Leila Gharani explains the new Lambda function in this quick tutorial and why it’s a big deal.

Leila Gharani shows us how to do create a calendar in Excel with only one formula.

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 explains how Ideas in Excel work.

Ideas in Excel will provide you with immediate insights about your data. It will help you to quickly create summary reports and high-level visualizations. You can even directly ask it questions about your data using “normal” conversational language. Ideas, is the new artificial intelligence feature built into Excel. It does a really good job in analyzing your data and giving you a summary.

Leila Gharani shows you how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet. In this video I’ll show you a solution that requires ONE single formula. This formula also excludes blank cells on the bottom of the data validation list.

Leila Gharani shows you how to quickly create an automatically sorted Excel bar chart that ALSO lets you hide and show categories on the chart based on a flag in the cell.