One of the things I found useful about ChatGPT, I was working on a complex Excel formula, I was having a hard time figuring out how to use the Index and Match functions, I had never used either one before, I worked with ChatGPT, and it fixed the issue in the matter of a couple of minutes.
Once you get used to the interface and ask the right questions and provide the right information, the product can be extremely useful.
Oh I have no doubt AI can help create or help explain formulas and lookups and indexes etc. It’s been a while since I did anything semi-sophisticated with Excel. I use it regularly but the days of using advanced database style functions are behind me. A lookup, or just calculation across columns and formatting is what I do.
Oh I have no doubt AI like ChatGPT can help create or help explain formulas and lookups and indexes etc. And many other things. I’ve used some to help explain or lead me to answers in areas way outside my sandbox. (Don’t use Meta AI it is crapola - though I never used it my wife tried it to ask about news and the answer was so idiotic it ended up apologizing to her lol). It’s been a while since I did anything semi-sophisticated with Excel. I use it regularly but the days of using advanced database style functions are behind me. A lookup, or just calculation across columns and formatting and setting print areas is what I do.
If you haven't written VBA routines for your Excel work, these platforms can walk you through it and write the code for you. They make complex jobs easy. I increasingly rely on AI to look up the best formulas for my analyses and for suggestions as to how I can improve my work.
As a podcaster said the other day, AI is going to be great for people who use it and awful for those who refuse (they will be left in the trash bin of history). AI won't replace jobs as such but will replace and streamline tasks.