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

TikTok’s Dark Side: Why it’s more than just a fun app & you need to remove it

The U.S. is inching closer and closer to a nationwide ban on TikTok. Those short, shareable videos make it the largest social app out there. Get this: 150 million Americans use TikTok, including about two-thirds of teens.

Continue reading

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.

Grab these 8 discounted gardening supplies to freshen up your yard this spring

Despite being the first week of spring, snow still lingers on fields and hills in some states, hiding the promise of blooming flowers. But don’t wait until the sun melts the snow away to think about your garden. Take advantage of discounted gardening supplies and stock up your shed for the coming season. Before winter fully flees, make sure you are well-prepared to give your lawn and garden the care they deserve.

Continue reading

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!

Trilogy Media: The YouTube Scam-Busting Duo You Need to Know | The Kim Komando Show

Ashton Bingham and Art Kulik, the dynamic duo behind YouTube channel Trilogy Media take on scammers and fraudsters like never before. From epic glitter bomb pranks to doorstep confrontations, these two will stop at nothing to take down scammers.

One man is making the smallest sculptures in the world

When you think of sculptures, you probably imagine something large and ivory in the courtyard of an ancient city. But one man is trying to flip that perspective on its head by creating sculptures that can fit in the eye of a needle. So, how is he doing this?

Why every animal has this in common

Animals come in all shapes and sizes. An elephant can grow to be thousands of pounds, and a gerbil can weigh just a few ounces. But, there is one thing that all animals have in common. Once you discover what it is, you can never unsee it.

Does Antarctica actually have its own flag?

Humans have been exploring Antarctica for over a century. Multiple countries have laid claim to large swaths of the continent, but there is no general government, and each outpost functions independently. So, how did it end up with a flag, and why does it look so cool?

Creating artistic masterpieces using a typewriter

Discover the fascinating world of typewriter art and witness the creative process behind turning a vintage machine into a tool for producing intricate art pieces. You won’t believe how one man was able to design this new form of art.

Can a 200-year-old invention capture lightning in a bottle?

In the late 18th century, electricity was evolving from an exciting parlor trick to real science. Scientists used glass bottles, wool cloth and metal balls to create and control electricity. But what if you tried recreating one of these objects using the tools from that era? Would it work?

Why it’s impossible to overcook mushrooms

Mushrooms are different from any other food we eat. They can elevate any dish and make even the most novice cook look like a world-class chef. But what makes mushrooms so unique, and why can’t they be overcooked?

How scientists are better understanding dyslexia

Dyslexia has long been associated with difficulty in reading. But, recent research has shown that some people with the condition can solve puzzles and understand optical illusions better. So, why is this and what does it mean for future research on this disorder?