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 specify. Database Required. The range of cells that makes up the list or database.
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 employee ID.
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 group at one time, such as adding a shape fill or effect, or an effect to a picture.
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 type, Stocks, is used in cells A2 through A11. Then in columns B and C, there are formulas that extract more information from the Stocks data type in column 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, select Number from the drop-down. Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number.
Digital signatures and certificates - Microsoft Support
Digital signatures support this change by providing assurances about the validity and authenticity of a digital document. For more information, see Add or remove a digital signature in Office files. What do you want to do? What is a digital signature?
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 appear. To specify the control properties, right-click the control, and then click Format Control. Add a label and text box to an Excel worksheet.
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 (number, from_unit, to_unit) Number is the value in from_units to convert. From_unit is the units for number. To_unit is the units for the result.
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 Optional. The cell or range of cells for which you want to return the column number.
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.
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 by Microsoft 365, and are available in the latest versions of Office applications (see the Cloud fonts availability table, below).