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

Excel Add-ins: After a recent Microsoft update, some Excel add-ins (mine and others) are not loading correctly. I'll post an update here if that is fixed. In the meantime, to show the add-in, follow the instructions here.

2016/07/21: How to show an Excel table name on the worksheet, by using a special formula from AlexJ

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/07/22: 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.

 Get Excel News

 Get Excel News




Excel Data Entry Popup List


Buy Now!

Gluten-Free Links

Twitter I'm on Twitter

on Google+


Last updated: July 28, 2016 12:38 PM
Contextures RSS Feed