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.
[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 shows us how to use Microsoft Forms you can collect data from different people via fillable forms that you can control from Excel.
With Microsoft Forms you can easily create surveys, quizzes and polls. You can export the data to Excel to analyze and share the results with your audience. No programming is necessary, no VBA, no add-ons. Just a Microsoft 365 account (free or paid).
We’ll cover how you can use Microsoft forms to add dropdowns, multiple choice, calendar date selection, number checks, net promoter score, and even star ratings.
00:00 How to Use Microsoft Forms
01:19 How to Get Started with Microsoft Forms
01:50 Automatic Connection between Excel and Microsoft Forms
02:58 Create Data Entry Form with Microsoft Forms
04:10 Star rating in Microsoft Forms
04:35 Choice in Microsoft Forms
05:08 How to add a drop-down to Microsoft Forms
06:10 Date picker with calendar pop-up
06:30 Add a text box and validate numbers
06:50 Add a Likert scale to Microsoft Forms
07:15 Net Promoter score in Microsoft Forms
07:50 How to Add a Theme to Microsoft Forms
08:09 How to Share a Data Entry Form with Microsoft Forms
09:24 How to Fill Out a Data Entry Form
10:34 Analyze the Responses from Microsoft Forms 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.
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
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.
Most of us take notes in some way or another – on a piece of paper, in a notebook, or with some app. But are your notes always readily available when you need them? And more importantly, can you easily find a specific note you’re looking for?
I tried a lot of note-taking systems in the past and I can’t tell you how many great ideas were lost over the years because I just couldn’t find the piece of paper anymore, I scribbled some notes on. It wasn’t until I found a way to use Microsoft OneNote effectively that it changed for the better. Many people don’t know that OneNote is much more than just a digital notebook.
In this OneNote tutorial (in 2020), I explore how you can take full advantage of OneNote, and share my 5 personal OneNote tips and tricks on how you can become more organized.
01:46 Use Hierarchies to Get Organized
04:37 Use Tags to Find What You Need
07:04 Capture Ideas Anywhere With Sticky Notes
08:23 Extract Text From Images
09:35 Focus With Immersive Reader
11:04 Additional features in OneNote you may find helpful (Ink to Shape, Ink to Text, Ink to Math)