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

Dec 4-15: Find a few bargains on computers, books, and lots more - 12 Days of Deals on

2016/12/01: How to make a Marimekko chart in Excel, either manually or with an add-in

2016/11/29 - Dashboard Webinar: Attend one of Mynda Treacy's free Excel Dashboard webinars this week. Lots of great tips packed into the 1 hour presentation.

2016/11/28 - Power Query and Data Cleansing: Free Power Query and Data Cleansing webinar presented by John and Oz at MyExcelOnline. Learn how to transform messy data and automate reports.

2016/11/02: Use this macro to list all pivot tables in Excel file -- helps with troubleshooting in a complex workbook.

2016/12/02: 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: December 4, 2016 10:04 AM
Contextures RSS Feed