Create and manage Worksheets and Workbooks 

Create Worksheets and Workbooks

Create a workbook

Import data from a delimited text file

Add a worksheet to an existing workbook

Copy and move a worksheet

Navigate in Worksheets and Workbooks

Search for data within a workbook

Navigate to a named cell, range or workbook element

Insert and remove hyperlinks

Format Worksheets and Workbooks

Change worksheet tab colour

Rename a worksheet

Change worksheet order

Modify page setup

Insert and delete columns or rows

Change Workbook themes

Adjust row height and column width

Insert headers and footers

Customize options and views for Worksheets and Workbooks

Hide or unhide worksheets

Hide or unhide columns and rows

Customize the Quick Access toolbar

Change workbook views

Change window views

Modify document properties

Change magnification by using zoom tools

Display formulas

Configure Worksheets and Workbooks for Distribution

Set a print area

Save workbooks in alternative file formats

Print all or part of a workbook

Set print scaling

Display repeating row and column titles on multiple worksheets

Inspect a workbook for hidden properties or personal information

Inspect a workbook for accessibility issues

Inspect a workbook for compatibility issues

Manage data cells and Ranges 

Insert data in cells and ranges

Replace data

Cut, copy or paste data

Paste data by using special paste options and fill cells by using Auto Fill

Insert and delete cells

Format cells and ranges

Merge cells

Modify cell alignment and indentation

Format cells by using Format Painter

Wrap text within cells

Apply number formats

Apply cell formats; apply cell styles

Summarize and organize data

Insert sparklines

Outline data

Insert subtotals

Apply conditional formatting

Create tables 

Create and manage tables

Create an Excel table from a cell range

Convert a table to a cell range

Add or remove table rows and columns

Manage table styles and options

Apply styles to tables

Configure table style options

Insert total rows

Filter and sort a table

Filter records

Sort data by multiple columns

Change sort order

Remove duplicate records

Perform operations with formulas and functions 

Summarize data by using functions

Insert references

Perform calculations by using the SUM function

Perform calculations by using MIN and MAX functions

Perform calculations by using the COUNT function

Perform calculations by using the AVERAGE function

Perform conditional operations by using functions

Perform logical operations by using the IF function

Perform logical operations by using the SUMIF function

Perform logical operations by using the AVERAGEIF function

Perform statistical operations by using the COUNTIF function

Format and modify text by using functions

Format text by using RIGHT, LEFT and MID functions

Format text by using UPPER, LOWER and PROPER functions

Format text by using the CONCATENATE function

Create charts and objects 

Create charts

Create a new chart

Add additional data series

Switch between rows and columns in source data

Analyse data by using Quick Analysis

Format graphic elements

Resize charts

Add and modify chart elements

Apply chart layouts and styles

Move charts to a chart sheet

Insert and format objects

Insert text boxes and shapes

Insert images

Modify object properties

Add alternative text to objects for accessibility