🤔 Can you skyrocket your productivity with ChatGPT? See what happens when I copy & paste YOUR complex Excel questions from YouTube into ChatGPT. Do you think it will give you the right answer? Let’s find out what Chat GPT is capable of. Can it properly solve complex Microsoft Excel spreadsheet problems?
What is chatgpt? Chat GPT, the new, viral AI chatbot by Openai is a type of artificial intelligence that can understand and generate natural language text. You’ll learn how to use it for Excel formulas and how to even make it write VBA code for your Excel macros.
I’ll also show you how to use ChatGPT and how you can modify your questions to get better answers.
Join 300,000+ professionals in our courses:
00:00 How to Use ChatGPT with Excel
00:52 Write Excel Formula with ChatGPT
05:06 Data Validation
08:42 Nested IF Formulas with ChatGPT
12:42 Writing VBA Code
17:14 Wrap Up
🌍 My Online Courses ►
👕☕ Get the Official XelPlus MERCH:
🎓 Not sure which of my Excel courses fits best for you? Take the quiz:
📚 Excel RESOURCES I Recommend:
🎥 GEAR I use:
More resources on my Amazon page:
🚩Let’s connect on social:
Instagram:
Twitter:
LinkedIn:
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#chatgpt #excel #openai…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
work doesn't go away it just changes form
HI! Is there a really easy way to convert an excel or sheets file to a pdf while preserving the formulas and fillable areas???
I'm semi-retired as a local, low level pol! Should I retool as a "maths-man" or a lawyer?"
I asked ChatGPT to write a line of VBA code which gives me number of second filtered row, cause I couldn't find it on the Internet (you can find everywhere hints for first filtered row), and within a seconds Chat gave me that and it works.
Second row – > SecondVisibleRow = ActiveSheet.AutoFilter.Range.Offset(1).Resize(ActiveSheet.AutoFilter.Range.Rows.Count – 1).SpecialCells(xlCellTypeVisible)
It help me on my job for send queries to the corporative web database using the HTTP POST query method and so to retrieve the data from the production lines automatically, all with excel.
@help with Excel.
In workbook: named D which has l2:m300 data validation list and vba code which help me to select multiple values in each cell and every value is separated by ;.
Problem/question
I took the source from sheet Q, range C2:c60.
My source for data validation changes.
I want: whenever any value changes in c2:c60, it should also change the corresponding cells of l2:m300 cells.
I CANT FIND THE ANSWER FOR MY PROBLEM. I NEED TO SUM THE COLUMNS OF ALL MY SHEETS IN A EXCEL FILE BUT ONLY IF THE THE MATCH CERTAIN CRITERIA IN ANOTHER SHEET. EXAMPLE SUM ALL PROFIT FROM ALL SHEETS BUT ONLY IF ITS JUNE
I'm genuinely excited about how it can enhance my job and replace repetitive tasks, and I don't see it interfering with my career shortly. You'll need to ask the right question and ensure that the problems you give are very descriptive; otherwise, it is not at the value you hope it will. It has a lot of promise.
Can CHATGPT be use to clean data or transform an unstructured data toa structure data set to avoid all the stress of data cleaning
Great Video Leila,,, you never disappoint. Just a suggestion you may want to improve the quality of your audio. Not sure what course you should take, but you many consider a quality wireless microphone… Wish I could afford your consulting fees. Keep up the great work you are doing for all of us… GBY
Is there a way chatgpt could help write a macro that would copy comments based on common PO numbers from a file for which I currently use VLOOKUP .
if we count number of spaces that will precisely tell us number of words
Chat LeilaPT
I am from india.if stock is received particular date then only enter that date .Other dates not entered how to get the formula
Alternatives to chatgpt with VSTACK function?
EXCEL SHEETS for STRENGTH & CONDITIONING COACHES. A very good video about this is available here ((Lukasz Lojas))…….
I integrated Siri with ChatGPT. Works well!
We don't need chatgpt but we need your videos more
Also to be noted that I have bought the ChatGPT Pro, it is much faster and gives better answers, so if you are going to use ChatGPT quite a lot, it could be worth it to subscribe.
In about 10 years you're all going to be braindead clowns. Declined from jobs all the time and then blame muh patriarchy or muh skin or muh gender.
thank you!
i've started using ChatGPT to review my vba codes
mainly to make it tidy and shorter version
some works and some did not, it depends on how ChatGPT understand your codes to your need
but still, just as you mentioned, it still need human touch/attention to tweak it
so as far as i know it wont replace human's work, it just a cheat tool for us to be more efficient at work
Textsplit esxample: as you asked to use testsplit you corenered it's thinkflow into that so he was trying to do what you ask using only that. Asking him to do the same job with Office 365 function could work. Or to do with newer formulas as testsplit and testjoin could also work.
Prompt have a very powerful limiting effect inside a single chat. You even can trick ChatGTP into thinking that 1+1=3 with the right prompt 😀