r/excel • u/brokerfromUC • Nov 16 '22

Excel Copilot: Just explain the formula and AI will write it for you Advertisement

Hey guys, I (24M) built this powerful Excel tool over this weekend. Just explain the formula and AI will write it for you. I shared it with friends who work at companies like Deloitte and they rave about it!

Best thing is you can use it inside Excel or Google Sheets on Chrome browser. It can do complex SUMIFS, VLOOKUP and much more with the help of LLM AI models that I have fine tuned on a dataset of over 40K formula combinations.

You can get it here: Excel AI

https://i.redd.it/ejgxywdm8d0a1.gif

265 Upvotes
  • permalink
  • link
  • reddit
  • reddit

93% Upvoted

49 comments sorted by

View all comments

Show parent comments

40

u/GuitarJazzer 27 Nov 17 '22

I am a mod on an excel forum and have answered thousands of questions over the years. A problem that I see all the time is that people ask for a formula without a clear-headed idea of what they want it do. After I go back and forth with them a few times to articulate the problem, the solution usually isn't that hard. This tool is probably great IF you know exactly what you want and can articulate in clear language. But most people who can do that can also write the formula.

11

u/Homitu 1 Nov 17 '22

Sounds like we need to build an AI bot that interprets someone's poorly articulated questions and translates them into more precise questions that they actually intend. Then we can copy/paste that clearer question into this bot's text box!

6

u/GuitarJazzer 27 Nov 17 '22

Yes, the "read my mind" bot and the "guess what I want when nobody knows what I want not even me" bot.

2

u/arcosapphire 16 Nov 17 '22

If you can do that, you'd probably achieve world peace, resolve every marital disagreement, and usher in a global utopia.

So naturally it will never happen.

5

u/Cynyr36 24 Nov 17 '22

So much this. It's not just in the excel subreddit a, but in the real world in engineering all the time.

2

u/GuitarJazzer 27 Nov 17 '22

I have done systems development for over 40 years and I still cringe at some of the shit that even professional requirements analysts write.

3

u/Cynyr36 24 Nov 17 '22

It's more the end user usually asks for a change that they think will solve their problem rather than state their problem.

1

u/Herr_Scary_Terry Nov 17 '22

Even if they know these things and still cannot write formula they are one quick Google search from that.

1

u/Thewolf1970 16 Nov 17 '22

One of the best lessons I taught my son when he entered the working world and had to use Excel was to go in and use the top ten excel formulas and simply master them. Not just the formula but the variances, so SUM and SUMIF.

It took him a few days, but he's extremely comfortable in it now.

1

u/EverySingleMinute Nov 17 '22

I saw a couple of examples and was thinking I need to change the way I think of writing out a formula to be able to use this bot.