List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable. Sort data in a PivotTable or PivotChart.

Basics. Basic tasks in Excel. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells.

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.

Note: XLOOKUP is not available in Excel 2016 and Excel 2019, however, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it created by someone else using a newer version of Excel. Syntax.

The order in which Excel performs operations in formulas. Using functions and nested functions in Excel formulas. Define and use names in formulas. Guidelines and examples of array formulas. Delete or remove a formula. How to avoid broken formulas. Find and correct errors in formulas. Excel keyboard shortcuts and function keys. Excel functions ...

To add an option button, select the Developer tab, select Insert, and under Form Controls, select . Click in the cell where you want to add the check box or option button control. Tip: You can add only one checkbox or option button at a time. To speed things up, after you add your first control, right-click it and select Copy > Paste.

If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file.

Newer versions Office 2016. Get an Office add-in for Excel. Click File > Get Add-ins. You can directly install an add-in on the page or click More Add-ins to explore. Or you can also select Home > Add-ins >More Add-ins. In the Office Add-ins box, select My Add-ins to view your add-ins.