Excel AI!!!! (2 Viewers)

[ragincajun]

This is for everyone who asks Excel questions here. I found a website that uses AI to create your Excel formula. You type in what you are trying to accomplish and it spits out the result. I tried a few simple ones and wow. I wish I would have had this a long time ago. 
 

https://excelformulabot.com

 

[foxco]

Added to my favorites, thank you very, very much. 

 

[Leroy Hoard]

This is for everyone who asks Excel questions here. I found a website that uses AI to create your Excel formula. You type in what you are trying to accomplish and it spits out the result. I tried a few simple ones and wow. I wish I would have had this a long time ago. 
 

https://excelformulabot.com

Good inside of the box thinking.

 

[Captain Cranks]

Damn. I typed a wordy explanation of finding the intersection of two variables in a matrix and it knew to index match.  Fancy.  

 

[Sand]

I asked it to do something simple I need to do - remove empty cells to condense a column of data.  It suggested as stupid of stuff as I've been trying.

Skynet this is not.

 

[ragincajun]

I asked it do a simple vlookup and then also asked it to match the contents of two sheets based on color of the cell.  Worked great.

 

[bryhamm]

Damn. I typed a wordy explanation of finding the intersection of two variables in a matrix and it knew to index match.  Fancy.  

Must not be updated with the latest formulas then.  XLOOKUP is so much better than vlookup is and better than the clunky index/match combo.  Do yourself a favor and learn xlookup.

 

[Captain Cranks]

Must not be updated with the latest formulas then.  XLOOKUP is so much better than vlookup is and better than the clunky index/match combo.  Do yourself a favor and learn xlookup.

I'm actually doing myself an even bigger favor and learning python. I've got too much data for excel to handle efficiently. Learning to code is not fun, though. 

 

[Dinsy Ejotuz]

I'm actually doing myself an even bigger favor and learning python. I've got too much data for excel to handle efficiently. Learning to code is not fun, though. 

Depending on what you're doing with your data R might be easier to learn.

 

[urbanhack]

It's not AI...but how the hell did I not know this existed!

https://twitter.com/page_eco/status/1551909352617181185

 

[acarey50]

Must not be updated with the latest formulas then.  XLOOKUP is so much better than vlookup is and better than the clunky index/match combo.  Do yourself a favor and learn xlookup.

Big fan of XLOOKUP

I'm actually doing myself an even bigger favor and learning python. I've got too much data for excel to handle efficiently. Learning to code is not fun, though. 

And I also need to be less of a fossil and try learn some of these programming languages. Between Excel/Access and PowerBI, it's a skill set I need to add to my repertoire to keep myself relevant as we often also run stuff through SAS as well.

 

[Captain Cranks]

Big fan of XLOOKUP

And I also need to be less of a fossil and try learn some of these programming languages. Between Excel/Access and PowerBI, it's a skill set I need to add to my repertoire to keep myself relevant as we often also run stuff through SAS as well.

It's been a multi-year struggle of trying to climb the learning curve to transition to python. A lot of starting, stumbling, and then slipping back to a place of comfort with excel. I decided to dedicate myself to getting over the hump this summer and am finally reaching a place of steady progress. Damn, is it so much faster and more efficient. I still have a ton to learn, but the bricks are beginning to form a structure. 

If you do decide to learn, start off slow and try to replace a small function you would currently use excel for, going step by step using YouTube videos. I found the "learn python" courses to be unhelpful because they couldn't keep my attention. 

 

[acarey50]

It's been a multi-year struggle of trying to climb the learning curve to transition to python. A lot of starting, stumbling, and then slipping back to a place of comfort with excel. I decided to dedicate myself to getting over the hump this summer and am finally reaching a place of steady progress. Damn, is it so much faster and more efficient. I still have a ton to learn, but the bricks are beginning to form a structure. 

If you do decide to learn, start off slow and try to replace a small function you would currently use excel for, going step by step using YouTube videos. I found the "learn python" courses to be unhelpful because they couldn't keep my attention. 

