Excel Tips and Tricks

This page links to instructions for how to handle various tasks in Excel. If there’s something you don’t see, or if you have questions about how to do something, email me at Nick@Nick-Ware.com.

Pivot Tables

VLOOKUPS

Creating a Dropdown List

Combining Cells and Splitting One Cell Into Multiple

Concatenate Function

IF Function

COUNTIF Function

SUMIF Function

Highlighting and Removing Duplicates