Excel Tips and Tutorials

An extensive collection of easy-to-follow Excel tutorials, with videos, free workbooks and step-by-step instructions.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z | Pivot Tables Blog

Video Index | Pivot Table Index | VLOOKUP | COUNT | SUM

What's New

Filter a List: Two ways to filter Excel data for items in a list: 1) exact matches only, 2) partial match in cell contents.

Pivot Table Problem: How to troubleshoot an Excel pivot table with missing pivot items

See a list of previous What's New items, and see more on the Excel Events page.

Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.


pivot power free




Excel Data Entry Popup List



chart tools


Gluten-Free Links

Twitter I'm on Twitter

on Google+


Last updated: May 18, 2017 8:43 AM
Contextures RSS Feed