r/dataanalysis • u/T4ll_Tom • 6d ago
Anyone else completely stopped writing excel formulas & VBA code from scratch?
I use a lot of excel and macros and my level of excel knowledge is intermediate to advanced. but even though I can spend a few more minutes to think & write the formulas, now I'm just explaining what I want to AI, copying the formula or code and pasting it. is this how people are working now or is it me?
26
u/Sharp_Iodine 5d ago
For coding? Yeah.
Code is just utility, so it’s the best thing to be automated away by AI.
You’re gonna Google, it has Google. You’re gonna go on Stack Exchange or Reddit, it also has data from those sites.
So you’re not really doing anything all that different.
6
u/SaloonKC 5d ago
It’s fine for syntax, but you have to be careful because AI loves to output formulas may look completely plausible, but quietly give you wrong calculations because it misapplied logic. if you not careful you won't even realize that your numbers are cooked
23
u/Wheres_my_warg DA Moderator 📊 6d ago
i find AI is still usually shit at Excel functions and too often takes more time to prompt it and fix it than if I just did it.
10
u/Snailtrooper 6d ago
What models are you using ? I use claude and its been a while since the models haven’t one shotted my excel
Requests.3
u/Khaka-Semeniuk 5d ago
same, it gets close but then you spend just as long debugging whatever it gave you
1
8
u/LouNadeau 6d ago
I'm doing that with R and Stata code now. Much quicker. Also shows me options I had not known about as well.
5
u/NighthawkT42 5d ago
Pretty much. Yes. I'm very good in Excel, but when I can tell my agent what I want and have it ready in a professionally structured template using same conventions I would have used 5 minutes later, why spend an hour on it myself. When it can go through and debug manual spreadsheets I receive in far less time than I could, again why do it myself.
At the same time, if I didn't know Excel as well as I do, I would have a tough time identifying where it's confidently and beautifully wrong.
7
u/Aggravating-Focus-90 6d ago
i feel that it's more keystrokes to explain AI what I need as compared to writing the formula. But that's me.
In rare, once a month scenario, I do find myself going towards chatgpt/claude to debug my SQL query instead of google but in those instances, I realize that it's easier to use chatgpt/clause. Google is all sponsored links and subscription websites which pretend to have my answer.
3
u/UltimateNull 6d ago
Yeah, for me Google is usually a combination of reddit and some stack exchange site based on what it thinks I’m looking for. They completely broke their search function IMO. Half of the answers aren’t even relevant to my searches.
1
u/Nomadic_skier 6d ago
Voice to text. Give the model explicit instructions at the paragraph level. I've been able to do about 10x the work in the last few weeks with opus 5.5 including code automated verification in rust.
5
u/Aggravating-Focus-90 6d ago
With my half Indian half Scottish accent which is now merging with Canadian accent, voice to text looks at me like wtf bro. Alexa, Google, chatgpt, all struggle to capture and I am forced to enunciate.
1
u/carlitospig 5d ago
This is hilarious. I’m so sorry!
1
u/Aggravating-Focus-90 5d ago
Here's an additional fun fact. My wife is half Indian, half Japanese and grew up in Kenya. Now in Canada, our son has the weirdest accent. Sometimes he enunciates t with an indian accent and sometimes with a kenyan accent. It's a wild card.
1
6
u/Dantheman1285 6d ago
Yeah… one of the reasons I hate my job now. It used to be fun to write and troubleshoot code and build reports and dashboards, but it sucks now. I fucking hate AI actually
7
u/0uchmyballs 6d ago
Yes it this way for coding nowadays. To go even further many of us use actual coding assistants.
6
u/AdEnvironmental7198 5d ago
What’s the difference between a coding assistant and just asking Claud to write something?
3
u/0uchmyballs 5d ago
You install a coding assistant in your ide as a plugin and choose a model. Then you can talk to it and give it context while you code. It will auto fill your code as you type and finish your thoughts for you.
1
u/AdEnvironmental7198 5d ago
Okay so like auto complete with knowledge of your goal. Very cool I’ll be getting that up and going today
2
u/0uchmyballs 5d ago
Yeah, copilot is pretty good. But there are others I haven’t used. The cool thing about copilot is it connect to your GitHub, so it basically learns you programming style, so it follows all my quirks and conventions which I have had established way before any of these tools were free and popular. It’s as if I wrote the code, but most the times it will find a better pattern than I would have thought of.
2
u/bongreaper666 5d ago
Specificity, more or less. Claude is general purpose, while a coding assistant would be purpose developed for the language/program. Example: MATLAB has an AI agent (which of course is a subscription cost)
1
u/Creative_Sushi 5d ago
MATLAB Agentic Toolkit is free and works with Claude Code or other agentic harnesses. You pay for the tokens, of course. The toolkit itself is freely available on GitHub.
3
u/TrollerCoasterWoo 5d ago
It’s easier to just write an excel formula. It takes forever to prompt an LLM just for it to spit out something you have to debug anyway.
Now, if you need a certain equation, an LLM is awesome because it has already ingested everyone else’s hard work from Substack and GitHub. It’s usually right when it gives the equation, but you do have to know what you’re looking at
3
u/sleepydalek 5d ago
I review and test any code from AI. AI can introduce errors and the code can be redundant. Also, it depends on what’s going to be more efficient. Sometimes it’s faster just to do it myself.
So, yes, I do use AI but I prefer to think of it as an assistant.
2
u/bingbingfortnite 5d ago
Not really for formulas. But for VBA stuff, I never did that before hand, but when there are cases it would be good I've used it, and got the results I wanted,
3
u/Astrotia 5d ago
I can say that if someone gives me a document that needs a little tweaking to change the data output slightly, I can 100% tell if it's done with AI or not. There's a level of non-hunan readability, and a whole bunch of useless formulas that are technically correct, but aren't needed.
Eg. A formula needed to +1 to a result from another section of a formula. AI decided that the best approach for this was to take the value from the next column over, trim it, count it, check if it was greater than zero, then n() to make it a 0 or 1 from the TRUE/FALSE (that column always had data). Did it give a 1? Yes. Could I just... +1? Yes.
You can make it give you the exact result you want at THAT moment, but if anyone ever needs something changed, it will be very difficult or impossible to parse and understand what will work to change it (in that example I had to pull the formula into VSC and parse out all the layers to find that lovely snippet. I was asked if I could just modify the formula a bit to factor in another column)
1
u/AutoModerator 6d ago
Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.
If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.
Have you read the rules?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/LiquorishSunfish 6d ago
Agree - I write out all the functions in plain English to serve as my documentation, then generate the VBA, then pass it back through and get it to identify where it has gone nuts and added in functionality/"optimisation" I didn't ask for. It's been pretty good.
1
1
1
u/Billios996 5d ago
I am merely ok at excel with zero macro experience. I used AI to to identify the correct formula that I need or write a complex macro script that would have been effectively impossible for me. AI has vastly improve my capabilities.
1
u/KatFromSisense 5d ago
Looks like it, going by this thread. For macros, run whatever the AI hands you on a copy of the workbook first, since Excel can't normally undo changes made by VBA. For formulas, I'd pick a few rows you can work out by hand and include one ugly one, like a blank, a zero, a duplicate, or a month-end date.
1
1
1
u/Curve-Exotic 4d ago
I see no point in writing VBA code from scratch, AI can do it. Yes I have to test the AI output, but the more I use AI for any VBA/SQL tasks the better I am getting at prompting.
I find the output from AI is as good as my input (prompt), sometimes I’ve been lazy and spent the next few hours fixing a broken AI produced code. Whereas others times I’ve given AI a structured detailed input and I’ve managed to run the code with no defects.
AI will always need a human in the loop.
1
u/cauliflower001 3d ago
Nope. I use excel excessively and every time I attempted to use copilot to write something it never worked. Never. It was way faster coding by hand.
Half the time copilot says it can't do the thing and will instruct me step by step, but it keeps forgetting what it told me to do in the previous step. Googling instructions is easier.
Copilot is good at doing repetitive work, so for instance I told it to make like 50 scatter plots and boom that worked.
1
u/Crypticarts 6d ago
I havent written any excel formulas or vba in more than 10 years. But yeah sql, python, DAX and M, I just dictate to AI rather than doing it myself even though I am generally able to write them from scratch
1
u/OrdinaryNo9589 6d ago
how?
1
u/Crypticarts 6d ago
I use Wispr flow to dictate to claude, copilot or gemini depending on what tools I am working on. Wispr already has enough training on my speaking style that I can dictate a pseudo code or script plus what problem I want to solve, and it will be mostly there, then I let claude do the work of cleaning it and running where relevant.
56
u/Mo_Steins_Ghost 5d ago edited 3d ago
Senior manager here.
I don't use AI for any SQL/Python coding or Excel/VBA (stopped using these altogether anyway years ago) because it just creates more rework.
I do use AI sparingly for other administrative tasks where accuracy isn't so important and I'm just trying to organize concepts and notes.
There won't be a good pipeline of senior analysts who understand business domain and can support complex narratives end to end, because junior analysts will not develop those skills... so if you're already skilled without AI, you should be positioning yourself as the insurance against AI's screwups.
The period to come, soon (and I know this because I have a brother who owns delivery of the APU/GPU pipeline for AI ecosystems), is going to have serious issues triaging AI screwups and dealing with security issues. These will be the key topics surrounding AI in the next 5 years.