Скачать с ютуб How to Make a BUDGET ON EXCEL For Beginners в хорошем качестве

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! https://markscreditcards.com/offers 🛍 RAKUTEN - Earn Cash Back! http://markscreditcards.com/rakuten ‼️ GET FREE STOCKS FROM WEBULL when you open an account & deposit $100: http://markscreditcards.com/webull 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.) Disclosure: This site is part of an affiliate sales network and receives compensation for sending traffic to partner sites, such as CreditCards.com. This compensation may impact how and where links appear on this site. This site does not include all financial companies or all available financial offers. The content in this video is accurate as of the posting date. Some of the offers mentioned may no longer be available. Mark Reese is not a financial advisor. #exceltutorial #howtobudget #personalfinance