Telecom News Hubb
Advertisement
  • Home
  • News
  • Telecom
  • Contact us
No Result
View All Result
  • Home
  • News
  • Telecom
  • Contact us
No Result
View All Result
Telecom News Hubb
No Result
View All Result
Home News

Microsoft’s making Excel’s formulas even easier

admin by admin
December 27, 2022
in News


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.



Source link

Previous Post

Huawei OptiX OSN 9800 Ranked as Leader with the Highest Score in Core Packet-Optical Platform by GlobalData

Next Post

SMBs Optimistic About 2023 – ChannelE2E: Technology News for MSPs & Channel PartnersChannelE2E: Technology News for MSPs & Channel Partners

Next Post

SMBs Optimistic About 2023 - ChannelE2E: Technology News for MSPs & Channel PartnersChannelE2E: Technology News for MSPs & Channel Partners

Recommended

Test and Measurement: PAWR gets a $2.8 million R&D boost

December 2, 2022

Ericsson forecasts five billion 5G connections by end-2028

December 1, 2022

DoorDash Driver Gets Caught Eating Customer’s Food

January 20, 2023

Long Island Karen Goes Off On Starbucks Employees

November 5, 2022

Walmart’s Accidental Turkey Meat Fail

November 16, 2022

Don't miss it

News

Marvel Snap’s new Battle Mode is live

January 31, 2023
Telecom

Walmart Shopper Shows Store Now Sells 2-Pack Sugar Cookies

January 30, 2023
News

The future of broadband service delivery

January 30, 2023
News

What do first responders want from communications tech?

January 30, 2023
News

Helpdesk M&A: SupportLogic Acquires Emtropy Labs for AI-Enabled Support Analytics

January 30, 2023
News

SpaceX Crew Dragon vehicle could be used to evacuate ISS astronauts in an emergency

January 30, 2023

Telecomm-white

© 2022 Telecomm News Hubb All rights reserved.

Use of these names, logos, and brands does not imply endorsement unless specified. By using this site, you agree to the Privacy Policy and Terms & Conditions.

Navigate Site

  • Home
  • News
  • Telecom
  • Contact us

Newsletter Sign Up

No Result
View All Result
  • Home
  • News
  • Telecom
  • Contact us

© 2022 Telecomm News Hubb All rights reserved.