Hello, this is Daily A. Today, I have prepared a series to talk about how to use generative AI effectively with you step by step. Today is the first episode, and the topic we will cover is about how to become the best employee using generative AI. Instead of Excel, we will discuss how to use GPT-4 Omni. I wrote that it's a free version, and indeed, you can use the free version, but it's better to use the paid version if possible because there are some differences. I will explain each point one by one. So, the explanation will go in this order. First, I will explain how to use GPT-4 Omni for free. Many people didn't know that you could use Omni for free, and I recently found out why that was the case. Secondly, you can start using GPT instead of Excel. There have been many tutorials on this, and I have also used them in the past.

One of the methods is to connect the content issued by the GPT API to the Excel you use and incur costs later when asking various things. But honestly, to tell you the truth, it's quite cumbersome. There are some advantages, but now let's stop it and if you simply want to create an Excel as you originally wanted, or if you have Excel formats already available and ask someone good at Excel to do it for you, now we will ask GPT for this. It will be much easier, right? For this, there are some preparatory materials, so let me explain this once. Today, through a simple practice, we will do it together. The practice will be divided into three parts. We will be able to change the data into existing Excel functions, as I mentioned a while ago.

I will do what you ask, second, things that can get insights, third, through a simple test, we will put a receipt and try organizing the contents in this picture into a table using the OCR function. Once you have mastered this basic skill, you may be somewhat relieved from many Excel tasks that you need to do starting tomorrow. However, there is something to be careful about. The fact that we are using GPT itself is a concept of teaching it, so when using it for company purposes, you should definitely consider security issues. Now, let me start by showing you one thing. Here, I have one GPT open. If you look at it, as you can see, I am using the free version of GPT. Then, it says GPT Plus Upgrade. It's the free version that I have been using so far.

Can you see the difference in this? The difference was that we couldn't attach a file at the bottom. What does this mean? Those who have been attending our lectures or watching our YouTube videos continuously have probably been using GPT for free. I also have an account that I use for free, and when I log into that account, it shows GPT 35 right away. It doesn't show up like this, and there's no option to attach a file at the bottom. Oh, I see. Why couldn't this be used? When you log in with your existing account, I don't know why, but for those who use existing accounts, GPT Omni cannot be used. Those who create a new account and log in can start using it from then on. It's a bit strange, right? That's why, even though it's a bit of a hassle, for those of you who want to try out the Omni feature for free, you should create a new account.

You need to sign up as a member, so creating an email account isn't difficult, so make one more and then go ahead and sign up. If you do, you will see the display like the one below, so you can see it. Now that you are ready like this, then what's different exactly, see GPT comes out like this, and in the free version, when we show the paid version, you can choose from 3.54 Omni, three options are available. This means that in the free version, this GPT is provided as the basic Omni. So, when a certain limit is reached, then you can no longer use it from that point on. I wondered why this was happening, and it turns out they limit the capacity and usage, so after using it for a bit, if the functionality seems good, then you might consider upgrading right away. So, I was doing a few Excel tasks before preparing today's content.

I tried it once, but the usage was a bit lower than I thought. So first, please take a look visually at where we are now, and then I will show you how to use the paid features from here onwards. The reason I mix paid and free features in my explanation is that the policy of the open-source GPT itself is gradually providing many features that paid users used to free users as well, so you can benefit from it. It would be good to know in advance. Also, temporary chat means that if you leave it on, the conversation will not be saved due to the concept of non-accumulation. Let's go through it step by step. First, you need to log in to prepare. You had to do that once you enter with a free account and activate it. Secondly, you need to be clear about what you should ask him.

I think there should be a sample. In my case, I have prepared a sample like this now. I brought the English, math, and Korean grades of the students, which are random. And I'm going to put in the data. As you can see, I have dragged and dropped it into the spreadsheet. Okay, one more thing I'd like to mention. When you work like this, if you upload a file written in Korean, errors often occur. So, please do not upload a file written in Korean. Just create a file lightly like what you see on the screen and upload it. Now that the sample has been uploaded, next, you should give instructions to him. When we use Excel, the way to use GPT is to show this to someone who is good at it, not to ask another friend. First, we need to give it a name. This file is a student's grade table, laid out like this.

