Excel Expenses - Please Help!
2 Attachment(s)
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: Attachment 34522 |
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.
|
Originally Posted by ChibiBlackSheep
(Post 521426)
Yep! It's pretty easy to do the formulas in excel.
After you do a little bit of them they aren't too bad to do. |
Originally Posted by A05C
(Post 521463)
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. |
Originally Posted by trewyn15
(Post 521470)
as in C and Unix? They're not that bad lol
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.
|
All times are GMT -5. The time now is 11:54 AM. |
© 2024 MH Sub I, LLC dba Internet Brands