Clueless about how to write Excel formulas? Use Al
PCWorld|March 2023
While both Excel Formulator and Excel Formulabot promise to translate your request into Excel code, only one will do it for free
MARK HACHMAN
Clueless about how to write Excel formulas? Use Al

Over the past six months, we’ve learned how AI can be used for many tasks: creating art (fave. co/3IrcWds), powering a sophisticated chatbot (fave.co/3I7qDye), and so on. But what if you could use it to actually assist you in your job?

If your job is working with Excel, you’re in luck. A free site (with registration) does just that: Excel Formulator (fave.co/3kmv8gg). Excel Formulator takes your instructions, in plain English, and turns them into an Excel formula. “Pick the highest value in column C and assign it to the cell to the right of the cell labeled ‘Big Spender’” turns into =MAX(C:C) & "Big Spender". Copy the latter into the formula field into an Excel cell, and you’ve saved yourself some time—or, for those who don’t have a sophisticated knowledge of Excel, you now have a quick-and-dirty solution to an irritating problem.

Denne historien er fra March 2023-utgaven av PCWorld.

Start din 7-dagers gratis prøveperiode på Magzter GOLD for å få tilgang til tusenvis av utvalgte premiumhistorier og 9000+ magasiner og aviser.

Denne historien er fra March 2023-utgaven av PCWorld.

Start din 7-dagers gratis prøveperiode på Magzter GOLD for å få tilgang til tusenvis av utvalgte premiumhistorier og 9000+ magasiner og aviser.

FLERE HISTORIER FRA PCWORLDSe alt
Facebook wants to use your posts to train Al. Here's how to object
PCWorld

Facebook wants to use your posts to train Al. Here's how to object

Facebook is changing its privacy policy and plans to use posts and images to train its Al. To prevent this, you need to object.

time-read
2 mins  |
July 2024
Windows 11's new AI feature could be a privacy nightmare
PCWorld

Windows 11's new AI feature could be a privacy nightmare

Your PC will be watching your every move by default.

time-read
4 mins  |
July 2024
The future of Windows: Copilot+ PCs unleash practical AI tools
PCWorld

The future of Windows: Copilot+ PCs unleash practical AI tools

Microsoft is aligning AI with its Copilot brand.

time-read
3 mins  |
July 2024
If you get a phone call from LastPass, it's a scam
PCWorld

If you get a phone call from LastPass, it's a scam

A new breed of sophisticated phishing scammers are targetting LastPass users with phone calls and emails.

time-read
1 min  |
June 2024
Sick of ads in Windows? This ingenious program eradicates them all
PCWorld

Sick of ads in Windows? This ingenious program eradicates them all

This clever free tool removes all the ads that Microsoft keeps stuffing into Windows 10 and 11.

time-read
1 min  |
June 2024
Controversial Windows 11 Start menu ads begin rolling out
PCWorld

Controversial Windows 11 Start menu ads begin rolling out

Microsoft has pushed “Promoted” apps from the Store to the Windows 11 wide build just a few weeks after they started appearing to Insiders.

time-read
1 min  |
June 2024
Ring of bogus web shops steals 850K credit card numbers
PCWorld

Ring of bogus web shops steals 850K credit card numbers

Fake online storefronts, which show up in great numbers in Google and other search engines, are becoming a big problem.

time-read
3 mins  |
June 2024
This free, ancient Windows app will watch your laptop battery
PCWorld

This free, ancient Windows app will watch your laptop battery

BatteryInfoView gives you the laptop battery information you didn’t know you wanted.

time-read
2 mins  |
June 2024
How to use your smartphone as a Windows 11 PC webcam
PCWorld

How to use your smartphone as a Windows 11 PC webcam

Windows 11 now allows the wireless connection of Android smartphones for use as a webcam.

time-read
3 mins  |
June 2024
How to digitize VHS tapes the cheap way
PCWorld

How to digitize VHS tapes the cheap way

Preserve your old video tapes with an inexpensive capture card and free software.

time-read
4 mins  |
June 2024