Microsoft Copilot Course Section 18 Generate Excel Formulas

SimpleTutorials

Microsoft Copilot is a text-based generative AI tool that can do various tasks. In this course, you will learn how to write prompts, generate content, generate codes and utilise its powerful features in the web version of Microsoft Copilot.   In this video lesson, we will learn about Generation of Excel Formulas in Microsoft Copilot.  You can access the entire Microsoft Copilot Course in the following playlist: https://www.dailymotion.com/playlist/x8rnke

Transcript

00:00So let's say you want to go ahead and then generate out a formula for

00:09Microsoft Excel. So Copilot can be handy for generating the Excel formulas that

00:15you don't know. Let's say for example I'm simply going to go around and say this

00:20I am going to enter a MOX in Excel sheet cell A1. Write a formula so

00:33that the MOX I entered gets converted into grade right here just like

00:44this. So if I were to go around and do that then what happens is that it'll

00:47simply give me the grade right here. So you can see that I didn't mention like

00:54for which MOX how much grade is to be assigned but it simply goes around and

00:59then gives me this formula where above 90 is A and then above 80 is B above 70

01:04is C above 60 is D. If you want to be specific you can do that as well but

01:09let's just go around and say do add conditions to add A plus A minus minus B

01:20plus B minus and so forth as well. So let's just go around over here and do

01:27that then what happens is that it'll simply go ahead and give me that formula

01:31right here. So now you can see that I got A plus A A minus B plus B B minus C plus

01:38C minus D plus D D minus and so forth as you can see right here. Let me just go

01:43ahead and copy out this formula right here and I'm going to go around onto my

01:47Excel sheet right here. So it's taking A1 as the cell reference so I can simply go

01:53around and paste this anywhere and then right now it's F because the MOX is not

01:57entered but if I were to go around and enter 55 it just goes around and in A1

02:03right here. So let's just go around and see now it's still F because above 6

02:08above 60 is only POSMOX. So 65 is D as you can see right here. 75 is a C right

02:14here. So let's go for 80 right here that's a B minus and then 85 right here

02:19that's B and then let's go for 89 right here that's a B plus and let's go for

02:2499 right here that's an A plus. 94 is an A and so forth as you can see

02:30right here and this is how you can utilize Microsoft Copilot to generate

02:35Excel formulas for you easily. So hope you found this video useful so be sure

02:39to comment on what you think about it. Be sure to hit the like button and don't

02:44forget to share this out with your friends and family and for more contents

02:48like these do follow simple tutorials.

Category

Transcript

Recommended