Please create a new column for the average score of each student and add it next to the average score. Now, let me ask you for the second task. The ranking of the student with the highest average score should be indicated as 1 based on the newly added column of rankings. Let me ask you for only these two tasks. And for the third task, I will ask for one more. Let's just do it like this. Press the Enter key and wait. Alright, the data is being analyzed. This is a feature available in the Euro version that is provided instantly. It can be used in the free version as well. Let's wait a bit. I will show you the added data like this. This alone makes it more accurate. I provided the data here instead of inserting it into the spreadsheet. So, all you have to do is drag this and paste it back into Excel. Normally, functions should be included here.

The biggest advantage is that you don't need to use the function right now. In the future, we might not need to know functions well for real Excel data. I wanted to ask for a file, and it kindly says, I will save it as a file. This is one of the new features in GPT, you can download it. Let me try clicking on it. In the free version, there may be errors, but let's try. When the file is downloaded, it says it couldn't retrieve the upload status. It seems like there was a little haste here or maybe it's still unstable. So far, we have covered up to this point. It has given the average scores for English, Math, and Korean, and has also given the rankings. Next, I will show you one more sample. If you look at the sample, I have separated the midterm and final exam scores.

Calculate the average for the mid-term exam scores, then calculate the final exam average. After that, calculate the overall average. Then, please indicate the rankings. It has become a bit complicated, so let me try it once. Do you remember what we did earlier? First, let's remove the English as a sample. In this state, now I will drag and drop it. Yes, you can also create three windows and paste it there. I will paste it. I will say the same thing. This data consists of students' mid-term and final exam scores. Calculate the mid-term average to create a column called Mid-term Score. Calculate the final exam average to create a column called Final Exam Score. I'm asking you to do two things. Lastly, add up the mid-term and final exam scores to create a column called Total Score. I've asked you to do three things. And what I mean is, create a new column for rankings starting from the highest score in the total score.

Let's try adding one more tone. Please rearrange it in order from first place to last place. I somehow feel like I might exceed the usage limit with these five things I'm ordering, but let's give it a try. I will press the atmosphere button in this state. Let's wait. If the usage exceeds, it should show that it has exceeded, but looking at it now, it seems to have already come out. It shows like this when the data analysis limit is reached. It suggests upgrading to HPT Plus or trying again after 10 a.m. tomorrow. As I am filming at the moment, it's already around 10 p.m., so I think the limit is set for 12 hours. But don't be disappointed because it will gradually improve. So, I will copy the content as it is now. I will show you how it improves in the paid version in the future. Let's move on to the paid version. I have just executed GPT-4 Omni. It's the same.

Let's insert the file here now. This is a sample tool, and we will insert it like this. Press the Enter button after doing the same. When you click the Preview button, it will be possible right away. Oh, you can already see the changes, right? It wasn't interactive until yesterday, but now it's interactive again. Now, as we wait, it will start the analysis. Well, it can be a bit tedious, but it can't be helped. As I see it, it says that it has calculated the grades, ranks, and displayed the sorted results. Is it really over already? Let me check. If it's not properly finished, additional instructions have appeared, so let's do it again. Let me ask for the link address to download the content above. Let me try this once. You can click here to download it, but since the table has been downloaded, now.

I have given you the link. If you click on it, the file will be downloaded now. Chae-chi will allow it. Since the file has been downloaded, let's open it. It will be opened as an Excel file. Now, let's take a look at the data in the Excel file. Let me show you what I have brought. It looks a bit different from what you see on the screen, right? As I mentioned, it's exactly as it should be. If you look now, from student Jang Min-seo to student Jo Ju-won, they are all displayed, and on the far right, the total scores have been calculated, and the rankings have been rearranged. Now, So-ra has moved to the top. Originally, in the original source, Kang Seo-yeon was at the top, but when you see this, it means that Jang Min-seo has been automatically arranged. So, if we had done this manually, you would see the details for each score. Look at the midterm scores.

Kim and Jeom went into a comprehensive store. Each of these, you should normally use functions, but you don't have to. If you don't like the decimal point, you can ask to remove some decimals. Then, let's try one more thing from this point. I will do more. Additionally, you don't need to upload the file now that you know. From the information above, mark in red the five students whose final exam scores decreased the most compared to the mid-term exam scores. This is one task. The second one is like this: remove the decimal points from the average scores and create the data again. This is how it will be done. This time, I won't ask for a download file, but let's see if it will be given directly. From the information above, I asked to mark in red the five students with the lowest scores among Kim and Jeom compared to the mid-term exam. I removed the decimal points from the average scores and created the data again.

