Search Contextures Sites

Contextures News, Services & Publications

What's New

Blog - Paste Into Filtered List

Paste Into Filtered List

Pivot - Hide Errors

Hide Errors

Microsoft Excel Design and Programming

Contextures has been designing Excel spreadsheets since 1987. Please contact us for help with your project.

Sample projects include:

  • Pricing calculators for sales offices -- steel building manufacturer
  • Insurance application forms -- insurance company
  • Data entry form -- pet food company
  • Production scheduler -- furniture manufacturer
  • Customized sales reports -- food manufacturer
  • Client location analysis -- pharmaceutical company

Microsoft Access Database Design

Contextures has been designing Access databases since 1996. Please contact us for help with your project.

Sample projects include:

  • Order processing -- steel building manufacturer
  • Budget tracking -- office equipment company
  • Cash clearing system -- insurance company
  • Corporate donations -- financial institution
  • Sales forecasting -- food manufacturer
  • Project time tracking -- forestry company

Popular Excel Articles on Contextures


Contextures has created several Excel based products, and you can see the details on our Contextures Products page.

To see a few key features of our PivotPower Premium add-in, please watch this short video demonstration.


Beginning Pivot Tables in Excel 2007 by Debra Dalgleish

September 24, 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.

  • Carefully explains the benefits of using Pivot Tables for fast data analysis
  • Provides a step-by-step approach to those new to Pivot Tables
  • Offers tips and tricks for working with pivot tables

    Begin Pivot Tables 2007 Table of Contents

Excel 2007 Pivot Tables Recipes by Debra Dalgleish

December 10, 2007

This book assumes that you know the basics of Excel and pivot tables, and provides troubleshooting tips and techniques, and programming examples.

This book is for anyone who uses pivot tables, and who only reads the manual when all else fails. It's designed to help you understand the advanced features and options that are available, as you need them. Experiment with pivot tables, and if you get stuck, search for the problem in this book. With luck, you'll find a solution, a workaround, or, occasionally, confirmation that pivot tables can't do what you want them to do.

Excel 2007 Pivot Table Recipes Table of Contents

Excel Pivot Tables Recipe Book by Debra Dalgleish

March 2006

Excel Pivot Tables Recipe Book is for anyone who uses Excel frequently. This 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.

The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for.

There's no fuss to this book, only clear and precise information to help you assess your situation--whether common or unique--and solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.

Pivot Table Recipes Table of Contents

More From Contextures

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


Excel news
by email












Privacy Policy


Contextures Inc., Copyright 2014
All rights reserved.


Last updated: April 24, 2014 10:33 AM