Welcome to Contextures

Thank you for visiting the Contextures website, where you will find Excel tips, tutorials and videos. You can find a list of articles on the Excel Tips page, and the latest and most popular articles are listed below.

What's New

2015/07/06: Excel Roundup: Bullet charts, dashboard export, pivot table rank + more Excel tips

2015/07/03: From July 1 - 10, Jan Karel Pieterse is having a summer sale -- get 25% off his Excel utilities -- RefTreeAnalyser and Excel File Remediation Utility. To get your 25% discount, use this coupon code: JKPADS-Summer2015

2015/07/03: Power Query experts Ken Puls and Miguel Escobar have opened registration for their next online Power Query training. On August 12th and 13th, you'll have live online training (4 hours per day). Then attend a live online follow-up Q&A session, a week later (Aug. 20). The class size is limited, so register early!

2015/07/02: Use the Rank calculation in an Excel pivot table, to make it easier to compare data.

2015/07/03: Weekly collection of Excel tweets, for your Friday entertainment.

Click to see previous "What's New" items or go to the Newsletter Index

Popular Excel Articles on Contextures


Contextures has created several Excel based products, to help you save time, or improve your Excel skills. You can see the details on our Contextures Products page.

One of our most popular products is the PivotPower Premium add-in, with its time-saving pivot table tools.


Debra Dalgleish has written 3 pivot table books, published by Apress. You can purchase the books on Amazon, and click the Table of Contents links below, for more details.

Beginning Pivot Tables in Excel 2007

Beginning Pivot Tables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. It's for those who are new to pivot tables, and those who have used pivot tables in other versions of Excel and want to learn about the new features in Excel 2007.

  • Shows benefits of using Pivot Tables for fast data analysis
  • Step-by-step approach to those new to Pivot Tables
  • Tips and tricks for working with pivot tables

For more details, view the Table of Contents

Excel 2007 Pivot Tables Recipes

Excel 2007 Pivot Tables Recipes assumes that you know the basics of Excel and pivot tables, and provides troubleshooting tips and techniques, and programming examples.

It's designed to help you understand the advanced features and options that are available, as you need them.

For more details, view the Table of Contents

Excel Pivot Tables Recipe Book

Excel Pivot Tables Recipe Book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables -- from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. numerous PivotTable programming examples.

For more details, view the Table of Contents

More From Contextures

In addition to the Excel tutorials that you'll find here, please visit the following blogs, for more Excel and pivot table tips.

For a behind the scenes look at Excel consulting and website management, visit Debra's 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.

Affiliate Disclosure: Contextures is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to

 Get Excel News










Last updated: July 6, 2015 8:48 AM