Enter and format data

Enter data manually in worksheet cells

Fill data automatically in worksheet cells

Turn Flash Fill on in Excel 2016

Move or copy worksheets or worksheet data 

Create a list of sequential dates 

Create a custom list

Select cells, ranges, rows, or columns on a worksheet

Copy visible cells only

Move or copy cells and cell contents

Paste options

Locate hidden cells on a worksheet

Find or replace text and numbers on a worksheet

Find and remove duplicates

Available number formats

Apply or remove cell borders

Format numbers

Format numbers as percentages

Format a date the way you want

Format text in cells

Format numbers as dates or times

Format numbers as currency

Keeping leading zeros and large numbers

Create or delete a custom number format

Hide or show gridlines on a worksheet

Change the case of text

Convert numbers stored as text to numbers

Wrap text in a cell

Align or rotate text in a cell

Use conditional formatting to highlight information

Hide or show worksheets or workbooks 

Insert or delete cells, rows, and columns 

Hide or show rows or columns

Move or copy cells

Change the column width and row height 

Merge and unmerge cells 

Combine text from two or more cells into one cell

Split text into different columns with the Convert Text to Columns Wizard

Freeze panes to lock rows and columns

Create, apply, or delete a custom view

Lock or unlock specific areas of a protected worksheet

Turn off Scroll Lock 

Split panes to lock rows or columns in separate worksheet areas

Automatically number rows

Group or ungroup shapes, pictures, or other objects 

Insert or delete a worksheet

Split text into different columns with functions

Combine two or more columns by using a function

Consolidate data in multiple worksheets

Apply data validation to cells 

More on data validation

Create a drop-down list

Add or remove items from a drop-down list

Remove a drop-down list

Customize the QAT (Quick Access Toolbar)

Customize the ribbon in Office

View two or more worksheets at the same time