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!
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 default pivot table settings
- clear old items from an Excel pivot table
- change all the data fields from the Count function to the Sum function.
This version of the Pivot Power Premium creates a Ribbon tab, and is for Excel 2007, and later versions. There is also an Excel 2003 version.
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.