Welcome to Excel Campus!
Join me and over 98,000 other Excel fans on the journey to:
- Learn Excel & VBA
- Save time & work efficiently
- Take your career to the next level
Click the button below to join my awesome Excel newsletter & download a free gift!
What's On This Site?
Excel Campus is filled with articles, videos, resources and free content to help you learn.
Blog
Articles and video tutorials that will help you learn Excel. It’s updated about once a week.
Free Downloads
Save time and work efficiently with my productivity apps and add-ins.
Courses
In-depth training courses that will help you learn Excel in an easy step-by-step manner.
Excel Add-ins
Save time and work efficiently with my productivity apps and add-ins.
Recent Excel Tutorials (Blog Posts)
Create SUBTOTAL Formulas with the AutoSum Button or Keyboard Shortcut
Bottom line: Learn how to use the AutoSum feature and keyboard shortcut to create SUBTOTAL formulas. Skill level: Beginner AutoSum[...]
The For Next and For Each Loops Explained for VBA & Excel
Bottom line: The For Next Loops are some of the most powerful VBA macro coding techniques for automating common tasks[...]
Automatic Default Number Formatting in Excel Pivot Tables
Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with[...]
The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI
Bottom line: In this post we will learn what a Calendar Table or Date Dimension Table is, and how we[...]
Reverse Partial Match Lookup to Filter for a List in Excel
Bottom line: Learn how to filter for a list of items using a reverse partial match lookup. Skill level: Intermediate Video Tutorial[...]
2 Ways to Filter for List of Items in Excel + Video Tutorial
Bottom line: Learn 2 ways to filter for a list of multiple items in Excel in this article and video[...]
Join over 98,000 Excel Fans on the journey to learn Excel.
Join my awesome weekly newsletter and download my Excel Pro Tips eBook immediately!