Get started
Find or replace text and numbers on a worksheet
Change the column width and row height
Troubleshoot Problems
Use error checking to detect errors in formulas
Remove or allow a circular reference
Excel opens blank when double clicking an icon or file name
Excel problems caused by a Windows 10 DisplayLink driver
Worksheet basics
Find or replace text and numbers on a worksheet
Split text into different cells
Combine text from two or more cells into one cell
Convert text-formatted numbers
Transpose (rotate) data from rows to columns or vice versa
Create an Excel table in a worksheet
Save and share files
Share your Excel 2016 workbook with others
Save a workbook in another file format
Save an Excel workbook for compatibility with earlier versions of Excel
Use a shared workbook to collaborate
Protect a worksheet with or without a password
Remove a password from a worksheet or workbook
Sort and filter
Quick start: Sort data in an Excel worksheet
Use AutoFilter to filter your data
Filter data in a range or table
Count unique values among duplicates
Formulas
Find and fix a circular reference
Define and use names in formulas
Create a formula by using a function
Use a formula to apply conditional formatting
Guidelines and examples of array formulas
Switch between relative, absolute, and mixed references
Popular functions
Look up values with VLOOKUP, INDEX, or MATCH in Excel 2016
Data analysis
Apply data validation to cells
Create a PivotTable to analyze worksheet data
Add, change, find, or clear conditional formats in Excel for Windows
Create conditional formulas to find data or apply formatting
Use the Analysis ToolPak to perform complex data analysis
Define and solve a problem by using Solver
Analyze trends in data using sparklines
Use Goal Seek to find a result by adjusting an input value
Charts and shapes
Add a trend or moving average line to a chart
Create a combo chart with a secondary axis
Learn more about SmartArt graphics
Headers and footers in a worksheet
Print a worksheet in landscape or portrait orientation
Print rows with column headers on top of every page
Create and print mailing labels for an address list in Excel
Insert, move, or delete page breaks in a worksheet
Print the top row on every page
Preview worksheet pages before you print
Customize Excel
Add or change the background color of cells
Change a theme and make it the default
Create or delete a custom number format
Customize the ribbon in Office
Customize the Quick Access Toolbar
Customize the list of recently used files