CTSS - Level Up

Resource Files

What is Excel?

Create a New Workbook

Insert or Delete a Worksheet

Move or Copy Worksheets or Worksheet Data

Use Excel as a Calculator

Fill Data Automatically

Create a Drop-down List

Try-It Exercise: Print in Excel

Insert or Delete Rows and Columns

Select Cell Contents

Lock Rows and Columns

Hide or Show Rows or Columns

Filter Data and Remove Duplicates

Split Text Into Different Columns

Create a List of Sequential Dates

Try-It Exercise: Create Sequential Dates

Move or Copy Contents

Change Column Width or Row Height

Find or Replace Text and Numbers on a Worksheet

Merge and Unmerge Cells

Validate Cell Data

Try-It Exercise: Import and Export Text Data

Types of Numbers in Excel

Conditional Formatting

Align or Rotate Text

Change the Format

Copy Cell Formatting

Add a Watermark

Display or Hide Zero Values

Create a Custom Number Format

Try-It Exercise: Change Excel Format

Overview of Formulas

XLOOKUP Function

VLOOKUP Function

SUM Function

COUNTIF Function

IF Function

IFS Function

SUMIF Function

MATCH Function

Try-It Exercise: Create a Cell Reference