How to Track Recurring Expenses in Excel

In this Microsoft Excel tutorial, I'll demonstrate how to create a straightforward spreadsheet for managing your recurring expenses. We'll record the last payment date for each expense, establish the frequency of each payment, and from this data, calculate the next due date. Additionally, we'll implement conditional formatting so that upcoming expenses are clearly highlighted in red, making it easier for you to plan and prioritize.

Prerequisites

• Excel Beginner Level 1: https://599cd.com/LB1
• Conditional Formatting: https://599cd.com/LB2
• Functions: https://599cd.com/LB3

Links

• ISO Date Format: https://599cd.com/ISODatesX
• Conditional Formatting: https://599cd.com/ExcelCF

Recommended Courses

• Date Functions: https://599cd.com/LX2
• IF Function: https://599cd.com/LX3

Next Video

• Access Expense Tracker: https://599cd.com/ExpenseTracker

Want More Excel?

Most of what I do is Microsoft Access, so if if you want to see me post more Excel videos, make sure to comment below: "I want more Excel!"

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #techhelp, recurring expense tracker, monthly expenses, annual expenses, weekly expenses, EDATE Function, DATE Function, YEAR Function, MONTH Function, DAY Function, IF Function, TODAY Function, Nested IF