Prin utilizarea acestui site, sunteți de acord cu Politica de confidențialitate.
Accepta
EnterineEnterineEnterine
  • ACASĂ
  • Pro
  • Tehnologie
  • Microsoft
    • Azur
    • ConfigMgr/SCCM
    • Dpm
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Birou 365
    • Office Insider
    • Putere bi
    • Skype
    • Server SQL
    • Echipe
  • Ferestre
    • Centrul de administrare Windows
    • Client Windows
    • Windows Server
  • Lista de colecție de interogări SCCM
Lectură: New AI features in Office 365 Excel
Redimensionare fontAa
EnterineEnterine
Redimensionare fontAa
  • ACASĂ
  • Pro
  • Tehnologie
  • Microsoft
  • Ferestre
  • Lista de colecție de interogări SCCM
Căutare
  • ACASĂ
  • Pro
  • Tehnologie
  • Microsoft
    • Azur
    • ConfigMgr/SCCM
    • Dpm
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Birou 365
    • Office Insider
    • Putere bi
    • Skype
    • Server SQL
    • Echipe
  • Ferestre
    • Centrul de administrare Windows
    • Client Windows
    • Windows Server
  • Lista de colecție de interogări SCCM
Teh

New AI features in Office 365 Excel

Publicat: February 11, 2024
5 Min Citește
Cota

New AI features in Office 365 Excel.

Cuprins
Introducing intelligent suggestions with IdeasMaking new data types generally available todayInsert Data from PictureCalculating with ease using dynamic arraysFaster LOOKUP and MATCHAvailability
  • Ideas
  • New data types
  • Insert Data from Picture
  • Dynamic arrays

Introducing intelligent suggestions with Ideas

Ideas is an AI-powered insights service that helps people take advantage of the full power of Office. Proactively surfacing suggestions that are tailored to the task at hand, Ideas helps users create professional documents, presentations, and spreadsheets in less time. In Excel, for instance, Ideas helps identify trends, patterns, and outliers in a data set—helping customers analyze and understand their data in seconds. Ideas is generally available in Excel today and will begin rolling out in preview to other apps starting with PowerPoint Online. Simply click the lightning bolt icon in Excel or PowerPoint Online and Ideas will start making recommendations.

Making new data types generally available today

Excel has always been great at helping people make the most of numbers. But now Excel can do even more: It can recognize real-world concepts, starting with Stocks and Geography. This new AI-powered capability turns a single, flat piece of text into an interactive entity containing layers of rich information. For instance, by converting a list of countries in a workbook to “Geography” entities, customers can weave location data into an analysis of their own data. And this new capability—though deceptively simple—opens a whole new world of possibilities. As we add new data types over time, Excel’s rows, columns, cells, logic engine, and tools can be used to organize, analyze, and reason over any combination of numbers and sophisticated entities. The Stocks and Geography data types are generally available today.

Insert Data from Picture

With Insert Data from Picture, you can take a picture of a hand-drawn or printed data table with your Android device and convert that analog information into an Excel spreadsheet with a single click. New image recognition functionality automatically converts the picture to a fully editable table in Excel, eliminating the need for you to manually enter data. Insert Data from Picture will be available in preview for the Excel Android app soon.

Calculating with ease using dynamic arrays

With dynamic arrays, we continue to invest in making advanced formulas easier to use. Using dynamic arrays, any formula that returns an array of values will seamlessly “spill” into neighboring unoccupied cells, making it as easy to get an array of values returned as it is to work on a single cell. You can immediately harness the power of dynamic arrays by using one the new FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, SINGLE, and RANDARRAY functions to build spreadsheets that would previously have been nearly impossible. So now, rather than writing many complex formulas to solve a multi-cell problem, you can write one simple formula and get an array of values returned.

Faster LOOKUP and MATCH

We’re not only adding new capabilities to Excel, we’re also continually improving the features customers already know and love. For example, we have invested in significant performance improvements for important lookup functions. We’re pleased to announce that VLOOKUP, HLOOKUP, and MATCH functions operating on large data sets will now execute in seconds instead of minutes. We’ve also improved performance on many key operations like copy/paste, undo, conditional formatting, cell editing, cell selection, filtering, file open, and programmability.

Availability

  • Ideas will be available starting today.
  • New data types are rolling out to users of Excel in Office 365, in the English language only starting today.
  • Performance improvements are rolling out first to Excel in Office 365 starting today.
  • Dynamic arrays is available in preview for users signed up for the Office 365 Insiders Program starting today.
  • The Insert Data from Picture feature will be available in preview for users signed up for the Office 365 Insiders Program on the Android Excel app soon.
Etichetat:Microsoft ExcelMicrosoft Office 365
Articolul precedent Download VLC Media Player 3.0.4 x64 MSI
Articolul următor Lista de colecție de interogări din Configuration Manager Configuration Manager The legacy package does not have exactly one content
Lasă un comentariu Lasă un comentariu

Lasă un răspuns Anulează răspunsul

Adresa ta de e-mail nu va fi publicată. Câmpurile obligatorii sunt marcate *

Acest site folosește Akismet pentru a reduce spamul. Aflați cum sunt procesate datele comentariilor dvs.

Traducere

English中文(简体)DanskNederlandsFrançaisDeutschItaliano한국어PolskiPortuguêsRomânăEspañolУкраїнська
de Transposh - translation plugin for wordpress

Postări populare

Cerințe de sistem pentru Windows Server 2016
Windows Server
Lista de colecție de interogări din Configuration Manager
Lista de colecție de interogări din Configuration Manager
Configmgr
Navigarea structurată/gestionată este activată în paginile moderne din site-urile clasice ale echipelor
Teh
SCCM nu s-a obținut locațiile DP ca versiune așteptată de la MP
Configmgr

Postări recente

Lista de colecție de interogări din Configuration Manager
System Center Configuration Manager Technical Preview Update 1611
Configmgr
Instalarea și configurarea Fail2ban pentru protecție SSH pe Ubuntu 24.04
Linux
How to Check Timezone in Linux
Linux
Activarea și configurarea FirewallD pe AlmaLinux
Linux

© 2023 Enterine

Accesați versiunea mobilă
Bine ai revenit!

Conectați-vă la contul dvs

Nume de utilizator sau adresă de e-mail
Parolă

Ți-ai pierdut parola?