Useful Excel Add-ins, books and ?

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse

On this page you find links to good Excel Add-ins, books and ? from people I know and trust. You only find links in the list to products that I use or used myself so I know what I am talking about. Note: I am a affiliate for some of the products in this list and earn a commision on the sales but that is not the reason why they are in this list because money is not the reason why I run this Excel site.

MVP Ken Puls : Excelguru

Our favourite definition of the word Guru is, "Remover of darkness." A guide. A teacher. It is in this spirit that the Excelguru site was created by Ken Puls (also known as the Excel Guru). Our goal is to help remove the mysteries of Excel and Power BI, help you find solutions, and help you to be more proficient or accomplish certain tasks. Our passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. https://www.excelguru.ca/blog/

If you want to learn from the master himself check out, Power Query Academy, Power Query Recipes, M is for Data Monkey (Digital) below, click on the pictures for more information :

Power Query Academy

Master Your Data with Excel and Power BI, must have book

Power Query Recipes

MVP Charles Williams : Decision Models

This the place to go for optimising speed, MVP Charles Willliams is a pro in this area (calculation and speed) and create this wonderful product named FastExcel.

The FastExcel V4 Family of Products

There are 3 major products in the FastExcel V4 family which are targeted at different types of useage, and allow you to only buy the tools you need.

FastExcel V4 Profiler

The Profiler gives you a comprehensive set of tools focussed on finding and prioritising calculation and VBA bottlenecks. If your spreadsheet takes more than a few seconds to calculate you need FastExcel profiler to find out and prioritize the reasons for the slow calculation

Profiling Drill-Down Wizard - single click drill-down to find the slowest formulas on the slowest sheets
Profile Workbook, Profile Formulas, Profile Worksheet - find the slowest calculating worksheets, formulas and formula blocks
Worksheet Cross-References - map the references between worksheets
VBA Profiler - find the bottlenecks in your VBA
Calculation timing tools for workbooks, worksheets, and ranges

FastExcel V4 Manager Pro

FastExcel Manager contains tools to help you build, debug and maintain Excel workbooks.

Workbook Cleaner - Trim down any excess bloat in your workbooks
Formula Explorer - a better way of reviewing, understanding and debugging formulas.
Name Manager Pro - an invaluable tool for managing Defined Names and Tables
Sheet Manager - Easily manage and manipulate worksheets.
Check Workbook - Check your workbook for potential problems.
Where-Used Maps - See where your Defined Names, Number Formats and Styles are being used
Memory and Versions - Show available and used memory, Excel and Windows bbuild versions.

FastExcel V4 SpeedTools

SpeedTools provides you with a state-of-the-art tool-kit to help you speed up your Excel Calculations

100 superfast multi-threaded functions
50 Dynamic Array functions
Dynamic Formatting for all Dynamic Array formulas
Faster and more powerful Lookups and List comparisons
Multi-condition Filtering and Distinct formulas to eliminate many slow SUMPRODUCT and Array formulas
Enhanced functions for text, mathematics, sorting, information and logic
Additional calculation modes to enhance control of calculation so that you only calculate what needs to be calculated.

If you want to try or buy this great product use the links below :

Click here to visit the FastExcel for Windows website

Click here to visit the FastExcel Manager Pro for Mac Office 365 Excel website

MVP Jon Peltier : The Internet's greatest resource for Excel Charts

This is the place to go for some great Chart addins for Excel for Windows and for the Mac.

Click here to visit Peltier Technical Services

Rob Bovey : Excel VBA Code Cleaner

This is a free must have add-in to clean your VBA code for everyone that create and use VBA.

http://www.appspro.com/Utilities/CodeCleaner.htm

And when you are on Rob's site check out also the other free add-ins : http://www.appspro.com/Utilities/Utilities.htm

Jan Karel Pieterse : RefTreeAnalyser

Very useful add-in from MVP Jan Karel Pieterse.

RefTreeAnalyser: The ultimate Formula Auditing tool

Excel formula auditing taken to the next level!, check it out.

Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera)
Find circular references (yes, all of them!)
Trace errors
Time your workbook calculation for each worksheet to find bottlenecks
Check columns for formula inconsistancies

Ron de BruinExcel Automation