How to make money in 2022? Here are some Excel tips to help you
AdvertisementSponsored Folder
Between the end-of-year celebrations and the increases in the price of energy, our bank accounts are not in their best shape, and it can be difficult to approach the new year calmly from a financial point of view. . Don't panic, there are simple solutions to learn how to manage your budget with Excel. This will allow you to save money, and even earn money! To do this, nothing could be simpler, just download Excel (Microsoft Office for PC or Mac), and set up a new organization.
There are many software and applications to manage your budget. But these are often paid applications, complicated and dedicated to budget management. While you can quite manage your budget on Excel, a versatile software, which is suitable for basic use as well as for the budget as well as for more advanced use. There is therefore no need to go into the purchase of expensive software. With Yeslicense, you can get the Microsoft Office 2019 suite for less than €10, or the Microsoft Office 2021 suite for less than €15!
Get organized to learn how to manage your budget
We will see that it is not enough to earn money to know how to manage your budget. The first thing to do when you want to learn how to manage your budget is to identify your different expenditure items. This allows you to see where you are spending your money, and if there are any spending items that can be reduced. This will allow you to save money in the long term. Buying a Microsoft Office license at a reduced price is already a first saving. Regardless of the version of the Microsoft Office suite (2019 or 2021), you can absolutely use it to track your budget. After downloading Excel, you will be able to create your file, which will include spreadsheets for tracking your expenses.
Who knows how to fucking unlock your jaw!!!?!????!
— girl. Thu Mar 09 16:25:04 +0000 2017
We suggest that you create a model on a first spreadsheet, which will serve as a reference model or use a typical model here. All you have to do is duplicate it each month to complete a new follow-up of your budget. A simple right click on the reference spreadsheet will allow you to duplicate it, and thus reuse your model without wasting time. And time is money!
On this reference worksheet, you will be able to create a first column for the expense categories. These categories can for example be: housing (rent, credit repayment, electricity bills, home insurance, internet and telephone subscription), transport (petrol, parking, car insurance), food (food shopping), leisure (outings, activities ), health (medical expenses not covered by social security and mutual insurance). In the following lines, you can detail these expenses, by entering keywords such as "restaurant", "outing", or "clothing". This will allow you to highlight the small expenses that come up regularly, but which put together represent a large sum of money. You can then enter the amount of the expenses. And finally, other cells will be used for the amount of revenue: to learn how to manage your budget, you have to know how much you earn! Receipts are salaries and other income, but also reimbursements of medical expenses, or the reimbursement of a friend for which you have advanced money (provided you have spent the amount advanced).
View all of your expenses
Finally, you can conclude your table with a final line showing the total expenses and income, to get an idea of the total expenses incurred over the month. With Excel, there is no need to calculate the sum of all the amounts one by one: select the cell located directly below the column of amounts to be calculated (one cell for expenses and one cell for income), then click on the symbol "sum" (∑, which is on the right in the Home tab). The number that appears in the selected cell is the sum of all the amounts entered in the table. In other words, it is the sum of your expenses for one of the columns, and the sum of your income for the other. All you have to do is subtract your total expenses from your total income to get your total budget for the month. You can also create a "Total" line after each expense category, for more precision. Seeing the total amount spent for each category of expenses allows you to realize the weight that this item has in your budget.
And to go even further, you can create a spreadsheet that will take all the data from all the months, to see the evolution of your budget during the year. This will allow you to better manage your finances, and set yourself balance goals on your account!
Conclusion
To manage your budget well, you must already know how to manage your budget. Excel, from the Microsoft Office suite is a good application for managing your budget. Once the spreadsheet template has been created, simply duplicate it and fill it in each month to get an overview of your monthly budget. This will allow you to evaluate the items of expenditure that can be reduced, to save money. With YesLicense, you can start saving by purchasing a Microsoft Office PC or Mac license at a reduced price. These are original licenses, resulting from a system of purchase and resale. These licenses are dematerialized, so no shipping costs. The purchase and resale of second-hand licenses is legal and authorized in Europe (Arrêté UsedSoft GmbH vs. Oracle International Corp., dated July 3, 2012 (case c-128/11)).Article written in collaboration with YesLicense
