A list of Excel training, from entry level to advanced skills, plus templates and other resources.

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.

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 ...

Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016. Tip: Try using the new XLOOKUP and XMATCH functions, improved versions of the functions described in this article. These new functions work in any direction and return exact matches by default, making them easier and more convenient to use than their predecessors.

Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 More... Less When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together.

Outline (group) data in a worksheet. Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016. 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 ...

On the Data tab, in the Data Tools group or Forecast group (in Excel 2016), click What-If Analysis > Data Table (in the Data Tools group or Forecast group of Excel 2016). In the Row input cell field, enter the reference to the input cell for the input values in the row.

Windows macOS Web. Create a chart. Select data for the chart. Select Insert > Recommended Charts. Select a chart on the Recommended Charts tab, to preview the chart. Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data.

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. To edit a macro that is attached to a Microsoft Excel workbook, you use the Visual Basic Editor. Important: Before you can work with macros, you have to enable the Developer tab. For more information, see Show the Developer tab.

There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.