Use ChatGPT to Help Solve Excel Formulas
Vložit
- čas přidán 8. 09. 2024
- Having a hard time finding the correct Formula to use in Excel? Ask ChatGPT
ChatGPT is an artificial intelligence chatbot
ChatGPT is a natural language processing tool driven by Artificial Intelligence technology that allows you to have human-like conversations and much more with the chatbot. The language model can answer questions and assist you with tasks like finding the correct formula for a problem in Excel.
Don't forget to "Like" and "Subscribe"!
ChatGPT Website
openai.com/blo...
Click to Download Resource
www.officenewb...
I am doing your course on Excel-Biginner to advance on Udemy. Such a wonderfully designed course. Thanks a lot from India.
Awesome glad you are enjoying it! Thank you for sharing!
Me too! You've saved my job! I've been able to do some magic in Excel with data thanks to you!
Great! So glad it's helping!
I liked your teaching sir, I am gaining knowledge from you.
Glad to hear that! Thank you
Timely video. Thanks
You're welcome!
I love these videos! Also I love your amazing courses on Udemy!! I bought them excel and access course and have been able to develop a database for my workplace. It’s been amazing to learn how to do these things and I thank you for it! They were way to follow and well worth the money
Awesome! Happy to hear that!
Hi Kyle, I am your student on Udemy- microsoft excel course . I am learning excel for my project. Any doubts I will reach out in q n a section. Please clarify!! I have liked and Subscribed your CZcams channel
Thank you! Hope your enjoying the course! Yes please ask any question in the Q&A section.
@@OfficeNewb Yes, I am very happy to learn from you. Sure
Thanks a lot dear Kyle, I am enrolled in your wonderful course on Udemy.
Thanks for all you do
Great to hear! Thank you
This is huge and thanks for this wonderful video.
Glad you enjoyed it!
Kyle love these help insights
But on 2 videos when downloading the sheet you provided I get the error Excel cannot open the file because the file format or file extensions is not valid. Verify that the file has not been corrupted a b that the file extension matches the format of the file.
I can hit okay to override the error but the data you apply in the video is missing.
What am I doing wrong here as I right to practice the tips you provide in the video.
I have checked the file for this lesson and it is a .xlsx file a basic excel file. Are you opening the file in Excel? If you are what version of Excel are you using?
Quick question, how do you add the $ sign when doing an absolute just by highligthing the rows? Well I know is more than that but can you please teach me how to do that since it's a lot quicket than going one by one changing those.
Thanks
Select the cell reference in your formula then click the F4 function key on your keyboard.
For the second question I believe we could use SUMIFS if we don't have Chatgpt, right?
Yes you can!
Why cant I do a simple ranking of students according to the marks scored by them?
Say, Marks scored are: 8,9,7,7, 1
9 is 1st rank
8 is 2nd rank
7 and 7 is 3rd rank
1 is 4th rank.
Cant do this on excel
You can easily rank students based on their marks in Excel using the RANK function.
@@OfficeNewb make a video tutorial plz