TechnologyGame-changer for Excel: Free AI bot creates any Excel...

Game-changer for Excel: Free AI bot creates any Excel formula you need 

-

- Advertisment -spot_imgspot_imgspot_imgspot_img

If you’re not a Microsoft Excel power-user who has already divined many of the secrets of the ubiquitous spreadsheet software, trying to build a presentation of data therein can seem like a daunting task. For the average person, it’s probably less intuitive than a comparatively simpler software product from the same company like Word, about which you don’t really have to know much at all to get started.

Luckily, though, a free AI bot aims to remove some of the mystery involved in building a spreadsheet in Excel. And we’ll tell you all about it below.

Microsoft Excel hack

For anyone who’s not a programmer and doesn’t really understand how to craft Microsoft Excel formulas? Simply head over to https://excelformulabot.com and let the AI there do the job for you.

The site consists of an input box, and you’re prompted to summarize the problem you’re trying to solve. “Model results are best when the prompt is as specific as possible (ie: referencing exact cells, rows, or columns),” the site explains. “If you do not get the desired results, try to reframe your sentence. If you are using quotes, only use single quotes. Double quotes will cause an error.”

The example the site uses is the following. “When column A equals the sum of ‘hello,’ calculate the sum of column B.” The formula that the Excel bot gives back to you? “=SUMIF(A:A,”hello”,B:B).”

The project is accepting donations, which will fund future development of the work. And we should also note that visitors have used it to generate almost 322,000 Microsoft Excel formulas so far.

READ MORE: Windows Defender might be making your PC run slower

Updates coming to Excel

In other Microsoft Excel news, meanwhile, you can check out the update below from the company. It walks through new additions coming to the spreadsheet software for the web, Windows, and Mac.

“We are excited to share the general availability of sheet protection,” the company announced, “and semi-select for links creation in the web for Excel for the web and automatic alt text suggestions for charts and PivotCharts across Excel for Windows and Excel for Mac — among other features. For Insiders, we’re rolling out the ability to insert data from pictures in Excel for Windows.”

Andy Meek profile photo

Andy Meek is a reporter who has covered media, entertainment, and culture for over 20 years. His work has appeared in outlets including The Guardian, Forbes, and The Financial Times, and he’s written for BGR since 2015. Andy’s coverage includes technology and entertainment, and he has a particular interest in all things streaming. Over the years, he’s interviewed legendary figures in entertainment and tech that range from Stan Lee to John McAfee, Peter Thiel, and Reed Hastings.

Read More

Latest news

Mario Strikers: Battle League Version 1.1.1 Is Now Live, Here Are The Full Patch Notes

Update today by Liam Doolan 2 hours agoMario Strikers: Battle League has just received a new update. It bumps...

Nintendo Announces The Next N64 Game For Switch Online + Expansion Pack

Wave Race 64 makes a splash later this week by Liam Doolan 2 hours agoNintendo hasn't outlined the future...

Disney & Marvel Announce First Ever Games Showcase, Airing September 9th

Avatar, Lego Star Wars and more! by Liam Doolan 3 hours agoFollowing on from THQ Nordic's digital showcase last...

Fortnite’s Dragon Ball Crossover Trailer Appears To Have Leaked, Here’s A Look

This collab is over 9000! by Liam Doolan 3 hours agoUpdate : Well, it seems the official trailer for...
- Advertisement -spot_imgspot_imgspot_imgspot_img

Gamescom 2022: Everything You Need To Know

It's August, and that means that Geoff Keighley's Never-Ending Train Of Games is chugga-chuggin' into Cologne, Germany for the...

Nipsey Hussle Receives Star on Hollywood Walk of Fame: ‘He Lives Forever’

Revered rapper Nipsey Hussle was posthumously honored with the 2,729th star on the Hollywood Walk of Fame on what...

Must read

Rivian, Lucid rush to help buyers with existing EV tax credit before it expires

Luxury electric vehicle startups Rivian Automotive and Lucid Motors...

Aston Martin DBR22 concept car bows at Pebble Beach

Aston Martin is rolling out a concept car this...

VW, Mahindra deepen EV component cooperation

FRANKFURT -- Volkswagen Group and Mahindra and Mahindra will...
- Advertisement -spot_imgspot_imgspot_img

You might also likeRELATED
Recommended to you