ะ ะตั าะฐัะฐะปะดั 755,885
โ
Download templates and master codes
www.oppadu.com/chatgpt-%EC%97...
๐ChatGPT site (OpenAI)
openai.com/blog/chatgpt/
- After registering as a member on the ChatGPT homepage and getting an API key, anyone can use ChatGPT in Excel.
๐ Take a quick look at key content
01:28 Sign up for ChatGPT and issue API key
24:33 Register ChatGPT payment method and check cost
- When you sign up for OpenAI for the first time, you get $18 credit for 3 months.
- Link Excel and ChatGPT with free credits and apply them to your work! A free $18 credit is enough to generate a report of approximately 400 A4 pages.
- Please refer to the first sheet of the practice file for an explanation of how to apply for the API and the token used for ChatGPT cost settlement.
- For a detailed explanation of the token settlement method, please refer to the OpenAI official website below!
openai.com/api/pricing/
05:13 Ask ChatGPT questions with the xGPT function
05:55 ChatGPT - Changing Randomness (Temperature)
- Temperature (random) is a number between 0 and 1. The closer to 0, the more specific words (answers) are used, and the closer to 1, the more diverse answers can be obtained.
- Therefore, use randomness close to 0 for situations where you need to get a set answer (legal advice, academic report, etc.), and close to 1 for getting various answers (finding ideas, writing poetry, etc.).
08:02 Precautions when using the xGPT function
- When using the GPT function as a function, the function continues to run whenever the sheet value is changed or the file is newly executed, resulting in unnecessary costs and slowing down the file.
- Therefore, it is recommended to use the xGPT function only once.
- If you use the ChatGPT function repeatedly, try using it as a way to run a macro by clicking the button introduced in Example 3! You can use ChatGPT directly in Excel more quickly and conveniently.
08:31 Creating hashtags and KZbin titles with specific keywords
10:14 xGPT_List function, how to use by version
- If multiple items are output as a result of ChatGPT, it is convenient to use the xGPT_List function.
- In the case of Excel 2021 and M365, if you use the xGPT_List function in the same way as the general function, multiple results are divided and output in each cell.
- In the case of versions prior to Excel 2019, after entering the xGPT_List function while selecting a wide range, be sure to write โCtrl+Shift+Enter (array formula)โ!
11:44 Example 3) Extracting key keywords from documents (resumes, etc.)
13:25 Integrating Excel-ChatGPT with a click of a button
- If you use the xGPT_Run function added to the master code, you can complete a macro that runs ChatGPT with just one line of VBA code.
16:55 Example) Analyzing reports such as financial statements and income statements
20:11 Example) Automatic completion of reports and posts by subject/keyword
- In addition, using ChatGPT, you can calculate financial statements and analyze reports.
18:54 Translating in real time with the GoogleTranslate function
- Of the total learning volume of ChatGPT, the proportion of Korean is less than 2%, so you can get more accurate and faster answers by entering Prompt (question) in English instead of Korean.
- Therefore, the GoogleTranslate function, which easily translates between Korean and English, has been included in the master code.
- If you have difficulty using English, try using the provided GoogleTranslate function together! You can use ChatGPT more conveniently.
=GoogleTranslate("Sentence to be translated" ,"Source language", "Target language")
- The source language is automatically recognized if left blank, and the default target language is Korean. Therefore, when translating into Korean, it is okay to enter only =GoogleTranslate("Sentence to be translated").
#ExcelChatGPT #ChatGPTexample #ChatGPTautomation
00:00 Lecture begins
01:28 Sign up for ChatGPT and issue API key
03:02 Setting up Excel โ ChatGPT integration
03:36 Adding Excel Developer Tab
05:13 Example 1-1) Ask a question to ChatGPT with xGPT function
05:55 ChatGPT - Changing Randomness (Temperature)
06:33 Example 1-2) Writing poems, writing formulas, seeking legal advice
08:02 Precautions when using the xGPT function
08:31 Example 2) Creating hashtags and KZbin titles with specific keywords
10:14 xGPT_List function, how to use by version
11:44 Example 3) Extracting key keywords from documents (resumes, etc.)
13:25 Integrating ExcelโChatGPT with a click of a button
16:55 Example 4) Analyzing reports such as financial statements and income statements
18:54 Translating in real time with the GoogleTranslate function
20:11 Example 5) Automatic completion of reports and posts by subject/keyword
24:02 Saving the finished file as a macro workbook
24:33 Register ChatGPT payment method and check cost