Artificial Intelligence tools such as ChatGPT will change the way we use computers. This is especially true with Microsoft Excel. Here are five reasons why ChatGPT is now a must for Excel users. ChatGPT will help you:

1. Calculate a weighted average
2. Determine the best salesperson
3. Find the Best 9 out of 10 scores
4. Separate the Last Name from Full Names
5. Explain what a complex formula is doing

To follow along with this video, be sure to download the Excel workbook we’ll be using. You can find the link at www.techhelptoday.com/videos.
In addition to the skills mentioned above, the most effective use of ChatGPT involves creating Excel macros. This is an extensive topic, which we will cover in a future video. In the meantime, here is a video that might be helpful:    • How to Use AI ChatGPT to Write Excel ...  

To see the ChatGPT video for beginners and other videos by Rich Malloy and Tech Help Today, go to: www.techhelptoday.com/videos

- - - - - - - - - - - - - -

FULL RESPONSES FROM CHATGPT

FIRST EXAMPLE: Weighted Average

PROMPT: In Excel, cells B14 through B16 have grades. Cells C14:C16 have weights. Please give me a formula that can return the weighted average of the grades

CHATGPT:
Sure, you can use the following formula to calculate the weighted average:

=SUMPRODUCT(B14:B16,C14:C16)/SUM(C14:C16)

This formula multiplies each grade in cells B14:B16 by its corresponding weight in cells C14:C16, sums the products, and then divides the result by the sum of the weights in cells C14:C16. This gives you the weighted average of the grades.

SECOND EXAMPLE: The Best Salesperson

PROMPT: In Excel, cells A13 through A19 have the names of salespeople. Cells B13:B19 have their sales amounts. Please create a formula that would return the salesperson with the highest sales amount.

CHATGPT:
To find the salesperson with the highest sales amount, you can use the INDEX and MATCH functions together with the MAX function.
Here's the formula:

=INDEX(A13:A19,MATCH(MAX(B13:B19),B13:B19,0))

This formula first finds the maximum value in the range B13:B19 using the MAX function. The MATCH function then returns the position of this maximum value in the range B13:B19. Finally, the INDEX function uses this position to return the corresponding value from the range A13:A19, which is the name of the salesperson with the highest sales amount.
Make sure to enter this formula in a cell separate from the data range to avoid overwriting any of the original data.

SECOND EXAMPLE: The Best Salesperson

PROMPT: In Excel, cells A13 through A19 have the names of salespeople. Cells B13:B19 have their sales amounts. Please create a formula that would return the salesperson with the highest sales amount.

CHATGPT:
To find the salesperson with the highest sales amount, you can use the INDEX and MATCH functions together with the MAX function.
Here's the formula:

=INDEX(A13:A19,MATCH(MAX(B13:B19),B13:B19,0))

This formula first finds the maximum value in the range B13:B19 using the MAX function. The MATCH function then returns the position of this maximum value in the range B13:B19. Finally, the INDEX function uses this position to return the corresponding value from the range A13:A19, which is the name of the salesperson with the highest sales amount.
Make sure to enter this formula in a cell separate from the data range to avoid overwriting any of the original data.


------------
Unfortunately, there is no more space available in this description. See the workbook file associated with this video in the link at the top.