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

VLOOKUP Fix: How to fix VLOOKUP formulas with #N/A errors, caused by numbers that don't match the lookup table values.

Pivot Tables: Use a macro to list all pivot fields and pivot items in an Excel pivot table

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

Power BI Webinar

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: February 16, 2017 9:42 AM
Contextures RSS Feed