Excel Tips and Tutorials

An extensive collection of easy-to-follow Excel tutorials, with videos, sample files and written 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/08/18: Quick ways to unpivot Excel data, so you're ready to build a pivot table

2016/08/04: After a recent Microsoft update, some Excel add-ins are not loading correctly. To fix that problem, you can, follow the instructions here, to unblock the files. Read the background story on the blog.

2016/07/20: Use this macro to quickly get rid of "sum of" in Excel pivot table headings. For selected pivot table only, or all pivot tables.

2016/08/05: 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

Buy Now!

Gluten-Free Links

Twitter I'm on Twitter

on Google+


Last updated: August 19, 2016 8:15 AM
Contextures RSS Feed