Leila Gharani shows you how to to enable the Developer Tab, which allows you to record and run macros.
Leila Gharani shares here favorite and hidden Windows 10 tips and tricks.
Leila Gharani shows us how to combine Microsoft Excel with Power Automate to get more done
In this post from Leila Gharani, you’ll learn how to successfully teach online with Microsoft Teams. You’ll keep your students engaged and as teachers you can stay organized. Also if you’re thinking of taking your classes online, make sure you go through my list of important tips. The list of Teams tips is based on what I learnt teaching classes online. This will make distance learning more fun and easy to manage.
If you’re a teacher and you use Microsoft Teams for distance learning these tips will help you keep your students engaged and to stay organized.
Time Stamps
- 00:00 Top Tips for Teaching Using Microsoft Teams
- 00:34 Launch Polls from a Teams Meeting
- 02:52 Use Together Mode in Microsoft Teams
- 03:42 Disable Chat During a Teams Meeting
- 04:37 Annotate Your Screen in Teams With ZoomIt
- 06:30 Use 2 Devices to Check Student’s Experience
- 07:29 Download the Attendance List in Teams
- 08:02 Use the Whiteboard in Microsoft Teams
- 09:01 Check Assignment Options in Teams
- 11:24 Change Default Assignment Settings in Teams
- 12:18 Hide Student Names for Anonymous Grading in Teams
- 13:01 Wrap Up
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 shows us how to use Microsoft Power Automate to easily automate repetitive and boring tasks.
With Power Automate you create automated workflows that can be triggered based on an event, a schedule or manually triggered by you.
Not only does Power Automate save time, but it can generate reports that help you and your team be more productive and streamline business processes.This Power Automate tutorial is great for beginners!
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.