New Update to the List Search Add-in
The List Search Add-in has become very popular. This simple add-in allows us to quickly search any data validation list. It has additional features to search lists in cells without validation, and even create lists of unique values.
22
Preview of The Filter Mate Add-in for Excel
In the last webinar I mentioned a new add-in that I have been working on with Randy, a student of The VBA Pro Course. The add-in is called Filter Mate.
The goal of Filter Mate is to help make it easier to work with filtered ranges and Tables in Excel. I just recorded a quick video that gives a preview of how Filter Mate works.
Video: Preview of the Filter Mate Add-in
8 “Using the PivotPal has been quite a ‘light bulb moment’ in that it has helped to really cement my understanding of how Pivots in MS Excel work – quite apart from making Pivot Tables much easier and faster to set up, especially for multiple tables, it’s also helped me understand much better MS Excel’s high level Pivot Table workflow.
PivotPal Bonus Videos: Learn PowerQuery, Unpivoting, VBA, & More
The add-in I have been talking about for weeks is finally available. And I have a few bonuses to go with it. Plus, a special limited time offer!
What’s the Word on PivotPal?
Here is a quote from David, a PivotPal user…
David W
4
Tab Hound Features Update – Version 1.5
This post will explain some of the new features that have been added to the Tab Hound Add-in recently.
76
5 Ways to Use the VBA Immediate Window in Excel
The VBA Immediate Window is an awesome tool that allows you to get immediate answers about your Excel files, and quickly execute code. It is built into the Visual Basic Editor, and has many different uses that can be very helpful when writing macros, debugging code, and displaying the results of your code.
1
Tab Hound & Tab Control for Mac – Now Available!
That’s right Mac users! The wait is finally over…
The Mac versions of the Tab Hound and Tab Control add-ins are now available.
7
The Tab Hound and Tab Control Add-ins for Excel
The wait is finally over. Tab Hound and Tab Control are now available to download!
74
Move and Align Chart Titles, Labels, Legends with the Arrow Keys
The free Chart Alignment Add-in for Excel allows you to quickly align the objects within a chart. The chart titles, labels, and legends can be moved using the arrow keys on the keyboard or with the alignment buttons in the add-in window.
11
SUMIFS, COUNTIFS, AVERAGEIFS Filter & Analyzer Add-in
This add-in will help you filter and analyze results for long formulas using SumIfs, CountIfs, or AverageIfs functions, and it’s FREE!
33
Absolute Reference Add-in – Use the F4 Key in Structured Table Formulas
This post explains how to quickly create absolute references for table formulas using the Absolute References Add-in. This add-in will save you time when writing formulas with structured references (table syntax), and it’s FREE!
