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

Excel Macros -- Watch the recording of Jon Acampora's free webinar, The 7 Steps to Getting Started with Macros & VBA. This ends on Thursday, Oct. 27th, so go and watch it now!

2016/10/20: Show data validation error messages to help people enter data correctly. Or, turn error warnings off, to allow other entries in a cell.

2016/10/18: New items appear at end of Excel pivot table lists, not alphabetical. How to fix the problem

2016/10/21: 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: October 24, 2016 1:46 PM
Contextures RSS Feed