Page 182 - JoFA_Jan_Apr23

TECHNOLOGY Q&A

Now the macro has been written for me. But there will be varying pricing plans.
still, many people wouldn’t know what to do with ChatGPT is certainly not limited to just Excel
this code. So, I continued to ask ChatGPT for help, assistance. I had my family play around with it. My
and it responded as shown in the screenshot above. husband asked it for instructions on doing some
I followed the step-by-step instructions, and the repairs on his Mustang. My son asked what code
macro worked! After I ran the macro, it asked me to enter to get a pickaxe on Minecraft. A student
what the start month was. I entered a 1 for January, of mine asked it to explain how to make brownies.
2 for February, etc., and it changed the tab names to Play around with it and ask it questions or ask it to
the proper months as shown in the screenshot below. do something. OpenAI wants your feedback so the
While my first attempt asking ChatGPT for tool will continue to learn and get even better. In
this macro was successful, several other attempts case you’re stumped on your first question, here’s a
were not. As I previously mentioned, every time suggestion: “What is the number one accounting
you ask the tool a question, you will get a different practitioner journal?”
answer, or at least one phrased a different way. You can view a video I made using ChatGPT
There are limits on how many times a user can to assist with Excel in the version of this article at
use ChatGPT, but the current exact number is not journalofaccountancy.com.
disclosed. Once it becomes a paid service, I imagine — By Kelly L. Williams, CPA, Ph.D. ■

44 | Journal of Accountancy April 2023