Free Microsoft Excel 2013 Quick Reference

A simple budget template for college students

I am a college student, and need to budget, but the template I found for
Personal Budgeting is far too complicated for my needs. I would like to see a
simplified one available, for all of the financially suffering enduring
college life and it's expenses.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


Post your answer or comment

comments powered by Disqus
I am a college student, and need to budget, but the template I found for
Personal Budgeting is far too complicated for my needs. I would like to see a
simplified one available, for all of the financially suffering enduring
college life and it's expenses.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I'm trying to create a simple budget formula for microsoft excel.

http://files.dmusic.com/music/g/a/ga/help-new.jpg

Now.. Lets say i have $800 in E3.

I want to add my car insurance payment, which would go into D3.

I need a formula to automatically adjust my Account Balance to WITHDRAWL my car insurance if i enter it, and Put my new Account Balance into E4.

BUT.. here's the other thing..

I need the same thing for Deposits, or ADDING money..

Lets say i make a deposit of $950 into cell C6. I want my Account BALANCE to REFLECT that Deposit.. Basically Adjust the Account Balance to match my deposits and withdrawls..

http://files.dmusic.com/music/g/a/ga/help2-new.jpg
^ Diagram of a basic Spreadsheet i wanna make..

PLEASE, if anyone can help, let me know..

And.. remember.. i wanna make the formual adjust accordingly..

maybe something like an =IF such and such amount is added to this cell, Adjust,AND enter the Balance into a new cell for my account balance

^ basically what i'm trying to do.. but i keep getting errors.. thank youuuuuu

Afternoon all,

I've recently taken responsibility for the financial reporting in the company I work for. The reports I've inherited are extremely poor as they contain numerous errors and are difficult to interpret. It's going to take me a while but i'm hopefully going to replace them all with more professional looking reports and i'm starting with the budget templates.
Attached is a standard budget template for one of our business units. I'd be grateful if a few people could try to make it look more professional and hopefully i'll be able to pull the best features out of each to create a final refined template.

Thanks in advance,

Snook

where can I find a billing ledger template for excel

Does anyone know of any free Excel Templates for charting and exploring
Student progress in a Youth Employment Program?

Hi. I was wondering if anyone could help me with converting the "Personal
Budget" template for Excel 2007 to use with excel 2003.
Here's the link to that template.
http://office.microsoft.com/en-us/te...CT101172321033
I'm a starving student and can't afford to upgrade right now. Thanks so
much!

(sorry for the double post, I had the wrong forum)

I have bought some preprinted checks (voucher style) to run through my laser
printer and am looking for a simple template for word or excel that I can use
to ill out the check on my computer.

I have an apparently quite simple problem, but i find it quite challenging when it comes to organize cells filling multiple cells with the date only the day the change has been made, without updating each day. So in example:
Cells B2:B16 need to contain today's date: 19.4.2012., and the most important reason is that it is meant for a daily report template for work, so from the moment i write 19.4.2012 in B2, the cells automatically obtain the date, and it does not update depending on the PC's date, ie with the =TODAY() function. So when my supervisor takes a glance at my report from 19.4.2012 after 3 days, it should stay 19.4.2012.

I did try and solved it quite "rural", by typing today's date in the first (B2) cell, and the rest just had a draged'n'dropped function =B2. This is just about my personal need for simpler yet faster responses from a template that i will use every day. As i study Software Engineering, you might understand my need for speed and...well....complicity . I could yet again spend some time learning about usage of the VB interface that runs behind, and the private sub's and stuff like that, but since I use Visual C# and eventually C++....that could take a while , combine that with everyday studying and a 6h workday after/before that...

Thanks in advance!

I need to create a job bid template for Excel that includes Materials cost,
labor cost, etc....

Hello, I searched everywhere and can't seem to find the answer to what seems to be a simple formula. I've created a simple work schedule for the employees at my store. I want to total their hours for the whole week at the end. However, some days they don't work and I usually just put an X in those cells representing that their off that day. My work sheet has days of the week at top and employees at the left. I have two cells for each day, one for the time they start and one for the time their shift ends. I can do a simple formula like =SUM(C4-B4)+(E4-D4)+ and I continue like that for the other 5 days. It works great if there are on X' in the row but if a person if off a day and there are some x's the formula gives me a #VALUE! error. Any ideas? Any help would be greatly appreciated. Thanks.

Jeff

I am trying to create a simple little program for our employees to check
credit card numbers and return which Credit Card company it belongs to.
My thought was to have a simple user form 'popup' stating, "Please enter
Credit Card Number here", a box to put the numbers in. Once they enter the
card number click the button and have it return a statement, "This is a ABC -
Master Card, contact number is (800) 555-1234"

The lookup would compare the first 6 numbers (although a few only do the
first 2 or 5) of the credit card entered, to a list in column A in Sheet1.
The Credit Card company names are in column B and the phone numbers are in
column C.

Can anyone point me in the right direction?

Thanks
Tim

Hi all

Crossposted to more Excel groups

For my mail page : http://www.rondebruin.nl/sendmail.htm
I create a new sheet template for Excel/Outlook 2007 and 2010 and I am looking for testers.

After you install the template (xltm) you can right click on the sheet tabs and choose Insert to Insert the worksheet to the
ActiveWorkbook.
Because you will save this worksheet in the workbook it is very easy to send one or more mails with one click on a button each time
you want.
You can send one sheet or more or the whole workbook on only a few text lines. And you can create one mail or many.
Note: You use one row for each mail that you want to create and in the fields Sheets, To, CC, BCC and Body text you use Alt Enter
between
for example every worksheet name so each sheet name is on a new line in the cell.

