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!
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.
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
Excel Pivot Table Books
I’ve written three books on Excel pivot tables, and you can find them on Amazon:
Products That I Recommend
Jon Peltier has created a set of brilliant Excel Charting Utilities, which will save you hours of frustration:
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.
Chandoo has an Excel project management bundle that will help you get started, with a useful set of templates.
Chandoo also provides Excel dashboard training, in a set of video tutorials.