filmov
tv
How to Make a BUDGET ON EXCEL For Beginners
Показать описание
This is the EASIEST step-by-step walkthrough of how to create a budget on Excel for beginners in 2020! Click "Show More" to see Ad Disclosure.
If you’re looking for a way to make a budget to save money, THIS is a GREAT way to do it.
💳👉VIEW CREDIT CARD OFFERS!
🛍 RAKUTEN - Earn Cash Back!
‼️ GET FREE STOCKS FROM WEBULL when you open an account & deposit $100:
Using Microsoft Excel to make a budget and save money is awesome because it can do all the math for you.
You can also use this framework to create a budget on Google Sheets or on Numbers.
I’ll also include 3 money-saving tips (listed below).
MONEY SAVING TIP #1: Make a R.E.A.L. Budget, which stands for Record Everything And Live it!
Record your MONTHLY budget for everything you spend money on by category. Gas, groceries, restaurant / dining purchases, etc.
Next, record your NON-MONTHLY budget, again by category. This might include auto registration, membership fees, eye / dental exams, etc. These will be the things that you pay once per quarter, twice per year, once per year, etc. When you have this list, then estimate what you spend in each category. Divide this number by 12 to see what the cost would be on a monthly basis. You'll set this money aside each month to cover these expenses when they arise.
Lastly, record your real-world monthly expenses as you actually spend. On your spreadsheet, you have a column for your budgeted expenses, and then in the next column over you can record every expense as you make them right next to the first column. That way you can see if you’re on budget or off track. I recommend making a column to budget each month.
You then LIVE IT … ideally daily.
Everywhere you go spend money (retail stores, restaurants, entertainment venues, etc.), you live within that budget you’ve set. And since you record what you spent each day before you go to bed, you’ll get close to real-time feedback to guide you.
MONEY SAVING TIP #2: Open 4 accounts. That will be 2 checking accounts and 2 savings accounts. Here’s how those break down:
a) Checking Account 1: INCOME
b) Checking Account 2: FUN!
c) Savings Account 1: SET ASIDE
d) Savings Account 2: PAY YOURSELF
The 1st CHECKING account is where all your income goes. It’s basically your financial wallet to the rest of the world.
The 2nd CHECKING account is the money you save for FUN, in other words, money you can spend freely without guilt. Reward yourself and your progress with these funds!
The 1st SAVINGS account is where you send all the money you set aside for the non-monthly expenses. Since you’re doing this on a monthly budget basis, whenever those infrequent expenses come up, you’ll have an account with money in it to cover the costs.
The 2nd SAVINGS account is for paying yourself. No matter what happens, every time you get a paycheck or income of some sort, set aside either a flat amount or a percentage you set. Send it to this savings account so you can watch it grow every single month (it will feel AMAZING)!
Also, I recommend that when you open these new savings accounts, ensure that they are high-yield savings accounts. These earn much higher interest rates and usually have no fees and no minimum balance requirements.
Of course, you can open as many checking and savings account as you like. If you want to save money for travel or a car, you can make accounts for those, too.
The reason why having 1 checking account and 1 savings account is not ideal is because the balances will fluctuate so dramatically every single month. That makes it extremely difficult to gauge whether or not you’re making progress.
MONEY SAVING TIP #3: Change your IDENTITY & your FOCUS
Going forward, you are a saver. Repeat that to yourself over and over until it becomes your new talk track. Also give it some feel-good emotion: visualize your balance increasing. The better you feel about it and the more excited you get, the more fun you'll have doing it.
Then, your focus is on how to increase your income.
You’ve already made a R.E.A.L. Budget and are Living It (Daily), so it takes care of itself. Now you’re free to tune your mind into new ways to make more money (get a raise, start a side business, invest, etc.)
#exceltutorial #howtobudget #personalfinance
If you’re looking for a way to make a budget to save money, THIS is a GREAT way to do it.
💳👉VIEW CREDIT CARD OFFERS!
🛍 RAKUTEN - Earn Cash Back!
‼️ GET FREE STOCKS FROM WEBULL when you open an account & deposit $100:
Using Microsoft Excel to make a budget and save money is awesome because it can do all the math for you.
You can also use this framework to create a budget on Google Sheets or on Numbers.
I’ll also include 3 money-saving tips (listed below).
MONEY SAVING TIP #1: Make a R.E.A.L. Budget, which stands for Record Everything And Live it!
Record your MONTHLY budget for everything you spend money on by category. Gas, groceries, restaurant / dining purchases, etc.
Next, record your NON-MONTHLY budget, again by category. This might include auto registration, membership fees, eye / dental exams, etc. These will be the things that you pay once per quarter, twice per year, once per year, etc. When you have this list, then estimate what you spend in each category. Divide this number by 12 to see what the cost would be on a monthly basis. You'll set this money aside each month to cover these expenses when they arise.
Lastly, record your real-world monthly expenses as you actually spend. On your spreadsheet, you have a column for your budgeted expenses, and then in the next column over you can record every expense as you make them right next to the first column. That way you can see if you’re on budget or off track. I recommend making a column to budget each month.
You then LIVE IT … ideally daily.
Everywhere you go spend money (retail stores, restaurants, entertainment venues, etc.), you live within that budget you’ve set. And since you record what you spent each day before you go to bed, you’ll get close to real-time feedback to guide you.
MONEY SAVING TIP #2: Open 4 accounts. That will be 2 checking accounts and 2 savings accounts. Here’s how those break down:
a) Checking Account 1: INCOME
b) Checking Account 2: FUN!
c) Savings Account 1: SET ASIDE
d) Savings Account 2: PAY YOURSELF
The 1st CHECKING account is where all your income goes. It’s basically your financial wallet to the rest of the world.
The 2nd CHECKING account is the money you save for FUN, in other words, money you can spend freely without guilt. Reward yourself and your progress with these funds!
The 1st SAVINGS account is where you send all the money you set aside for the non-monthly expenses. Since you’re doing this on a monthly budget basis, whenever those infrequent expenses come up, you’ll have an account with money in it to cover the costs.
The 2nd SAVINGS account is for paying yourself. No matter what happens, every time you get a paycheck or income of some sort, set aside either a flat amount or a percentage you set. Send it to this savings account so you can watch it grow every single month (it will feel AMAZING)!
Also, I recommend that when you open these new savings accounts, ensure that they are high-yield savings accounts. These earn much higher interest rates and usually have no fees and no minimum balance requirements.
Of course, you can open as many checking and savings account as you like. If you want to save money for travel or a car, you can make accounts for those, too.
The reason why having 1 checking account and 1 savings account is not ideal is because the balances will fluctuate so dramatically every single month. That makes it extremely difficult to gauge whether or not you’re making progress.
MONEY SAVING TIP #3: Change your IDENTITY & your FOCUS
Going forward, you are a saver. Repeat that to yourself over and over until it becomes your new talk track. Also give it some feel-good emotion: visualize your balance increasing. The better you feel about it and the more excited you get, the more fun you'll have doing it.
Then, your focus is on how to increase your income.
You’ve already made a R.E.A.L. Budget and are Living It (Daily), so it takes care of itself. Now you’re free to tune your mind into new ways to make more money (get a raise, start a side business, invest, etc.)
#exceltutorial #howtobudget #personalfinance
0:08:21
Budgeting for Beginners - How to Make a Budget From Scratch 2021
0:04:25
How Do I Make A Budget And Stick To It?
0:00:20
How to make 10 Tasty Meals on a budget 🤝💵
0:13:43
Budgeting For Beginners | How To Create A Budget From Scratch (2025)
0:15:45
How to Make a BUDGET ON EXCEL For Beginners
0:06:25
HOW TO: THE EASIEST AND SIMPLEST WAY TO CREATE A MONTHLY BUDGET! 6-MINUTES PROCESS
0:13:50
Budgeting For Beginners | The Only Budgeting Method You Need To Worry About!
0:00:16
How to create a monthly budget quickly
0:01:00
BIG JUSTICE Builds His Perfect Meal! How’d They Do? #shorts #food #budget #dessert @a.j.befumo...
0:24:02
BBP REAL LIFE BUDGET | Budgeting When You Don't Make Enough
0:10:19
How To Make A Budget And Stick To It
0:05:27
Financial Literacy—Making a Budget | Learn how to create a budget
0:10:16
How To Make Your First Budget (At Any Income)
0:13:53
The One Simple Budgeting Method That Changed My Life
0:08:20
How to Create a Budget from Scratch
0:05:13
Budgeting Basics!
0:00:23
Annual & Monthly Budget Spreadsheet #tutorial #spreadsheets #shorts
0:00:22
Budgeting to move out
0:05:26
How to Make a Budget in 5 Steps
0:14:05
Do This EVERY Time You Get Paid (Paycheck Routine)
0:00:37
How I budget my $120k salary #salarytransparency #budgeting #paydayroutine #financialliteracy
0:00:41
How to start cash stuffing #savingmoney #cashstuffingforbeginners #budgeting #cashbudgetingmethod
0:15:24
How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses
0:00:28
how to build a home studio for less than $300
Комментарии