Appreciate the tip - any particular resources that you have found to be most helpful? I'm at a point where I'm not even sure which tasks Python (or R, or any other language) would be suitable to try and replace my existing tasks with - but I am open to trying.

 

[Mister CIA]

It's been a multi-year struggle of trying to climb the learning curve to transition to python. A lot of starting, stumbling, and then slipping back to a place of comfort with excel. I decided to dedicate myself to getting over the hump this summer and am finally reaching a place of steady progress. Damn, is it so much faster and more efficient. I still have a ton to learn, but the bricks are beginning to form a structure. 

If you do decide to learn, start off slow and try to replace a small function you would currently use excel for, going step by step using YouTube videos. I found the "learn python" courses to be unhelpful because they couldn't keep my attention. 

Not a python programmer, but here are some courses that may or may not be of interest.  Some are free, some not so much.  

https://www.edx.org/search?q=python

IBM DeveloperWorks has a large selection of course material.  May need to search find something of interest.

https://developer.ibm.com/

Not too familiar with either, just know that they exist.

 

[ragincajun]

I have been looking at Power Apps as well.  Some pretty cool stuff.

Also, Fuzzy Lookup…..

 

[Ned]

It's not AI...but how the hell did I not know this existed!

https://twitter.com/page_eco/status/1551909352617181185

I used to do this to build my own draft dashboard.  Pulling in MFL player stats, different site rankings, etc.  Miss those days.   

 

[Captain Cranks]

Appreciate the tip - any particular resources that you have found to be most helpful? I'm at a point where I'm not even sure which tasks Python (or R, or any other language) would be suitable to try and replace my existing tasks with - but I am open to trying.

There are a ton of options on Youtube so these may not be the best fit for you, but I like Corey Schafer and Medallion Data Science

This is a good video on getting Python/Anaconda installed.

 

[E Street Brat]

Big Black Dot. 

 

[Scoresman]

"Do my expense report" didn't work.  It's useless.

 

[Captain Cranks]

"Do my expense report" didn't work.  It's useless.

I've got a buddy who would wait until the end of the year to hand in all of his. One year it totaled five figures. Sometimes he'd wait so long he'd miss the annual deadline and be out the cash. He didn't care as it was worth it not to do the reports.

 

[TheBaylorKid]

Must not be updated with the latest formulas then.  XLOOKUP is so much better than vlookup is and better than the clunky index/match combo.  Do yourself a favor and learn xlookup.

You would love the tweets from Twitter handle memes.xlsx  

 

[bryhamm]

You would love the tweets from Twitter handle memes.xlsx  

Following now

 

[STEADYMOBBIN 22]

"Do my expense report" didn't work. It's useless.

I've got a buddy who would wait until the end of the year to hand in all of his. One year it totaled five figures. Sometimes he'd wait so long he'd miss the annual deadline and be out the cash. He didn't care as it was worth it not to do the reports.

I loath doing them as well.

 

[stbugs]

It's not AI...but how the hell did I not know this existed!

https://twitter.com/page_eco/status/1551909352617181185

Old post, but it makes sense that this exists. It’s pretty easy to read the web page and just look for the table/td tags and grab the data for each table displayed. I didn’t know it existed but it makes sense that it does.

 

[mr. furley]

 

[culdeus]

I'm trying to do something I forgot, and it didn't do a great job.

Basically have values in 4 columns and a 5th column. The 5th column is to represent a column number.

Asking excel to get the max value of the 4 columns excluding the column number I specify in the 5th.

Can't handle it.

 

[culdeus]

I'm trying to do something I forgot, and it didn't do a great job.

Basically have values in 4 columns and a 5th column. The 5th column is to represent a column number.

Asking excel to get the max value of the 4 columns excluding the column number I specify in the 5th.

Can't handle it.

For what it's worth ChatGPT did a much better job, and specified to remember to enter as a matrix formula, worked first shot with exact same prompt.