Excel Tools and Utilities

Tools & Downloads

This page contains an organized list of all the Excel files, add-ins, and guides that are available for download on this site. The majority of the downloads are free. Please contact me if you have trouble finding anything.

Excel Add-ins

An Excel Add-in is a tool that adds additional features to Excel. These add-ins will add additional buttons to the ribbon that will help automate processes and save you time.
Please see my guide on How to Install an Excel Add-in for help with installation.

Filter Mate Icon
Filter Mate
A fast and easy way to work with filtered ranges and Tables in Excel.
PiovtPal_Window_Ribbon_32
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 Add-in
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 Add-in
Paste Buddy
Create custom keyboard for any of the paste special commands like paste values or paste formulas.
List Search Add-in
List Search
Quickly search any data validation list or in-cell drop-down list.
Quarter Sum Formulas Add-in
Quarter Sum Formulas
Automatically create formulas that sum quarterly and annual data in a report.
IFs Filter Add-in
IFs Filter
Automatically filter the source data of a SUMIFS, COUNTIFS, or AVERAGEIFS formula.
Formatting Shortcuts Add-in
Formatting Shortcuts Add-in
Create custom keyboard shortcuts for font & fill colors and number formats.
Chart Alignment Add-in
Chart Alignment Add-in
Move and align chart titles, labels, legends with the arrow keys and alignment buttons.
Absolute Reference Add-in
Absolute Reference Add-in
Quickly create absolute references for table formulas (structured references) using the F4 key.

File List

The following is a list of files available for download.  Please refer to the post link after each file for more information.

Icon of Charts Charts

__ 30 Chart Tips eBook.pdf (1.0 MB)

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

__ Comparative Distribution Chart Guide.xls (233.0 KB) » View Blog Post

__ Comparative Distribution XY Chart Template.crtx (5.5 KB) » View Blog Post

__ Display Variance On Line Chart.xlsx (83.0 KB) » View Blog Post

__ Dynamic Baseline Stacked Column Chart.xls (130.6 KB) » View Blog Post

__ Dynamic Chart Data Labels - Stacked Column.xlsx (45.4 KB) » View Blog Post

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

__ Dynamic Stacked Column and Trend Line Chart.xls (137.7 KB) » View Blog Post

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

__ Olympic Commercials Dashboard.xlsx (83.4 KB) » View Blog Post

__ Plotting Value with Range - XY Distribution Chart.xlsx (39.7 KB) » View Blog Post

__ Progress Doughnut Chart With Conditional Formatting.xlsx (45.0 KB) » View Blog Post

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

__ Variance On Column Or Bar Chart Guide For Excel 2013.xlsx (193.1 KB) » View Blog Post

__ Variance on Column or Bar Chart Guide.xlsx (185.7 KB) » View Blog Post

__ Waterfall Chart Dashboard.xlsx (64.8 KB) » View Blog Post

__ Zoom on Excel Charts - Bottom Right.xls (84.5 KB) » View Blog Post

__ Zoom On Excel Charts - Top Right.xls (85.0 KB) » View Blog Post

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

Icon of Excel Tables Excel Tables

__ Absolute Reference Add-in.zip (1.3 MB) » View Blog Post

__ Absolute References in Structured Reference Tables.xlsx (14.8 KB) » View Blog Post

__ Dependent Dropdown Lists Multiple Dependents.xlsx (37.3 KB) » View Blog Post

__ Dependent Dropdown Lists - Multiple Precedents.xlsx (35.3 KB) » View Blog Post

__ Excel Tables Examples - Unformatted.xlsx (25.6 KB) » View Blog Post

__ Filter For Duplicates With Conditional Formatting.xlsx (619.4 KB) » View Blog Post

__ Filter Zeros And Number With Filter Drop-down Menus (12.0 KB) » View Blog Post

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

Icon of Functions & Formulas Functions & Formulas

__ 3 Ways To Group Times In Excel.xlsx (58.3 KB) » View Blog Post

__ Commission Plan SUMPRODUCT Units Dollars.xlsx (10.6 KB) » View Blog Post

__ Concatenate Macro.xlsm (97.3 KB)

__ Conditional Format Shapes.xlsx (38.7 KB) » View Blog Post

__ COUNTIF Function - Check If A Value Exists.xlsx (18.5 KB) » View Blog Post

__ Dependent Dropdown Lists - 3 Lists.xlsx (37.6 KB) » View Blog Post

__ Dependent Dropdown Lists.xlsx (36.6 KB) » View Blog Post

__ Drop-down Arrow Always Visible Example.xlsx (28.9 KB) » View Blog Post

__ Excel TV Episode 2 Challenge (57.6 KB)

__ Find All VBA Form - All Worksheets.xls (1.2 MB) » View Blog Post

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

__ Percentage Change Formula For Negative Numbers.xlsx (19.8 KB) » View Blog Post

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

