Subscribe to Updates

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

    What's Hot

    Arabic Edition of Xi Jinping: On Respecting and Protecting Human Rights Launched in Cairo

    September 29, 2023

    CGTN: Mid-Autumn Festival: Xi Jinping’s nostalgia

    September 29, 2023

    Maritime’s green future priced at $28 billion annually until 2050 by UNCTAD

    September 29, 2023
    Facebook X (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

    UAE and India discuss strategic ties at UNGA78 in New York

    September 26, 2023

    Leaders of UAE and Netherlands convene to reinforce mutual cooperation

    September 26, 2023

    UN calls for greater female representation in police forces worldwide

    September 8, 2023

    Africa faces skyrocketing costs of climate change, projected to reach $440 billion

    September 5, 2023

    Revolutionary acoustic study sets new standard for marine conservation in the UAE

    September 2, 2023

    MENA Newswire reconfigures the algorithm of organization generated content

    September 1, 2023
    Latest News
    Business

    Maritime’s green future priced at $28 billion annually until 2050 by UNCTAD

    September 29, 2023

    The United Nations Conference on Trade and Development (UNCTAD) has sounded the alarm for a swift and…

    World Tourism Day 2023 calls for sustainable growth in tourism

    September 26, 2023

    UAE and India discuss strategic ties at UNGA78 in New York

    September 26, 2023

    Leaders of UAE and Netherlands convene to reinforce mutual cooperation

    September 26, 2023

    From India to Brazil, leadership transition marks G20 Summit’s conclusion

    September 11, 2023

    African Union Inducted into G20 on India’s Initiative

    September 9, 2023

    Biden and Modi cement ties as India ascends global stage

    September 9, 2023

    UN calls for greater female representation in police forces worldwide

    September 8, 2023
    © 2021 Algeria News Hub | All Rights Reserved
    • Home
    • Contact Us

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