Subscribe to Updates

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

    What's Hot

    OVER 100 NEW CYBERSECURITY GRADUATES READY TO COMBAT THE RISE IN CYBERCRIME IMPACTING BUSINESSES WORLDWIDE

    June 2, 2023

    The 14th International Infrastructure Investment and Construction Forum Kicks Off in Macao

    June 2, 2023

    Big tobacco’s big lie: Philip Morris’ smoke and mirrors strategy

    June 1, 2023
    Facebook Twitter Instagram
    Algeria News HubAlgeria News Hub
    • Automotive
    • Business
    • Entertainment
    • Health
    • Lifestyle
    • Luxury
    • News
    • Sports
    • Technology
    • Travel
    Algeria News HubAlgeria News Hub
    Home » Microsoft Excel formulas are getting smarter with enhanced features
    News

    Microsoft Excel formulas are getting smarter with enhanced features

    December 29, 2022
    Facebook Twitter Pinterest LinkedIn Reddit WhatsApp Email

    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.

    Share. Facebook Twitter Pinterest LinkedIn WhatsApp Reddit Email

    Related Posts

    Sony faces antitrust probe in Romania over PlayStation’s market dominance

    May 31, 2023

    Twitter’s legal woes mount as former PR firm files lawsuit for unpaid invoices

    May 30, 2023

    WHO report urges governments: prioritize food security over tobacco industry

    May 27, 2023

    India soaring to new heights: the impact of nine years of Modi’s leadership

    May 25, 2023

    PM Modi begins action-packed three-nation tour, eyeing over 40 engagements

    May 19, 2023

    Masdar sets its sights on being one of the largest producers of green hydrogen by 2030

    May 19, 2023
    Latest News
    Health

    Big tobacco’s big lie: Philip Morris’ smoke and mirrors strategy

    June 1, 2023

    In an ironic twist of self-serving rhetoric, Jacek Olczak, CEO of tobacco giant Philip Morris…

    Unveiling the most overlooked early heart attack symptom

    June 1, 2023

    Sony faces antitrust probe in Romania over PlayStation’s market dominance

    May 31, 2023

    Audio-Technica brings back the Sound Burger: a retro turntable for the modern age

    May 31, 2023

    From crisis to catastrophe: China’s potential 65 million COVID cases per week by June

    May 30, 2023

    Twitter’s legal woes mount as former PR firm files lawsuit for unpaid invoices

    May 30, 2023

    Global stocks surge as US debt ceiling agreement brings relief

    May 29, 2023

    India’s mastery in space: ISRO’s successful launch of Cartosat-3 satellite

    May 29, 2023
    © 2021 Algeria News Hub | All Rights Reserved
    • Home
    • Contact Us

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