Fed up with Excel? This site creates formulas for you

Few things frustrate us more than the inability to crack an Excel task independently. We love formulas and conditional cells, but the best way to utilize these features isn’t always easy. Tap or click for tricks to get the most out of Microsoft Word and Excel.

Our latest obsession is a natural language translator that can convert data or rules into a bonafide Excel formula. You can even plug it into Excel itself once you have it.

Read on to learn how to use an AI assistant to solve a challenging problem in Excel.

How to use the Excel Formula Generator

What is the Excel Formula Bot? This simple web app is browser-based and ready to help you tackle your latest Excel head-scratcher.

To begin, all you need to do is identify a task and use the tips listed on the site:

  • Use row or cell numbers when possible.
  • Use single quotes instead of double quotes.
  • Rewording your query if your results don’t pan out in Excel.

The AI bot will present you with formulas almost immediately. Give it a shot, and if it doesn’t work, it never hurts to try adjusting the prompt in whatever way you can.

RELATED: 5 free alternatives to Microsoft Excel

According to the site, “Model results are best when the prompt is as specific as possible (i.e., referencing exact cells, rows or columns). If you do not get the desired results, try to reframe your sentence.”

After getting what you need, we encourage you to provide feedback using the Yes and No buttons below your AI-generated solution. Doing so improves the program, which means better future results for you and everybody using this tool.

Continue reading

Can microwave technology treat cancer?

In the early days of microwave ovens, people worried that emitted radiation could be dangerous to their health. In what you might think is an odd twist, doctors now use microwave technology to treat cancer. It helps to alleviate pain and, in some cases, even cure some forms of cancer. You have to see it to believe it.

The Biofire smart gun

Biofire’s smart gun comes with a dock equipped with a touchscreen that pairs your face and fingerprint to the gun. Biometric data captured is stored only on the gun.

Ford F-150 Lightning catches fire

Ford paused production on its $62,000 electric tricks for five weeks after three caught fire. Ford says whatever caused the fire is “rare” and not related to a design flaw in the F-150 Lightning.

Son's suicide spurs Congressman's campaign against child sextortion | The Kim Komando Show

In July of last year, Rep. Brandon Guffey experienced a heartbreaking tragedy that no parent should have to endure. His 17-year-old son, Gavin Guffey, fell victim to a cruel sextortion scheme and tragically took his own life shortly thereafter. Now, as a South Carolina congressman, Guffey is advocating passionately to prevent such incidents from happening again. He is proposing a bill in the State House that would make sextortion a punishable offense with a maximum penalty of 30 years imprisonment.

Why NASA wanted a nuclear-powered rocket

Modern rockets use liquid fuel to propel them with enough thrust to reach space. But, 70 years ago, NASA was trying to achieve the same results using nuclear power. So, what happened and why did it end up not working?

The amazing history of popcorn

There is nothing like sitting down to watch a movie with a nice bowl of freshly made buttery popcorn. Did you know this warm treat has a fascinating history that goes back almost 9,000 years?

The largest animal migration on Earth

When you think of animals migrating, you probably picture massive herds traveling across the African Savanna or large flocks of birds heading south for winter. In reality, the largest animal migration takes place underwater. The kicker? It happens every single night.

The incredible history of concrete

There is more concrete used in construction than any other material. More than wood, steel and even glass. So what makes this super-substance so strong, and how did humans perfect it over 2,000 years ago?

Thieves going through headlights to steal cars

Hackers have a new method to break into your car: Through the headlights and a chip from a cheap JBL smart speaker.

The rise and fall of the iconic DeLorean

The DeLorean is widely recognized as an iconic symbol of the ’80s. Its futuristic design, gull-wing doors, and prominent appearance in “Back to the Future” made it a household name. Despite its initial success, the DeLorean car company quickly went out of business. So, what led to the company’s ultimate demise, and what lessons can we learn from the story of this failed manufacturer?

Marty Cooper, the inventor of the cellphone, recalls the first historic call

Imagine a world sans cellphones. It’s tough to grasp, right? It’s the 50th year of the cellphone, and we’re honored to have its inventor, Marty Cooper, on The Kim Komando Show. Marty Cooper is a trailblazer whose game-changing invention has transformed our world. He shares insights on the cellphone’s journey and discusses its future prospects.

Why scientists want to microwave the moon

The moon isn’t a hospitable place for humans because it lacks air and protection from space. Plus, the dust on the moon is so thin that it can damage the equipment we send there. Now, scientists are working on solving this problem using microwave technology. This approach could help us with future missions. But how will it work?

Use dynamic hitch assist in a Ford truck

Ford’s new Pro Trailer Hitch uses artificial intelligence and sensors to perfectly position a truck’s hitch ball under a trailer hitch with the push of a button. So cool!

Google Drive’s sneaky file limits

‘Find My iPhone’ directs strangers to man’s house, tax prep site delivers malware plus, for all the future social media superstars, I have the best times to post on Instagram. Matt gives you a pro tip on how to set up your phone to be a second monitor. And want to see more pics of your loved ones? Allie’s got a way to name your favorite people and animals in your photo app to find them easy.

Creating fuel the way plants do

Photosynthesis is a crucial biological process. Plants use the sun’s energy for growth and survival. Now scientists want to transform this process into a way to make fuel for cars, rockets and cargo ships. Is it possible?

Will the 21st century be the most important in history?

The first and 20th centuries are both renowned for their world-changing events, but what about the 21st century? What types of technologies could drive the advancement of humanity in our current century?

The true story behind iconic photos

There’s Albert Einstein sticking his tongue out and Elvis Presley and Richard Nixon’s handshake. What about John Travolta dancing with Princess Diana? You’ve seen these iconic photos, but do you know the real stories behind them?

The top 3 reasons why your Wi-Fi sucks

YouTube car-crashing duo arrested, Amazon Sidewalk network’s security risks. Plus, Amazon’s latest feature alerts you about frequently returned items. I show you how your smartphone can be a lifesaver. Also, TikTok’s strange warning about Fruit Roll-Ups (Hint: It’s about plastic). Matt explores the weirdest and best subreddits. Allie shares some effortless ways to make money from the comfort of your couch — no hair brushing required.

Kim Komando Today - March 23, 2023

Steve Jobs resurrected with AI, shocking scam uses Uber drivers & urgent iCloud warning. Plus, Allie has a dire warning for Samsung and Pixel owners, Matt tells us how to remote help for free, make money writing wedding vows and speeches, and a hilarious joke to end it all!