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

Freeze Panes: Tips on how Freeze Panes works, and a macro to freeze all sheets at the selected location

Pivot Tables: How to refresh an Excel pivot table on a protected sheet, manually or with a macro

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: March 23, 2017 9:01 AM
Contextures RSS Feed