How to update Rockstar Excel Expense Tracker for new year
Quick instructions on how to update the Rockstar Excel Expense Tracker for the new year.
How to update Rockstar Excel Expense Tracker for new year Read More »
SUMIFS
How to do an XLOOKUP with multiple variables
XLOOKUP is one of the most useful tools in Excel, but doesn’t allow you to use multiple variables/criteria.
Here I show three ways to make this work:
– Use a SUMIFS
– Use a helper column
– Nest an XLOOKUP inside another XLOOKUP
How to do an XLOOKUP with multiple variables Read More »
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
Using SUMIFS to Build an Expense Tracker in 14 Minutes Read More »