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
![Excel Pro Tips eBook Cover 150x150](https://www.excelcampus.com/wp-content/uploads/2014/04/Excel-Pro-Tips-eBook-Cover-150x150.png)
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
![](https://www.excelcampus.com/wp-content/uploads/2021/02/Excel-Keyboard-Shortcuts-Guide-Page-305.png)
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
![Vlookup Essentials Guide 317x407](https://www.excelcampus.com/wp-content/uploads/2016/02/Vlookup-Essentials-Guide-317x407-234x300.png)
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)