Please see my guide on How to Install an Excel Add-in for help with installation.

Filter Mate
A fast and easy way to work with filtered ranges and Tables in Excel.

PivotPal
Build and modify pivot tables in a fraction of the time with features like: field search, number formatting, pivot layouts, keyboard shortcuts, and more.

Tab Hound
Quickly find and jump to sheets in your workbook and automate common worksheet processes. The add-in that will change how you work with Excel.

Paste Buddy
Create custom keyboard for any of the paste special commands like paste values or paste formulas.

List Search
Quickly search any data validation list or in-cell drop-down list.

Quarter Sum Formulas
Automatically create formulas that sum quarterly and annual data in a report.

IFs Filter
Automatically filter the source data of a SUMIFS, COUNTIFS, or AVERAGEIFS formula.

Create custom keyboard shortcuts for font & fill colors and number formats.

Move and align chart titles, labels, legends with the arrow keys and alignment buttons.

Quickly create absolute references for table formulas (structured references) using the F4 key.

## File List

Charts

__ 30 Chart Tips eBook.pdf (1.0 MB)

__ Average Versus Current Period Chart.xlsx (61.7 KB)

__ Dynamic Histogram Chart.xlsx (39.8 KB) » View Blog Post

__ Histogram With Group Details Slicer.xlsx (64.5 KB)

__ PivotChart Bar.crtx (7.8 KB) » View Blog Post

__ Sales Pipeline Funnel Chart.xlsx (118.1 KB) » View Blog Post

__ Zoom on Excel Charts.xls (82.9 KB) » View Blog Post

Excel Tables

__ Sort Before Deleting Rows.xlsx (504.4 KB) » View Blog Post

Functions & Formulas

__ Concatenate Macro.xlsm (97.3 KB)

__ Dynamic Arrays Example.xlsx (151.5 KB) » View Blog Post

__ Excel TV Episode 2 Challenge (57.6 KB)

__ IFs Filter Add-in.zip (862.1 KB) » View Blog Post

__ INDEX MATCH Explained.xlsx (145.6 KB)

__ Lookup Formula Errors.xlsx (34.4 KB) » View Blog Post

__ Quarter_Sum_Formulas_Add-in.zip (758.5 KB) » View Blog Post

__ Table With Dates In Headers.xlsx (10.6 KB)

__ Tiered Commission Rates Using VLOOKUP.xlsx (12.1 KB)

Pivot Tables

__ Calendar Table Explained.xlsx (669.3 KB) » View Blog Post

__ How Pivot Tables Work.xlsx (23.8 KB) » View Blog Post

Tools & Utilities

__ Text To Date Challenge.xlsx (104.6 KB) » View Blog Post

VBA & Macros

__ 5 Uses For Macros And VBA.xlsm (1.2 MB)

__ Add Day To Date.xlsm (25.0 KB) » View Blog Post

__ Auto Space Shapes.xlsm (193.1 KB) » View Blog Post

__ Create Macro Buttons.xlsm (33.1 KB) » View Blog Post

__ Delete Blank Rows.xlsm (29.5 KB) » View Blog Post

__ Dynamic PivotChart Title Macro.xlsm (266.0 KB)

__ Find All VBA Form.xls (464.9 KB) » View Blog Post

__ Format Copier Package.zip (268.6 KB) » View Blog Post

__ Move Selection Macros.xlsm (22.4 KB) » View Blog Post

__ M_TOC.bas (2.3 KB) » View Blog Post

__ New Window Macros.xlsm (19.9 KB) » View Blog Post

__ New-Data.xlsx (12.2 KB) » View Blog Post

__ PERSONAL - Excel Campus.xlsb (22.4 KB) » View Blog Post

__ Pivot Table Fields Macro Buttons.xlsm (124.5 KB)

__ Reports.xlsm (22.0 KB) » View Blog Post

__ Responsive Dashboard.xlsm (371.1 KB) » View Blog Post

__ SUBTOTAL Metrics Macro.xlsm (20.6 KB) » View Blog Post