Excel help

New: Create a funnel chart

Draw and annotate with ink in Office 2016

New: Black theme for Office 2016

Excel problems caused by a Windows 10 DisplayLink driver

Excel opens blank when double clicking an icon or file name

Repair an Office application

What's new in Excel 2016

Excel 2016 Quick Start Guide

Excel 2016 training

Tips and tricks for working with data in Excel

Communicate and analyze with impact — New charting capabilities

Excel Everywhere: The benefits of using Excel on the web, on mobile, and anywhere

See all videos

Basic tasks in Excel

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 AutoFill

Create a simple formula

Keyboard shortcuts in Excel

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 cells

Fix text-formatted numbers by applying a number format

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

Save a workbook in another file format

Save an Excel workbook for compatibility with earlier versions of Excel

Work together on Office documents in OneDrive

Save as PDF

Use a shared workbook to collaborate

Why do I get an "Unprotected Formula" message?

Password protect a workbook

Protect a worksheet with or without a password

Add or remove protection in your document, worksheet, or presentation

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 a range of data

How to avoid broken 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

Guidelines and examples of array formulas

Switch between relative, absolute, and mixed references

Hide and protect formulas

Create or delete a macro

VLOOKUP function

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 dialog box options

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 Power Map

Create an organization chart using 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

Create or clear a print area on a worksheet

Create manual 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

What's new in Excel 2016 for Mac

Excel 2016 for Mac: Quick Start Guide

Discover Excel 2016 for Mac

Get started with Excel for Mac 2011

Excel Mobile for Windows 10

Excel for iPad

Excel for iPhone

Excel for Android Tablets

Excel for Android Phones