Using Advanced Functions and Summarizing Data

Working with Statistical and Logical Functions

Understanding Absolute vs. Relative Cell References

Using the IF Function to Calculate Based on a Condition

Writing IF Statements

Nesting IF Statements

Using the COUNT Function to Count a List of Numbers

Using the COUNTA Function to Count Non-Empty Cells

Using the COUNTBLANK Function to Count Blank Cells

Using the COUNTIF Function to Count Based on a Condition

Using the COUNTIFS Function to Count Based on Multiple Conditions

Using Text Functions and Features

Using the Text to Columns Feature

Inserting Columns

Splitting Text over Multiple Columns

Using Text Functions

Using the CONCATENATE Function to Join Cells

Using the TRIM Function to Remove Extra Spaces

Using the UPPER, LOWER, and PROPER Functions to Change Case

Using the LEFT, MID, and, RIGHT Functions to Extract Characters

Using the Paste Values Feature

Creating VLOOKUP Formulas

Examining the VLOOKUP Function Syntax

Creating Lookup Tables

Creating Named Ranges

Writing VLOOKUP Formulas

Understanding Common Formula Error

Using the ISERROR Function to Hide Errors

Using PivotTable Reports to Summarize Data

Creating PivotTables to Summarize Data

Changing the PivotTable Field List View

Adding Fields

Grouping Items

Rearranging Fields within the Field List

Using Report Filters

Removing Fields

Changing Value Field Settings

Updating PivotTable with New Source Data