| Add or remove a secondary axis in a chart in Excel |
| Collaborate on Excel workbooks at the same time with co-authoring |
| Create a PivotTable to analyze worksheet data |
| Format elements of a chart |
| Lock or unlock specific areas of a protected worksheet |
| Use sparklines to show data trends |
| Add a trend or moving average line to a chart |
| Add a watermark in Excel |
| Add or remove titles in a chart |
| Align or rotate text in a cell |
| Analyze and format in Excel |
| Analyze your data instantly |
| Annotate a worksheet by using comments |
| Apply data validation to cells |
| Automatically number rows |
| Available number formats |
| Calculate the difference between two dates |
| Change the format of a cell |
| Collaborate in Excel |
| Combine text from two or more cells into one cell |
| Conditional formatting |
| Copy cell formatting with the Format Painter |
| COUNTIF function |
| Create a chart from start to finish |
| Create a list of sequential dates |
| Create a PivotChart |
| Create a workbook in Excel |
| Create and format tables |
| Create or delete a custom number format |
| Define and use names in formulas |
| Display or hide zero values |
| Filter data in a PivotTable |
| Filter data in a range or table |
| Filter for unique values or remove duplicate values |
| Find or replace text and numbers on a worksheet |
| Freeze panes to lock rows and columns |
| Group or ungroup data in a PivotTable |
| Hide or show rows or columns |
| IF function |
| IFS |
| Import or export text (.txt or .csv) files |
| Insert or delete cells, rows, and columns |
| Learn more about Excel |
| Merge and unmerge cells |
| Move or copy cells and cell contents |
| Overview of formulas in Excel |
| Protect an Excel file |
| Resize a table, column, or row |
| Save or convert to PDF |
| See files others have shared with you |
| Select cell contents in Excel |
| Set up your Excel mobile app |
| Share your Excel workbook with others |
| Show or hide a chart legend or data table |
| Sort data in a table |
| Split text into different columns with the Convert Text to Columns Wizard |
| SUM function |
| SUMIF |
| SUMIFS |
| Total the data in an Excel table |
| Update the data in an existing chart |
| Use slicers to filter data |
| Use the Field List to arrange fields in a PivotTable |
| VLOOKUP |
