As a supplement to all the free Excel tutorials that you can find here, and on the Contextures Blog, you can purchase the following products, to help with your Excel tasks
Pivot Table Tools: The PivotPower Premium (PPP) add-in saves you time and effort, when working with Excel pivot tables. For example, use it to save and apply pivot table settings, change all number formatting, change Count to Sum, and remove all "Sum of" from headings.
Data Entry Tool: Make it easy to select items from a list, withe the 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. Select one or more items to add to the active cell.
Workbook Tools: The Contextures Excel Tools add-in saves you time and effort, when working with Excel files. For example, you can quickly protect/unprotect protect all sheets in the workbook, sort sheets alphabetically, or create a table of contents for a workbook.
Excel Functions: Learn more about Text, Information, and Lookup and Reference functions with the 30 Excel Functions in 30 Days ebook kit. The eBook kit contains a written guide, links to videos demos, and an Excel file with 100 function examples
Data Entry Forms: Learn how to build simple forms with the Excel UserForms for Data Entry eBook Kit Everything is explained in simple steps, with written instructions, screen shots, videos and sample Excel files. There are 2 UserForm projects and 5 bonus files, including a cost calculator, hyperlink example, and transaction form to search and update records.
If you want to invest in Excel tools and training courses, I recommend the following. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
Time-saving Excel Charting Tools from Jon Peltier. Create complex charts, like Waterfall and Cluster Stack, in a few seconds.
The Online Excel Course from Mynda Treacy at My Online Training Hub. Well-organized and presented material, with videos and sample workbooks.
The Excel VBA School from Chandoo. Save time, reduce errors, and advance your career, by learning how to automate Excel.
Collection of Excel Project Management Templates from Chandoo, that you can customize, or use as-is.
Professional Excel Dashboard Kits from Charley Kyd, at Excel User. Present your data in a concise and meaningful layout.
Pivot Table Books: I've written three books on Excel Pivot Tables, and you can find them on Amazon. For more details on each book, click here: Beginning Pivot Tables in Excel 2007, Excel 2007 Pivot Tables Recipes, and Excel Pivot Tables Recipe Book (2003).
Also, the following Excel books are available on Amazon, and use the Search box to find specific titles.
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.
Note: I am an affiliate for these products, and earn a commission on the sales.
Last updated: December 20, 2015 2:10 PM