Close Menu

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    What's Hot

    UAE residents actively seeking memorable experiences with 80% allocating a specific experience budget, reveals Shamal Holding UAE Experience Survey

    November 29, 2023

    Air Arabia broadens horizons with direct flights to Phuket

    November 29, 2023

    KEMA Labs Expands HVDC Testing, Fuels Energy Transition

    November 29, 2023
    Middle East NewsreportMiddle East Newsreport
    • Automotive
    • Business
    • Entertainment
    • Health
    • Lifestyle
    • Luxury
    • News
    • Sports
    • Technology
    • Travel
    Middle East NewsreportMiddle East Newsreport
    Home » Microsoft Excel formulas are getting smarter with enhanced features
    News

    Microsoft Excel formulas are getting smarter with enhanced features

    December 29, 2022
    Facebook WhatsApp Twitter Pinterest LinkedIn Telegram Tumblr Email Reddit VKontakte

    Microsoft has announced that its Excel autocomplete is getting smarter, at least in the web version of Microsoft 365. Last week, the company unveiled formula suggestions and formulas by example, according to The Verge. The two features could help automate various tasks that were previously manual. In Excel for Web, when you enter an equal sign in a cell, it will try to suggest a formula based on the data surrounding it. If you have a column named “total” at the end of your spreadsheet and a row full of quarterly sales data, Excel can suggest adding a range of cells.

    It will suggest sum, average, count, counta, min, and max formulas, according to a Microsoft blog post. There’s also Formula by Example, which can identify patterns in data and automatically fill out the remaining columns based on those patterns. A number of other features are also announced in Microsoft’s blog post. Also included in the Insider version of the Windows programme are nested Power Query data types and dynamic array data access, as well as a feature that will allow you to add photos with alt-text to your Windows, Mac, and web tables for testing purposes. A potentially useful web feature is “suggested links,” which will automatically resolve broken links between cloud-based workbooks.

    Related Posts

    The surprising role of amino acids in weight management

    November 29, 2023

    Antarctica’s melting ice highlights urgency of climate action, says UN Secretary-General

    November 27, 2023

    Space travel’s hidden risks include erectile dysfunction and frost damage challenges

    November 25, 2023

    Holiday shopping alert for recognizing and avoiding online scams

    November 21, 2023

    Unprecedented fires ravage Brazil’s Pantanal, wildlife at risk

    November 20, 2023

    Yellowstone Park confirms first case of zombie deer disease

    November 18, 2023
    Last News

    Air Arabia broadens horizons with direct flights to Phuket

    November 29, 2023

    In a significant expansion of its flight network, Air Arabia, the premier low-cost carrier in the…

    Etihad Airways elevates Grand Prix with spectacular 20th anniversary fly-past

    November 29, 2023

    In a stunning aerial spectacle, Etihad Airways, the flag carrier of the United Arab Emirates, celebrated…

    The surprising role of amino acids in weight management

    November 29, 2023

    Recent research has unveiled a surprising factor in weight loss: the reduction of a specific…

    Maximizing your diet with prunes and plums

    November 28, 2023

    Prunes, the dried form of specific plum varieties, are a powerhouse of nutrients. Revered for…

    © 2023 Middle East Newsreport | All Rights Reserved
    • Home
    • Contact Us

    Type above and press Enter to search. Press Esc to cancel.