Since I asked for it, will it come out? Well, of course, the GPT function in Excel throws out the compiler in the same case, so you can just ask right away, which is convenient, but there are still some limitations. Korean recognition is like that too. But this progresses very quickly, so what I was talking about is, let's ask someone else who is good at Excel. Let's try loading the file again. I'll open it. It should come out correctly. If it doesn't come out correctly, I might need to check it again. I brought it. Now looking at it, oh, it seems like it didn't quite recognize the content about removing decimals from the average score. And when I asked to look at the friend whose score has dropped a lot, it's showing now. So now, for example, student number 5, the midterm score was 90, but the final exam score dropped to 63. As we go down, there will be other scores as well.

Oh, you can see what you can check like this. I just tried it briefly now. When you actually submit grades, you don't submit them like this. But if you utilize this method, starting from various sales data, everything becomes possible. Isn't this amazing? We specifically asked for it to be entered in Korean, and even though we inputted in Korean, it automatically ranked and provided a comprehensive score in Korean. It's truly amazing. So, let me add one more thing now. What do we need? Now, it seems like we need insights. Insights are about visualizing things, right? Based on this content, when counseling students about their scores, draw the insights needed for counseling on a graph and add a new sheet. Now, I'm giving you another difficult task. Draw insights that can be considered here on a graph and then add them to a new sheet.

I asked for it, but actually, when I ask you to draw a graph, it's not just asking you to draw it. In the case of grades, there is a separate distribution chart. In our charts, there are bar charts and ones that are in slides, various types, right? If you give accurate instructions, it comes out accurately. But for now, I'll let him try roughly what he can think of. Let's download it again. Press it and wait. When you wait, oh, he explains again. There is content asking if each individual student wants a graph, but I haven't asked for that yet. Let me ask for one more. I'll bring it. Let's see. It's the same as before. No, one more sheet has been added. Here, the sheet wasn't added before, but the Insights sheet has been added. Let's see. Press it and see. Oh, it matches like this. Like this, scoring.

I've created a distribution chart. The midterms are final, so I just showed how the grades have changed. But when I look at it, I'm not quite satisfied. It's in English. Let's change this to Korean and classify students who need counseling to provide insights. For students who have significantly dropped in grades, I will create counseling charts for three students highlighted in red. I will create graphs for each of them and add them to the sheet. So, I will ask you to do it like this. So, what I'm thinking now is, if I pre-order these things, it should be okay. I'm showing you the tests we've tried. Doing real work means thinking continuously about whether there are any meaningful data here, rather than wasting time doing Excel grunt work. It's about giving and receiving insights through continuous thinking. But now there is a problem.

If you keep using them, they tend to consume a lot of data, so usage will probably continue to increase. Let me check what I just made. I made three. The insights are the same as before because you didn't ask for any changes, but there are three new friends, Junwoo, Junsoo, and Joohee, so let's try pressing it. Oh, it's out. I informed you like this, but now there is a problem. What's the problem? The names are not displayed in Korean, instead, they appear like ddang ddang ddang. This happens because most graphs are displayed like this. It's not applied correctly. There is a solution. When you use GPT, you need to download it. If you have the file, you need to purchase it and download it to install it. Originally, these are meant to be used in Python.

Now, there's no need for that. If I'm already downloaded, as you can see, just drag and drop this one, then install this file for Korean fonts, and then re-create the graph so that the text doesn't break. Let's do it like this. By doing this, you will automatically install it, but there is one problem. After updating GPT that you are using, you cannot continue to use it persistently. Instead, you need to create a new dialogue window, so you have to install it in this way once. It takes a little time to install. Let's organize the work. It's a bit disappointing, right? What it means to exchange data several times is that it uses tokens to express it. Analyzing with GPT requires the use of tokens, so the number of tokens increases.

