Hey guy's I've taken on a fair sized project on writing up a nice expense report for the oprhanage and was wondering if people with Excel experience could help me out!

I'm currently using Word because I know how to use it. I'm looking for suggestions on how to work Excel in the type of format I'm using on Word.

Thanks a ton!

Here's my format:

 

Easy, just merge the cells and add a background color.

 

I'm wondering about formula's for auto calculation

 

It might be best to separate the HTG from the cells and just put (HTG) in the heading cell, since every field is the same type of HTG.

Then you just type =SUM(Cell:Cell) like =SUM(B2:B10)

: means through

Then when you want the total, you do the sum of each total cell. =SUM(B11,B20,B27) like that.

 

Sweet thanks

 

Yep! It's pretty easy to do the formulas in excel.

 

Have you ever done If/then equations.. you will want to stab the keyboard.

After you do a little bit of them they aren't too bad to do.

 

as in C and Unix? They're not that bad lol

 

No I'm talking about in Excel.

I haven't done them in years, they suck to try to explain to people. (I was doing them in one of my business classes for college)

I've never done Unix or C.

 

Yeah, I've done tons of that stuff. I'm Microsoft (MOS) certified in Word, Excel, Access, and Powerpoint.