Top categories

What's New in Excel 2016

Excel 2016 Quick Start Guide

Excel training

Basic tasks in Excel 2016

Find or replace text and numbers on a worksheet

Change the column width and row height

Format numbers as currency

Video: Use Flash Fill

Video: Use Auto Fill

Create a simple formula

Keyboard shortcuts in Excel

How to avoid broken formulas

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

More fixes for recent issues

Create a drop-down list

Find or replace text and numbers on a worksheet

Split text into different cells

Combine text from two or more cells into one cell

Merge and unmerge cells

Convert text-formatted numbers

Wrap text in a cell

Freeze rows and columns

Transpose (rotate) data from rows to columns or vice versa

Create an Excel table in a worksheet

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

Save documents online

Save as PDF

Use a shared workbook to collaborate

Password protect a workbook

Protect a worksheet with or without a password

Remove a password from a worksheet or workbook

Lock cells to protect them

Quick start: Sort data in an Excel worksheet

Filter data in an Excel table

Use AutoFilter to filter your data

Sort data in a PivotTable

Show or hide columns and rows

Filter data in a PivotTable

Sort data using a custom list

Video: Sort and filter data

Sort data in a range or table

Filter data in a range or table

Count unique values among duplicates

How to avoid broken formulas

Find and fix a circular reference

Detect errors in formulas

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

Display or hide formulas

Create or delete a macro

VLOOKUP function

Look up values with VLOOKUP, INDEX, or MATCH in Excel 2016

IF function

SUM function

COUNTIF function

SUMIF function

LOOKUP function

CONCATENATE function

MATCH function

Excel functions (by category)

Apply data validation to cells

Analyze your data instantly

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

Load the Analysis ToolPak

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

Create a chart

Create a histogram

Add a pie chart

Add a trend or moving average line to a chart

Available chart types

Add shapes

Create a combo chart with a secondary axis

Get started with 3D Maps

Learn more about SmartArt graphics

Add a watermark in Excel

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

Set a specific print area

Insert, move, or delete page breaks in a worksheet 

Print the top row on every page

Preview worksheet pages before you print

Show or hide gridlines

Add or change the background color of cells

Change a theme and make it the default

Create or delete a custom number format

Add or remove add-ins

Customize the ribbon in Office

Customize the Quick Access Toolbar

Customize the list of recently used files

Where are my custom templates?

Excel specifications and limits