Oh, I've heard that those who are good at Excel are using it a lot. Originally, it was 29,000 won, right? The price has gone up a lot, but I suggest boldly purchasing it once and trying to use it for about a month. It can reduce your waste of time and allow you to leave work early. If you say that saving time is the most important thing, I think what we need to save is not money but time. Now, the final learning data has come out. Let's take a look. Let's see if Korean is applied correctly now. Since we inserted the font, let's bring it back and stretch it out. Let's see. It came out correctly now, right? Kim Junwoo, it came out like this before. Oh, another one came out. It's at the back. It was showing Junwoo's midterm and final scores in English before, but now it's displayed accurately in Korean. Math came out there, and Junseo is the same, and Joji, these three.

Everything is out now. In the case of Insight, in a run-style, so if you need a Korean font, let's download the file and use it. We will put this directly on our YouTube channel. Even if I only do this much, I think it's really okay. So, let me show you one more thing, that you can use Excel instead of GPT-4. If you have any more questions next time, such as doing macro tasks, we will prepare a lecture or video for you. Now, let me take care of the receipts. Well, these are the ones I took pictures of earlier. It's like this, things I ate at McDonald's, things like that. Attaching three receipts at once means that multiple pictures are attached. What does this mean? If you have one, two, or three different formats in Excel data,

After putting it in and setting the criteria, you can receive organized data all at once when you provide the standard values. Since you can exchange this through conversation, keep thinking about it. Oh, I'm a master of GPT and Excel. We are asking a friend who is an Excel expert to help us. Let's go. We are trying to organize each receipt into an Excel file. Just writing like this is enough, but you need to specify the content. What kind of content should be included? Date, and provide it. Purpose, amount, usage details, make it possible for the amount to be organized. Let's try it once. What this function does is when you upload the content you took a picture of to GPT, it recognizes the Korean text in the picture and then we can see if we can create a table. Let's wait and see. It says it's analyzing. The speed seems different each time. GPT-4, why are you so slow? People who think like this are not happy.

Think about last year. Last year was the same. Even when GPT was first introduced last year, it was very slow. But now, I think it's getting a little better. When we look at the data on the Korean language, there seems to be some issues now. Okay, when this happens, we need to analyze the file again. Let's do it again. Now, let's wait and see. It says a summary has been done, and it mentions that it can be downloaded. It seemed like they couldn't provide it, but then it seems like they did. Let's check if it came out in English or Korean. Yes, it says GPT does this and that. Don't be disappointed if it doesn't come out right away. Just wait and wait and wait and wait, and it will be created. Now it's out. It's in Korean. If we look at it, it has been released. The date is there, and the usage information is also there.

The receipt from the restaurant came out. Parking fee was listed, and it was shown in English. The total amount is 32,800 won. It says I spent 5,000 won and 1,200 won. It's really great. These things can help reduce the manual work in Excel. I actually went to Hong Kong and visited places like this at the end. Of course, it was listed as Suwon Jeongja Branch. What a waste. Oh, that's right. I went to the comic book store earlier and spent money there, so it's well organized. If there are errors in the death penalty, you can check it. Above all, cross-checking is necessary once. Nevertheless, reaching this level, I'm not a heavy user, but as someone who uses Excel lightly, I think this is the best. As I mentioned, you can stop connecting to Excel's API now, and instead of Excel,

I think you can use GPT. Although you can use the free version on GPT-4, I clearly mentioned that since the usage is not large, in order for you to use it properly, it is necessary to switch to the paid version. However, at the current level, because it is May now, it hasn't been long since Onni was released, and I think as OpenAI earns more money, they will gradually increase the number of free users. So, I've told you this much for now. For those who have paid for GPT-4, please continue to use Excel starting today. I hope that Onni AI becomes the best tool for daily use, and next time, I will introduce one by one what additional features would be good to add for more fun. Thank you. This was a daily story. Have a good day.

미.쳤.다! 엑셀 대신 GPT4o 로 함수추가, 데이터 분석 60초내로 끝내는 법! API 연결필요 없음, GPT 옴니 무료 사용법_이게 진짜 엑셀 자동화!

일상에서 만나는 IT 이야기들. 재미있는 제품들. 관련된 이야기들을 전합니다. 
세컨드브레인연구소 홈페이지(강의 문의 및 제휴) www.secondbrainlab.com
광고 및 제휴 문의 sblab@secondbrainlab.com