Excel Intermediate

Worksheet Management

Navigation

• Keyboard shortcuts that facilitate quick and easy navigation within cells

Formula Review

• Review various methods for completing calculations

Working with Text

Splitting Text

• Use Text to Columns to split text into multiple cells

Joining Text

• Join text from separate cells

Cell Ranges

Paste Special

• Apply formats and perform calculations on selected cells

Paste Special Values

• Hardcode the answer to a formula or function

Named Ranges

• Assign a name to a range of cells to make it easier to reference those ranges in calculations

Database Functions

VLOOKUP & XLOOKUP

• Use VLOOKUP and XLOOKUP to find information in a cell range and return information from another cell range

Sort & Filter

• Use Sort & Filter to find and organize data in large databases

Pivot Tables

Pivot Tables

• Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

• Group within Pivot Tables

Multiple Pivot Tables

• Create multiple Pivot Tables on a single worksheet

Logical Functions

IF statements

• Use IF statements to return output based on the contents of another cell

AND, OR

• Tests to see whether multiple conditions are true