Hide error values and error indicators in cells - Microsoft Support
Learn how to use IFERROR function, conditional formatting, or custom number format to hide error values and indicators in Excel cells. See examples of common error values and how to convert them to zero or dash.
Create a drop-down list - Microsoft Support
Learn how to create a drop-down list in Excel by using data validation and a table. Follow the steps to type the list items, select the cell, and set the settings for input message and error alert.
Create a parameter query (Power Query) - Microsoft Support
Learn how to use parameters in Power Query to change data sources, filter data, or specify values. Parameters can be stored in cells or created in a simple parameter query.
Consolidate multiple worksheets into one PivotTable
Learn how to combine data from different sources into one PivotTable using page fields, named ranges, or 3D references. This article also explains how to consolidate data without using page fields and how to use Power Query for Excel.
Lock or unlock specific areas of a protected worksheet
Learn how to protect a worksheet and enable some cell editing, while leaving other cells locked. Follow the steps to unlock specific cells and ranges, or use passwords or permissions to allow users to edit certain areas.
Create a relationship between tables in Excel - Microsoft Support
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
How to correct a #NAME? error - Microsoft Support
The #NAME? error occurs when there is a typo, a missing name, or a syntax issue in your Excel formula. Learn how to use the Formula Wizard, the Function Wizard, and other tips to avoid and fix this error.
XMATCH function - Microsoft Support
The XMATCH function searches for a specified item in an array or range of cells, and then returns the item's relative position. Assume we have a list of products in cells C3 through C7 and we wish to determine where in the list the product from cell E3 is located. Here, we'll use XMATCH to determine an item's position within a list. Syntax.
Guidelines and examples of array formulas - Microsoft Support
Learn how to use array formulas to perform multiple calculations on one or more items in an array. See how to create dynamic and legacy array formulas, and download an example workbook with various array formula tasks.
NETWORKDAYS function - Microsoft Support
Learn how to use the NETWORKDAYS function to calculate the number of whole working days between two dates, excluding weekends and holidays. See the formula syntax, arguments, examples, and tips for Excel for Microsoft 365, Mac, and web.
Add or remove a border on a text box, shape, or SmartArt graphic
Learn how to set the border of a text box, shape, or SmartArt graphic to No Outline and remove it completely. Follow the steps for Excel, Word, or Outlook and see the options for line thickness, style, and color.