https://www.theverge.com/2022/12/27/23523281/excel-formula-suggestions-by-example-microsoft-365 Skip to main content The Verge logo.The Verge homepage * The Verge homepageThe Verge logo./ * Tech/ * Reviews/ * Science/ * Entertainment/ * MoreMenu The Verge logo. Menu * Microsoft/ * Tech/ * Apps Microsoft's making Excel's formulas even easier Microsoft's making Excel's formulas even easier / The company is adding some handy automation features to its web-based spreadsheet software. By Mitchell Clark Dec 27, 2022, 7:19 PM UTC| Share this story * * * Illustration of Microsoft's Windows logo It's only a matter of time before Excel can take over my job. Alex Castro / The Verge Microsoft has announced it's making Excel's autocomplete even smarter, at least in the web version that comes with Microsoft 365 ( formerly known as Office 365). Last week it announced formula suggestions and formula by example, both of which may help automate some things that you had to do manually. Formula suggestions are pretty much what they say on the tin: if you type the equal sign into a cell, Excel for web will try to intelligently suggest what type of formula you should be using, given the data that's around it. For example, if you have a full of quarterly sales numbers and a column at the end labeled "total," Excel might suggest summing the range of cells. According to a blog post from Microsoft, the feature currently only works in English, and will suggest sum, average, count, counta, min, and max formulas. It's not a groundbreaking feature, to be sure -- Google Sheets has had something similar for a while, and Excel's AutoSum has long been a quick way to apply formulas to data -- but for some use cases, it could be a nice timesaver. Then there's Formula by Example, which is similar to the Flash Fill feature that can automatically detect patterns in data and fill out the rest of a column. The feature is a bit hard to explain succinctly, but this video from Microsoft gives you an idea of what it's about; detecting a pattern where you're combing information from cells and then automatically generating a formula that will save you some typing. I tried to test out formula suggestions and formula by example on the web but couldn't actually get it to show up. The blog post does say that the features are now rolling out, though, so it's possible they just haven't made it to my account. For what it's worth, I also checked the Excel desktop app for Windows and Mac, and they also didn't seem to have the autocomplete features. Microsoft's blog post also includes several other feature announcements, though I'll admit I'm not enough of a power user to really understand them -- I'll leave that to esports competitors like the field of the recently-concluded Microsoft Excel World Championship 2022. There's a function for adding images with alt-text into your tables coming to Windows, Mac, and web, and the company's also adding nested Power Query data types and the ability to get data from dynamic arrays to the Insider version of the Windows app for testing. One other potentially useful (and thankfully easy to understand) feature coming to the web is "suggested links," which will automatically help you fix broken links to other workbooks stored in the cloud. Join the conversation Most Popular 1. The vibes are off at Tesla ----------------------------------------------------------------- 2. The LastPass disclosure of leaked password vaults is being torn apart by security experts ----------------------------------------------------------------- 3. TikTok is now banned on mobile devices issued by US House of Representatives ----------------------------------------------------------------- 4. Sherlock Holmes will finally escape copyright this weekend ----------------------------------------------------------------- 5. Microsoft's making Excel's formulas even easier ----------------------------------------------------------------- Verge Deals / Sign up for Verge Deals to get deals on products we've tested sent to your inbox daily. Email (required)[ ]Sign up By submitting your email, you agree to our Terms and Privacy Notice. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply. From our sponsor Advertiser Content FromSponsor logo Sponsor thumbnail More from Microsoft * A stock image of the Microsoft Edge logoA stock image of the Microsoft Edge logo Microsoft Edge is actually good * Logistics Companies Gear Up For China's Double 11 Shopping FestivalLogistics Companies Gear Up For China's Double 11 Shopping Festival Know the holiday return policies for Amazon, Target, Walmart, and others * Illustration of Microsoft's Windows logoIllustration of Microsoft's Windows logo Microsoft employee accidentally announces Notepad is getting tabs in Windows 11 * Call of Duty WarzoneCall of Duty Warzone Microsoft and Activision Blizzard: the latest news on the acquisition * Advertiser Content FromSponsor logo The Verge logo. * Terms of Use * Privacy Notice * Cookie Policy * Do Not Sell My Personal Info * Licensing FAQ * Accessibility * Platform Status * Contact * Tip Us * Community Guidelines * About * Ethics Statement The Verge is a vox media network * Advertise with us * Jobs @ Vox Media (c) 2022 Vox Media, LLC. All Rights Reserved