Subscribe to Updates

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

    What's Hot

    CGTN: How China keeps its promise to build a community of common health for mankind

    March 25, 2023

    The third largest fish producer in the world, India accounts for 8 percent of global production

    March 25, 2023

    Canadian legislature laughs after Biden accidentally applauds China

    March 25, 2023
    Facebook Twitter Instagram
    Iran MirrorIran Mirror
    • Automotive
    • Business
    • Entertainment
    • Health
    • Lifestyle
    • Luxury
    • News
    • Sports
    • Technology
    • Travel
    Iran MirrorIran Mirror
    Home » Microsoft Excel formulas are getting smarter with enhanced features
    News

    Microsoft Excel formulas are getting smarter with enhanced features

    December 29, 2022

    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 Telegram Reddit Email

    Related Posts

    Canadian legislature laughs after Biden accidentally applauds China

    March 25, 2023

    An oasis of tranquility for the diverse Abu Dhabi community – Abrahamic Family House

    March 24, 2023

    Global climate action will be supported by Egypt and UAE at COP28

    March 10, 2023

    UAE President receives Libyan Prime Minister

    February 16, 2023

    Sheikh Mohammed met with the Prime Minister of Azerbaijan

    February 16, 2023

    Cyclone Gabrielle battered the North Island of New Zealand killing three

    February 15, 2023
    Editor's Pick

    The third largest fish producer in the world, India accounts for 8 percent of global production

    March 25, 2023

    Parshottam Rupala, the Indian Minister of Fisheries, Animal Husbandry and Dairy Industry of the Central…

    Canadian legislature laughs after Biden accidentally applauds China

    March 25, 2023

    An oasis of tranquility for the diverse Abu Dhabi community – Abrahamic Family House

    March 24, 2023

    Global climate action will be supported by Egypt and UAE at COP28

    March 10, 2023

    UAE President receives Libyan Prime Minister

    February 16, 2023

    Sheikh Mohammed met with the Prime Minister of Azerbaijan

    February 16, 2023
    © 2023 Iran Mirror | All Rights Reserved
    • Home
    • Contact Us

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