123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computer-Programming >> View Article

Use Microsoft Office Excel To Keep Control Over Your Finance

By Author: Mr. Ariif
Total Articles: 12

I used to be a financial analyst and used Microsoft excel in a variety of ways. From building financial models to using it as a crude database, excel can be used for many different purposes and you can use it very easy to keep an eye on your finances. This first thing to do is to create an excel file. Name it “Finance” or something like that and save it on your computer and also on a flash drive for backup.

If you have never used excel before, then let me first tell you that the time you invest into learning some very basic excel skills will help you later because once you have a basic model set up, maintaining it takes very little time. I will not go over the rudimentary basics of excel in this article but will assume that you know how to work your way around an excel file and some basic commands.

The first step is to set up your output sheet. The first sheet on the bottom left of the screen should be renamed “output”. In this sheet, you will have a top-level view of your finances. For example, the first line should track your bank account. You can have separate lines for your checking and savings accounts. The next line should be about your investments. The goal is to separate out your inflows from your outflows. So the first few lines should be your inflows. Then the next few lines should be all your outflows such as recurring monthly bills, credit card payments and your estimate of your monthly food bills, electric bills, etc. Feel free to color code your inflows and outflows. I like to use Green and Red.

The last line should subtract the outflows from the inflows and should be labeled “Savings.” Your goal is to keep this line positive every month. Now you can use all the other sheets for each specific line item. One sheet should track your checking account; another should oversee your savings account and a third – your credit card and so on. Link up each sheet with the output sheet. Now you have your skeleton file set up and all you have to do is key in the input numbers into the background sheets every month. Then calculate the totals in each of those sheets and have the totals feed into your output sheet. Keep tabs on your finances this way and you will never lose track of them.

Robert Morris a Microsoft Office expert has been working in the technology industry from the last 5 year. As a technical expert, he has written technical blogs, manuals, white papers, and reviews for many websites such as office.com/setup

Total Views: 29Word Count: 449See All articles From Author

Computer Programming Articles

1. 5 Best Android Swimming Apps Available In 2019
Author: Marco

2. Top 7 Oneplus 7 Pro Cases In 2019
Author: OnePlus 7 Pro

3. Real Estate Script Of Your Dream Software Tools
Author: Narjis Infotech

4. Five Tactics To Get Ready For The Cloud
Author: romyfernandis12

5. Top Java Online Journals
Author: globalleads

6. Do You Need To Leverage Business & Acquire Online Success? (follow Through)
Author: Priya

7. Reasons Why You Should Invest In Mobile App Development
Author: Amit Tiwari

8. Der Abschlussball Ist Das Größte Ereignis
Author: kleider

9. Website Designing In Karachi
Author: James Noah

10. Advance Network Management System
Author: Jone

11. 6 Best Musical Instrument Apps For Ios & Android
Author: Marco

12. 6 Best Weather Apps For Pilots In 2019
Author: Marco

13. How To Fix Microsoft Windows Error 1320
Author: Office Setup

14. How To View And Manage Downloads In Safari Browser On Ipados 13
Author: Marco

15. The 4 Keys To Assembling A Successful Agile Development Team
Author: Amit Tiwari

Login To Account
Login Email:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: