Confirmed – Download Your Bonus Files

Success! Your subscription to the newsletter has been confirmed and you should start receiving weekly emails from me.

Thanks again!  I am so happy that you are here, joining me on the journey to learn Excel.  This page contains a bunch of free downloads and resources just for you.

You can bookmark this page and come back any time to download the files.

Download the eBook

The eBook can be downloaded by clicking the link below.
The download is a zip file that contains the eBook PDF file and an Excel Workbook file.  The Excel file follows the book and helps you practice the techniques.  Right-click the link below and select “Save [link] as…” from the menu to save it to your computer.

 10 Excel Pro Tips EBook Package.zip (1.5 MB)

---

Members Only File Library – More Free Stuff!

As a member of the Excel Campus community, you get access to download any of the files below for free.

Keyboard Shortcuts List

This download is a printable PDF version of our keyboard shortcuts page. It contains over 270 Excel keyboard and mouse shortcuts for the Windows, Mac, and Web versions of Excel.

 Excel Shortcuts List – Excel Campus.pdf

 VBA Shortcuts List – Excel Campus.pdf

---

VLOOKUP Essentials Guide

This is a one page guide that covers everything you need to know to get started with VLOOKUP.  I will be sending you an email with more info my free videos series on the Lookup Formulas.

 VLOOKUP Essentials Guide – Excel Campus.pdf (405.5 KB)

Checkout my article on VLOOKUP explained at Starbucks for an in-depth tutorial and Excel practice file.

---

Formatting Shortcuts Add-in Lite

The Formatting Shortcuts Add-in allows you to create custom keyboard shortcuts to apply font or fill colors to the selected cells.

 Formatting Shortcuts Lite Add-in.zip (2.0 MB)

---

Convert Source Data for Pivot Table

This file and post explains how to setup your source data for a pivot table, and contains a formula based approach to unpivoting (normalizing) your data.

 Convert Source Data for Pivot Table.xlsx (35.1 KB)

---

Chart Alignment Add-in

The Chart Alignment Add-in allows you to move the chart elements (titles, labels, legends, etc.) with the arrow keys and alignment buttons.

 EC Chart Alignment.zip (663.7 KB)

---

Filter Drop-downs Keyboard Shortcuts Guide

This workbook that contains over 25 keyboard shortcuts for the Filter Drop-down Menus.

 Filter Dropdown Keyboard Shortcuts.xlsx (1.3 MB) » View Blog Post

---

Table of Contents Gallery Macro

This workbook contains the Table of Contents Gallery Macro.  Watch the video and learn more here.

 Table Of Contents Gallery.xlsm (268.9 KB)