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

Dashboards: Ben Collins shows how to build interactive dashboards with free Google Sheets tools, in his new course. Get it for half price today, Friday Feb. 24th.

Subtotals Problem: Pivot table subtotals have changed, for grouped items, in the latest version of Excel 2016 (subscription). Learn about the change, and how to avoid problems.

Pivot Tables: Pivot table report filters don't have Sort options. Use this macro to quickly sort all the report filters

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 24, 2017 9:35 AM
Contextures RSS Feed