Overview

Spreadsheets have not fundamentally changed over the past 30 years. While many professionals and casual users choose to avoid advanced features, the general functionality is very simple and familiar. Access to spreadsheets is always available, whether through Microsoft Excel, Google Spreadsheets, OpenOffice Calc, etc. Many spreadsheet suites are even accessible on smart phones. Given their ease of access and consistent functionality, information provided on this site will be relevant for many years to come.

The goal of this site is to provide comprehensive case studies to present useful Excel solutions. While the focus is primarily on advanced VBA features, my tutorial posts will help users understand VBA’s complexity. To start, view the following links:

Downloads

Download and read about our Excel templates, add-ins, and models.

Blog

View our tutorials and exercises for many topics in Excel and VBA.

Series

Many blog posts are organized into a series format. Each series contains multiple posts discussing related features and concepts around important Excel and VBA topics.

If you find the content of this site useful, please consider following us on social media.

LinkedIn
Twitter
Facebook
Google
Tumblr