Excel from Scratch Contents

Introduction and Navigation

Open Excel

Workbook

Ribbon

Show/Hide the Ribbon

Quick Access

Save a Workbook

Open a Workbook

Sheet

Create a Sheet

Rename a Sheet

Delete a Sheet

Navigate between Sheets

Navigate within a Sheet

Rows, Columns and Cells

Selection

Select one Cell

Select Multiple, Connected Cells

Select Multiple, Separated Cells

Select Row(s)

Select Column(s)

Select a Range(s)

Enter Text or Numbers

Cell Content Alignment

Insert and Delete Rows and Columns

Insert a Row or Column

Delete Cells, Rows or Columns

Resize Rows and Columns

Manually Resize Columns and Rows

Auto-Fit a Column

Wrap Text

Format >Cell Size

Cell Names

Default Cell Name

Custom Cell Name

Name Box at Multiple Selected Cells

Range Name

Cut, Copy and Paste

Cut

Copy

Paste

Paste Special

Calculation A

Formulas Introduction

Number + Text

Relative and Absolute References

Relative Reference

Absolute Reference

Filling

How to Fill

Fill Formulas with Double-Click

Content Behavior

Fill Series

Formulas for Basic Calculation

Start and End a Formula

Check Formula

AutoSum

Addition Formulas

Subtraction Formula

Multiplication Formula

Division Formula

Combinations

Quick Analysis Totals

Cell Formatting

Office Tools

Cell Styles

Number Formatting

The Format Cells Dialog

Modify Cell Format

Number

Custom Format

Alignment

Font

Border

Fill

Protection

Conditional Formatting

Quick Analysis Formatting

Conditional Formatting Rules

Clear Conditional Formatting

Copy Format

Copy Format to One Cell

Copy Format to Multiple Cells

Basic Visualization

Sparklines

Insert via Quick Analysis

Insert via the Ribbon

Clear Sparklines

Chart

The Insert Chart Dialog

Quick Analysis

The Insert Tab

Move a Chart

Chart Elements

Add Chart Elements

Remove Chart Elements

Resize a Chart or Element

Customize a Chart

Office Tools

Chart Shortcuts

The Chart Design and Format Tabs

Align Charts

Tables and Table Tools

Format a Range as a Table

Quick Analysis

Format as Table Button

Ctrl + T

Exceptions

Filter and Sort

Filter Cell Values

Sort Cell Values

Expand the Table

Table Design

Table Name

Slicer

Total Row

External Table Data

Data Source Settings

Refresh

Connection Properties

Open or Import CSV Files

Open

Import

Export to SharePoint

Column Headers in Formulas

Miscellaneous

Text Boxes

Insert a Text Box

Move a Text Box

Delete a Text Box

Customize a Text Box

Home Tab

Shape Format Tab

Hide and Unhide Rows and Columns

Hide and Unhide Rows

Hide and Unhide Columns

Freeze Panes

Split into Columns

Flash Fill

Data Validation

List Example

Circle Invalid Data

Protect Workbook

Protect Sheet

Unlock Cells in Locked Sheet

Lock Cells in Unlocked Sheet

Scrollbar / Slider

Calculation B

Bind Sheets

Connect Sheets in the Same Workbook

Connect Sheets in Different Workbooks

Calculate Time Differences

Functions

AutoSum options

Formulas with Functions

MAX, MIN, MEDIAN and AVERAGE

TRUNC and ROUND

TODAYand NOW

WEEKNUM and WEKKDAY

The Function Wizard

Logical IF

DAVERAGE and DSUM

VLookup, HLOOKUP and XLOOKUP

Combine Functions

Text Functions

10.2.1 LEN

Pick Text

What-If Analysis

The Scenario Manager

The Goal Seek

The Data Table

Pivot Table, Pivot Chart

Pivot Table Introduction

Create from Quick Analysis

Create from the Ribbon

Create a Blank Pivot Table

Pivot Table View

Arrrange Fields

Rename Headers

Value Field Settings

Show Values As

Filter and Sort Data

Group Data

Ribbon Tabs

Drilling

Expand and Collapse

Show Details

Pivot Chart

Create a Pivot Chart

Pivot Chart Ribbon Tabs

Data Retention

Date Filter, Timeline