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 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.