__ Reverse Filter List Of Items - Partial Match.xlsx (43.5 KB) » View Blog Post

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

__ Text To Date Challenge - Live Training.xlsm (349.8 KB) » View Blog Post

__ Tiered Commission Rates using SUMPRODUCT.xls (101.4 KB) » View Blog Post

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

__ Tips For Calculating Week Numbers In Excel.xlsx (19.6 KB) » View Blog Post

__ VLOOKUP Closest Match Example.xlsx (13.2 KB) » View Blog Post

__ VLOOKUP Commissions Calculation Example.xlsx (21.6 KB) » View Blog Post

__ VLOOKUP Explained In Simple Terms At Starbucks.xlsx (10.6 KB) » View Blog Post

__ VLOOKUP MATCH Explained At Starbucks.xlsx (15.2 KB) » View Blog Post

Icon of Pivot Tables Pivot Tables

__ Add A Search Box To A Slicer - List Selected Items (366.4 KB) » View Blog Post

__ Add A Search Box To A Slicer.xlsx (278.7 KB) » View Blog Post

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

__ Display Multiple Items In Pivot Table Filter.xlsx (100.6 KB) » View Blog Post

__ Excel Slicers - Interactive Guide.xlsx (39.1 KB) » View Blog Post

__ Filter For Recent Date Or Period In Pivot Table - Calculated Column.xlsx (41.7 KB) » View Blog Post

__ Filter For Recent Date Or Period In Pivot Table - VBA Macro.xlsm (50.4 KB) » View Blog Post

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

__ How To Analyze Multi Choice Survey Data.xlsx (37.3 KB) » View Blog Post

__ Intro To Pivot Tables And Dashboards - Part 3.xlsx (160.5 KB) » View Blog Post

__ Intro To Pivot Tables Part 1.xlsx (76.5 KB) » View Blog Post

__ Intro To Pivot Tables Part 2.xlsx (101.5 KB) » View Blog Post

__ Month To Date MTD Comparison in Pivot Table.xlsx (111.0 KB) » View Blog Post

__ Month To Date MTD Comparison Pivot Table - Weeks.xlsx (127.7 KB) » View Blog Post

__ Pivot Table Automatic Number Formatting Macro.xlsm (28.4 KB) » View Blog Post

__ Pivot Table List Comparison Technique.xlsx (27.6 KB) » View Blog Post

__ Pivot Table Source Data Checklist - Excel Campus.pdf (262.2 KB) » View Blog Post

__ PivotChart Formatting Changes On Filter Slicer.xlsx (35.6 KB)

__ Sales Data For January 2015.xlsx (13.6 KB) » View Blog Post

__ Show Report Filter Pages.xlsx (97.5 KB) » View Blog Post

__ Sort Or Filter A Slicer With Another Slicer.xlsx (356.1 KB) » View Blog Post

Icon of Tools & Utilities Tools & Utilities

__ 17 Excel Tips Guide - Excel Campus.pdf (624.6 KB) » View Blog Post

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

Icon of VBA & Macros VBA & Macros

__ Color Palette Conversion Tool.xlsm (107.4 KB) » View Blog Post

__ Concatenate Macro Other Sheets.xlsm (98.5 KB) » View Blog Post

__ Convert Pivot Table To SUMIFS Formulas.xlsm (170.6 KB) » View Blog Post

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

__ File Find All VBA Form (Results on Form).xls (474.6 KB) » View Blog Post

__ File Find All VBA Form - All Worksheets (Hide Cell Address).xls (1.2 MB) » View Blog Post

__ Filter Columns Macro Examples - Multiple Slicers.xlsm (41.6 KB) » View Blog Post

__ Filter Columns Macro Examples.xlsm (36.5 KB) » View Blog Post

__ Find All VBA Form - All Worksheets - Copy Paste.xls (547.3 KB) » View Blog Post

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

__ Find Last Cell VBA Example.xlsm (79.6 KB) » View Blog Post

__ For Next Loop VBA Macro Examples.xlsm (79.0 KB) » View Blog Post

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

__ Hide Columns That Contain A Value In A Cell VBA Macro.xlsm (64.9 KB)

__ Installing An Excel Add-in - Guide (672.2 KB) » View Blog Post

__ Percentage Change Formula Creator Macro (19.0 KB) » View Blog Post

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

__ Remove Duplicates - List Unique Values Macro.xlsm (50.1 KB)

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

__ Save And Close All Files Macros.xlsm (15.8 KB) » View Blog Post

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

__ The For Next And For Each Loops Explained For VBA Excel - Excel Campus.pdf (490.5 KB) » View Blog Post

__ Unhide Multiple Sheets Macro.xlsm (64.2 KB) » View Blog Post

__ VBA Code Modules.xlsm (25.3 KB) » View Blog Post

__ VBA Copy Paste Methods.xlsm (91.7 KB) » View Blog Post

__ VBA Immediate Window Examples.xlsm (109.9 KB) » View Blog Post