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.
Is the tracker no longer available? I don’t see the link to download.
Hi,
Thanks for reaching out. I’ve updated the site since releasing this video. You can now found the tracker here:
https://rockstarexcel.com/wp-content/uploads/Rockstar-Excel-Expense-Tracker-Free-Giveaway-V4.xlsx
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!
What function do we use to categorize a list? Like if it contains this word then its this category.