Maximizing Conversational Efficiency: Harnessing the Power of Excel’s SUM Function for ChatGPT
1-Visit https://chat.openai.com/ and sign up for an OpenAI account.
Setup an OpenAI account by clicking the “Sign Up” button.
Select your email or Google or Microsoft account you want to log in with.
Allow OpenAI to access your account
Verify you are a human
Verify your name, email address and phone number
2-Then you will be able to use ChatGPT with the following landing page.
USE EXCEL FOR CHATGPT FOR SUM FUNCTION
You can use ChatGPT to help find the function you’re looking for. In this case, you will be trying to find a
function to add together the revenue across all markets- the Excel SUM function.
1-Open an Excel workbook to follow along and open tab 1: Sum
2-Open ChatGPT.
3- Type an Excel question “Write an Excel formula to add up values in cells B2 to B10” and click Go.
4-See the response from ChatGPT, in this case “=SUM(B2:B10)”
5- Copy the function. Open Excel and paste in the ChatGPT response “=SUM(B2:B10)”
6-Open ChatGPT again and ask “Can you explain how this function works?”
7-ChatGPT will then respond with how the Excel Sum function works
Leave a Reply