| Functions in English | Functions in French | Description of Function |
|---|
| ADDRESS | ADRESSE | Returns a reference as text to a single cell in a worksheet. |
| AREAS | ZONES | Returns the number of areas in a reference. |
| CHOOSE | CHOISIR | Chooses a value from a list of values. |
| CHOOSECOLS | CHOISIRCOLS | Returns the specified columns from an array (365). |
| CHOOSEROWS | CHOISIRLIGNES | Returns the specified rows from an array (365). |
| COLUMN | COLONNE | Returns the column number of a reference. |
| COLUMNS | COLONNES | Returns the number of columns in a reference. |
| DROP | EXCLURE | Excludes a specified number of rows or columns from the start or end of an array (365). |
| EXPAND | ETENDRE | Expands or pads an array to specified row and column dimensions (365). |
| FIELDVALUE | VALEURCHAMP | Retrieve field data from linked data types like the Stocks or Geography data types (365). |
| FILTER | FILTRE | Filters a range of data based on criteria (365). |
| FORMULATEXT | FORMULETEXTE | Returns the formula at the given reference as text (2013). |
| GETPIVOTDATA | LIREDONNEESTABCROISDYNAMIQUE | Returns data stored in a PivotTable report. |
| GROUPBY | GROUPER.PAR | Groups data by rows based on criteria and applies aggregations (sum, average, etc.) (365). |
| HLOOKUP | RECHERCHEH | Looks in the top row of an array and returns the value of the indicated cell. |
| Functions in English | Functions in French | Description of Function |
|---|
| HSTACK | ASSEMB.H | Appends arrays horizontally and in sequence to return a larger array (365). |
| HYPERLINK | LIEN_HYPERTEXTE | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. |
| IMAGE | IMAGE | Inserts an image into a cell from a URL or file path (365). |
| INDEX | INDEX | Uses an index to choose a value from a reference or array. |
| INDIRECT | INDIRECT | Returns a reference indicated by a text value. |
| LOOKUP | RECHERCHE | Looks up values in a vector or array. |
| MATCH | EQUIV | Looks up values in a reference or array. |
| OFFSET | DECALER | Returns a reference offset from a given reference. |
| PIVOTBY | PIVOTER.PAR | Creates a pivot table by grouping and aggregating data by rows and columns (365). |
| ROW | LIGNE | Returns the row number of a reference. |
| ROWS | LIGNES | Returns the number of rows in a reference. |
| RTD | RTD | Retrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model). |
| SORT | TRIER | Sorts the contents of a range or array (365). |
| SORTBY | TRIERPAR | Sorts the contents of a range or array based on the values in a corresponding range or array (365). |
| TAKE | PRENDRE | Returns a specified number of contiguous rows or columns from the start or end of an array (365). |
| TOCOL | DANSCOL | Returns the array in a single column (365). |
| TOROW | DANSLIGNE | Returns the array in a single row (365). |
| TRANSPOSE | TRANSPOSE | Returns the transpose of an array. |
| TRIMRANGE | SUPPR.PLAGE | Removes empty rows or columns around a data range (365). |
| UNIQUE | UNIQUE | Returns a list of unique values in a list or range (365). |
| VLOOKUP | RECHERCHEV | Looks in the first column of an array and moves across the row to return the value of a cell. |
| VSTACK | ASSEMB.V | Appends arrays vertically and in sequence to return a larger array (365). |
| WRAPCOLS | ORGA.COLS | Wraps the provided row or column of values by columns after a specified number of elements (365). |
| WRAPROWS | ORGA.LIGNES | Wraps the provided row or column of values by rows after a specified number of elements (365). |
| XLOOKUP | RECHERCHEX | Searches a range or an array, and then returns the item corresponding to the first match it finds (365). |
| XMATCH | EQUIVX | Searches for a specified item in an array or range of cells, and then returns the item's relative position (365). |