DGET function - Microsoft Support
This article describes the formula syntax and usage of the DGET function in Microsoft Excel. Extracts a single value from a column of a list or database that matches conditions that you …
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their …
How to write formulas that reference data types - Microsoft …
You can use formulas that reference linked data types. This allows you to retrieve and expose more information about a specific linked data type. In the following example, the linked data …
Group or ungroup shapes, pictures, or other objects - Microsoft …
Grouping lets you rotate, flip, move, or resize all shapes or objects at the same time as though they were a single shape or object. You can also change the attributes of all of the shapes in a …
Available number formats in Excel - Microsoft Support
In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, …
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. CONVERT …
COLUMN function - Microsoft Support
For example, the formula =COLUMN (D10) returns 4, because column D is the fourth column. COLUMN ( [reference]) The COLUMN function syntax has the following argument: reference …
Cloud fonts in Office - Microsoft Support
2024年6月11日 · Use cloud fonts to make sure your slides and documents look the same, no matter where you open them or who else views them. Cloud fonts are fonts hosted in the cloud …
Recover your Microsoft 365 files - Microsoft Support
How to open, save, or delete a recovered version of your Microsoft 365 file using the Document Recovery task pane.
Tips for improving Excel's performance - Microsoft Support
We've again made substantial performance improvements to Aggregation functions (SUMIFS, COUNTIFS, AVERAGEIFS, etc.), RealtimeData (RTD), and lots more for significant decreases …
Add a label or text box to a worksheet - Microsoft Support
You can add labels to forms and ActiveX controls. Click Developer, click Insert, and then click Label . Click the worksheet location where you want the upper-left corner of the label to …