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

Use Microsoft Office Excel To Keep Control Over Your Finance

Profile Picture
By Author: Mr. Ariif
Total Articles: 12
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

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: 51Word Count: 449See All articles From Author

Add Comment

Computer Programming Articles

1. R Programming | R Language | R Certification | Smartech Educaton
Author: Smartech education

2. Java Course In Delhi | Java Classes In Delhi | Smartech Education
Author: Smartech education

3. C Language | Learn C Programming Course In Delhi | Smartech Education
Author: Smartech education

4. Python Course In Delhi | Python Training Center | Smartech Education
Author: Smartech education

5. How To Customize And Use Surface Dial
Author: jaxson harry

6. How To Fix 0x80240fff Windows 10 Update Error?
Author: jaxson harry

7. How To Start Python Language?
Author: Priyanka Patel

8. How To Test Mobile Applications That Are Rapidly Evolving And Have Shorter Release Cycles
Author: dilli

9. How To Fix Cortana Not Working On Windows 10?
Author: jaxsonharry

10. How To Find The Best Experts For Printer Support?
Author: murphy felicia

11. Digital Marketing And Data Science: What’s The Relation?
Author: nagaraju

12. Web App Development: 3 Things To Keep In Mind
Author: Nelson Gibs

13. The Most Focal Points To Improve The Javascript Performance
Author: Inwizards Software PVT Limited

14. Love My Dress était Mon Blog Principal Pour L'inspiration De Mariage
Author: robe

15. Voip Solutions Are Vital For Enterprises
Author: Nelson Gibs

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