Excel help
Learn: Excel tutorials
Create your first workbook using Excel 2016
- Explore Excel 2016
- Find commands quickly with Tell Me
- Create a workbook using a template
- Create a basic chart
- Save a workbook to the cloud
Top solutions
What's new in Excel 2016?
Getting Started
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
Fix text-formatted numbers by applying a number format
Save and Share Files
Save a workbook in another file format
Save an Excel 2013 workbook for compatibility with earlier versions of Excel
Work together on Office documents in OneDrive
Use a shared workbook to collaborate
Why do I get an "Unprotected Formula" message?
Password protect worksheet or workbook elements
Sorting and filtering
Formulas
Find and fix a circular reference
Use error checking to detect errors in formulas
Define and use names in formulas
Create a formula by using a function
Use a formula to apply conditional formatting in Excel 2013
Guidelines and examples of array formulas
Popular Functions
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
Charts and Shapes
Add a trend or moving average line to a chart
Change the display of chart axes
Printing
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
Print the top row on every page
Customizing 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