Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel do things like Quicken
I would like to take me check book and enter in all information so I can get
a good idea of where my money is going. But I would like to have Excel sort them into groups like eating out, Bills...Etc with a total so I can put them into graphs. Can Excel to this? I know quicken can but I don't want to use quicken Thanks |
#2
|
|||
|
|||
You can use a pivot table to summarize the entries by category. There
are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Justin wrote: I would like to take me check book and enter in all information so I can get a good idea of where my money is going. But I would like to have Excel sort them into groups like eating out, Bills...Etc with a total so I can put them into graphs. Can Excel to this? I know quicken can but I don't want to use quicken Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
or you could do it the easy way: autofilter. have a column for category, and autofilter it. -- medicenpringles ------------------------------------------------------------------------ medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458 View this thread: http://www.excelforum.com/showthread...hreadid=379806 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an easy way to copy my Intuit Quicken files to Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
how do I create qif files from Excel for import into Quicken? | Excel Discussion (Misc queries) |