Learning doesn’t stop when the video ends. This page contains free resources that accompany my tutorials, along with reference guides, templates, spreadsheets, and other downloadable materials designed to help you work more efficiently.
Some resources are created specifically to accompany a tutorial, while others are standalone references you can keep handy as you learn. Everything is free to use for personal and educational purposes.
Be sure to check back periodically—I add new resources whenever a tutorial would benefit from an accompanying download or reference guide.
How to Use These Resources
Most spreadsheet resources are shared as view-only Google Sheets so they’re easy to access from any device.
To use them, choose whichever option works best for you:
- Copy and paste the content into your own spreadsheet if you only need specific formulas or examples.
- Download the entire workbook by selecting File → Download → Microsoft Excel (.xlsx) so you can open and work on it in your own copy of Excel.
- Create your own copy in Google Sheets by selecting File → Make a copy if you’d like to edit the spreadsheet online.
Many resources include sample data, step-by-step notes, and formula explanations so you can follow along with the accompanying tutorial or experiment with your own data.
Guide: How to Use These Resources · View All Resources
Excel Resources
- Creating a Searchable Dropdown List in Excel (3 Sheets – Partial, Exact & Exact Case Sensitive)
- How to Combine Multiple Names Based on Same or Different Last Names in Excel
Simple Software Tutorials 