If you’re like me and rely on the Outlook search functionality to find emails, having long since given up on organizing emails as they come in.

Leila Gharani shows us how to *really* use Outlook Search to find emails fast.

Search in Microsoft Outlook has improved in 2021.
You can now easily find exactly what you’re look for. In this video I’ll show you how to use Microsoft Outlook’s New Search Box properly. We will learn how to narrow your search criteria for better searches in Outlook. You can use Outlook search for words in attachments, search by email size, by date and a lot more.

We’ll cover the 2 ways to use Search in Outlook: Instant Search and Advanced Search. We’ll also look at important options for Search and why Indexing is crucial for Search to work properly.

In this Excel for Accounting tutorial from Leila Gharani  you’ll learn how to use Power Query to import messy SAP data extracts into Excel.

Importing data from ERP systems like SAP or Oracle into Excel can be a pain. The data is usually very messy. You need to clean and organize the data to be able to use it in Excel reports. In this tutorial I’ll show you 2 practical examples on how you can use Excel Power Query or Get and Transform in Excel to do the work for you. We also create an Excel Pivot Table to analyze the imported data. The great thing with Power Query is that the import is automatic. I

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.