Hi all,
I would say I'm just barely past the beginner level of using Excel to its fullest potential and I have been slowly but surely improving over the years. My main focus for learning has been a sheet I've been using for my bills each month. I started knowing absolutely nothing about Excel back in 2013 and I don't feel like I've improved much beyond the basics. I have an example sheet mocked up using random numbers to keep my actual finances private.
Here is the link to the folder containing it. I'm currently at work and cannot download minisheet. Let me know if there's a better way to do this.
drive.google.com
The purpose: I have 2 bank accounts: my bills and my debit card. Bills are all on autopay and after an allowance is deposited each month, the remainder of my check goes into my bills account. As interest rates are non-existent, it kind of doubles as a savings account. As the majority of the bills are consistent and any small changes can be made as things go, I can see what the potential balance of my account will be in the future, all the way out until I stop creating a new sheet for that next month. Currently I can see what my balance, and therefore savings, should be in Dec 2025.
I'm sure there are ways to improve this to be more efficient and/or neater. What would the hivemind that is this forum board suggest?
Thank you for any and all suggestions. Feel free to ask any questions needed. I will try to answer in a timely manner.
I would say I'm just barely past the beginner level of using Excel to its fullest potential and I have been slowly but surely improving over the years. My main focus for learning has been a sheet I've been using for my bills each month. I started knowing absolutely nothing about Excel back in 2013 and I don't feel like I've improved much beyond the basics. I have an example sheet mocked up using random numbers to keep my actual finances private.
Here is the link to the folder containing it. I'm currently at work and cannot download minisheet. Let me know if there's a better way to do this.
Excel Forum - Google Drive
drive.google.com
The purpose: I have 2 bank accounts: my bills and my debit card. Bills are all on autopay and after an allowance is deposited each month, the remainder of my check goes into my bills account. As interest rates are non-existent, it kind of doubles as a savings account. As the majority of the bills are consistent and any small changes can be made as things go, I can see what the potential balance of my account will be in the future, all the way out until I stop creating a new sheet for that next month. Currently I can see what my balance, and therefore savings, should be in Dec 2025.
I'm sure there are ways to improve this to be more efficient and/or neater. What would the hivemind that is this forum board suggest?
Thank you for any and all suggestions. Feel free to ask any questions needed. I will try to answer in a timely manner.
