Excel Tips and Tutorials

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

Topic Index | 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

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

What's New

2016/09/23: John and Oz have opened registration to their new course: The Ultimate Excel Power Query & Data Cleansing Online Course. Get 20% off with the coupon code CONTEXTURES -- closes Sept 30th.

2016/09/22: Instead of an in-cell drop down list, show a combo box with bigger font and autocomplete. Now works with simple dependent data validation too.

2016/09/20: How pivot table grand totals are created, and which grand total headings you can change.

2016/09/23: For a bit of humour, read my weekly collection of Excel tweets. See what people are saying about our favourite spreadsheet.

See a list of previous What's New items.

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 premium



Excel Data Entry Popup List




chart tools


Gluten-Free Links

Twitter I'm on Twitter

on Google+


Last updated: September 23, 2016 7:04 PM
Contextures RSS Feed