Excel

Microsoft Excel is a spreadsheet software which arranges numerical or text data in spreadsheets or workbooks.

Excel logo
© Microsoft 2020.

Quick Start

Create a new workbook

Insert or delete a worksheet

Move or copy worksheets or worksheet data

Print a worksheet or workbook

Share your Excel workbook with others

Beginner

Excel Basics

SUM Function

COUNT Function

AVERAGE Function

Time & Date

Rows and Columns

Inserting or deleting rows, and columns

Automatically number rows

Combine text from two or more cells into one cell

Align or rotate text in a cell

Change the format of a cell

Copy cell formatting

Intermediate

Cells

Move or duplicate cells and cell contents

Number Formatting in Excel

Define and use names in formulas

Formatting

Conditional formatting

Align or rotate text in a cell

Change the format of a cell

Copy cell formatting

Add a watermark in Excel

Display or hide zero values

Produce a custom number format

Formulas and functions

Summary of Excel formulas

VLOOKUP

SUM Function

COUNTIF Function

IF Function

IFS

SUMIF

SUMIFS

Automatically number rows

Calculate the difference between two dates

Define and use names in formulas

Combine text from two or more cells into one cell

Tables

Create and format tables

Sort data in a table

Filter data in a range or table

Total the data in an Excel table

Use slicers to filter data

Charts

Create a chart from start to finish

Add or delete titles in a chart

Show or hide a chart legend or data table

Add a trend or moving average line to a chart

Analyse your data instantly

Update the data in an existing chart

Use sparklines to display data trends

Expert

PivotTables

Create a PivotTable to analyse worksheet data

Use the Field List to arrange fields in a PivotTable

Group or ungroup data in a PivotTable

Filter data in a PivotTable

Create a PivotChart

Share and co-author

Share your Excel workbook with others

Comments and notes

Collaborate on Excel workbooks at the same time with co-authoring

See files others have shared with you

Lock or unlock specific areas of a protected worksheet

Protect an Excel file

Save or convert to PDF

%d bloggers like this: