Products

Here are a few books and Excel related products that will help you in your daily work. The first list shows my products. The second list contains products that I use and recommend. All the links are affiliate links, so if you click a link and buy the product, you’ll help support this blog. Thanks!

My Products

Here is a quick summary of my Excel products, and you can get more details on my Contextures website.

Discounts are automatically applied to your order, if you purchase 2 or more items.

Pivot Power Premium Add-In

The Pivot Power Premium add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:

  • save and apply preferred pivot table settings
  • change all the data fields from the Count function to the Sum function
  • clear old items from an Excel pivot table
  • change all values to a specific number format, such as zero decimals

The Pivot Power Premium creates a Ribbon tab, and is for Excel 2007, and later versions.

Pivot Power Premium Add-in

Excel UserForms for Data Entry eBook Kit

The Excel UserForms for Data Entry eBook Kit will take you through the steps to build a UserForm that stores data on a hidden worksheet. No programming skills are required -- everything is explained in simple steps, with written instructions, screen shots, videos and workbooks. There are 2 UserForm projects and 4 bonus files in this kit.

Data Validation Multi Select Premium Kit

Click on a cell that has a drop down list, and a list pops open, showing all the items from the drop down. Add or remove check marks, then click OK, to add the selected items to the active cell.

Click here for details on the  Data Validation Multi Select Premium Kit

Contextures Excel Tools Add-in

The Contextures Excel Tools add-in
saves you time and effort, when working with Excel files. For example, you can quickly:

  • protect all sheets in the workbook
  • fill blank cells with value from above
  • add a sheet with a link to all worksheets in the file

The Excel tools add-in creates a Ribbon tab, and is for Excel 2007, and later versions. (Windows only - not available for Macintosh).

30 Excel Functions in 30 Days eBook Kit

Based on the popular 30 Excel Functions in 30 Days series, this ebook kit will guide you through key functions in the Text, Information, and Lookup and Reference categories. The eBook kit contains:

  • a 150 page written lesson guide in pdf format
  • links to Excel video tutorials
  • an Excel file with 100 function examples
30 Excel Functions in 30 Days

30 Excel Functions in 30 Days

Excel Pivot Table Books

I’ve written three books on Excel pivot tables, and you can find them on Amazon:

BeginPT_2007 PTRec2007 PTRec

Products That I Recommend

Jon Peltier has created a set of brilliant Excel Charting Utilities, which will save you hours of frustration:

 ptstileboxplot ptstilecascade ptstilecluster

ptstiledot ptstilemekko ptstilewaterfall

Charley Kyd has an awesome collection of Excel dashboards, that will make your reporting tasks easier. You can read about my experience with the Excel dashboard kit on my website.

Create Excel dashboards quickly with plug-n-play reports.


Chandoo has an Excel project management bundle that will help you get started, with a useful set of templates.

project-management-bundle-excel-ad-2DD

Chandoo also provides Excel dashboard training, in a set of video tutorials.

dashboard-1-small

____________