In the sheet there is a Table with the following fields
Note: because it is a Table you can enter "yes" in column A on a new row and the new row will have a nice format and the data
validation tips when you select a cell.

Send: yes or no

Sheets: Enter the sheet names you want to mail separated with Alt Enter or enter "workbook" if you want to send the whole workbook.

File Name: Enter the prefix for the file name (date/time and extension will add automatic)

Values: to convert formulas to values

Objects: to delete all objects

To: Enter the mail addresses here separated with alt Enter

CC: Enter the mail addresses here separated with alt Enter

BCC: Enter the mail addresses here separated with alt Enter

Subject: enter the mail subject here

Attach other files: You can use a button to select the files you want to attach to the mail

Body text: Enter a short body text and separate every line with Alt Enter

If you want to test this sheet template you can mail me private and I will mail you the file.

Thank you very much

I am trying to create a simple little program for our employees to check
credit card numbers and return which Credit Card company it belongs to.
My thought was to have a simple user form 'popup' stating, "Please enter
Credit Card Number here", a box to put the numbers in. Once they enter the
card number click the button and have it return a statement, "This is a ABC -
Master Card, contact number is (800) 555-1234"

The lookup would compare the first 6 numbers (although a few only do the
first 2 or 5) of the credit card entered, to a list in column A in Sheet1.
The Credit Card company names are in column B and the phone numbers are in
column C.

Can anyone point me in the right direction?

Thanks
Tim

Interested in finding a good Excel spreadsheet for tracking workplace
accidents.

I am trying to do a debt collection template for our small business - for
each debtor: original debt amount, payments made, costs added, commission on
original debt amount - that sort of thing. Then a summary of all debtors and
the state of their debt. Does anyone have that sort of thing ready made?
Would be most grateful as I am an Excel bunny!

Hello,
I have a spread sheet which I use for entering my monthly petty cash expenses.
At the bottom of the spreadsheet I would like to add a simple 4x4 table for office use. This table would be 4 evenly sized columns and 4 rows. I can create this table in MS Word however I can't figure out how to import it.
Is there a way to define this table in my Excel document or is there a way to import the table from MS Word?
Thanks.
Doug

I have a table containing two columns.. first column contains student names while the second contains test scores.. a name is randomly repeated for many consecutive rows indicating test attempts.. does excel have a built in function to do the following?:

1) Give the minimum test score for each student.

2) Average test scores for each student.

I have attached a simple excel file for four students showing two sheets.. sheet called data is how the original data is set up.. sheet called final format indicating how it should be..

Can anyone help me? I have never coded VBA if this is where its going.. God bless you..

Note: We have no control over the number of times a student takes the test..All we can do is arrange them so repeating names come consecutively in the column..And as you might already know.. I have thousands of students.. and the table will end by an empty cell..

Hi All,

I am developing a spreadsheet budget template for the 5years. My problem so far is I have a cell which the user enters the basic salary and two other cells (drop-down list) where the appropriate year and month are selected.

What I would like to happen from here is, when the user hits a button to confirm entry, the basic salary value is copied under the correct month and year in my "calculation on net pay table". In essense the year and month will be the coordinated to the correct cell.

I tried using an if statement (in every cell) of the table to check for the criteria but ...for example I enter a basic salary for 2002 January..it goes in the table but when I select another setting like 2004 August the basic salary is copied here but the figure that was in the 2002 Jan disappears (because the if statement is false). How do I achieve what I want ?

hi
problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for

each student e.g. i will end up with 300 seperate excel files prefably

called the students name??
any help would be gratefully received
cheers
paddy

Sorry, but I'm not into programming language, but I can do a simple Macro Record and even attach it to a button.

I have a simple worksheet template for reservations at our B&B. As soon as I enter the last name of the guest, a FormatConditioned sell displays to remind me to save the file, as NAME-YYYYMMDD (name and arrival date)

I can put a forumla into one cell that displays that intended file name; I can copy it and paste-special-value into another cell. I can copy that cell and hit SAVE and Ctl-V that as the name of the file, and save it.

I can do all that manually, but when I try it as a macro, it tries to save the file as the name of the LAST guest it did that to. If I'm saving JONES-20070106 it asks if I want to replace SMITH-20061221.

When I look at the debug code (god forbid - it's like opening the hood of my car!) I see SMITH-20061221 imbedded in the macro!

What am I missing?

Thanks for any help!

Jim / Sleepless in Toronto

I have a simple division formula that I am using to find out billings vs. what was budgeted.

For example: Unit does $5,000 worth of business and was budgeted for $10,000 - so they made 50% of their budget.

Question: What should I make the formula if my budget is a negative number? Example - Unit does $5,000 worth of business but was budgeted for $-2,000.

Thanks!

I need help in obtaining a template for a fixed payment amortization schedule
in Excel. The payment remains the same until paid off, so the length of the
note is adjusted accordingly. I think it is called simple interest loan with
fixed rate, but I am not sure.

I need the note to adjust to the fixed payment.

Please help if possible; I am an inexperienced excel user.

Sincerely,
DSP

I own three rental properties and I'm looking for a simple template for Excel
that will allow me to merely track expenses and income. The simpler the
better.

I need to find a rather simple template for doing my inventory for my supply
room.


No luck finding an answer? You could always try Google.