Using SUMIFS to Build an Expense Tracker in 14 Minutes

SUMIFS is one of the most powerful tools in Excel.

In this video, I show how you can easily use SUMIFS to rapidly create a fully functional, well-polished tool to track and categorize your expenses, in under 15 minutes.

To learn more about creating tools like this, using Excel to get more done in less time, and putting your career into overdrive, check out our Excel: Beginner to Rockstar class.

Could winning at Excel win your next job?

Or save you hundreds of hours as an entrepreneur?

Your mission, should you choose to accept it, is to increase your Excel skills 100% or more in four weeks. You’ll be able to get twice as much done in half the time, amaze your boss and potential employers, and enjoy unparalleled job security.

Rockstar Excel Presents

Excel: Beginner to Rockstar Course

Typically running every other month

You can download your copy of the Expense Tracker created in this video here.

4 thoughts on “Using SUMIFS to Build an Expense Tracker in 14 Minutes”

  1. Thanks fot the article! Is it possible to have a link of the file with the dummy data we see in the video, in order to check how it works? Thank you!

  2. What function do we use to categorize a list? Like if it contains this word then its this category.

Leave a Reply

Learn the 14 Essential Excel Skills

Subscribe to the Excel Rockstars newsletter for tips and tricks on how Excel can make your life easier, and get a free PDF of the 14 Essential Excel Skills.

We won't send you spam. Unsubscribe at any time.