Can Excel do things lilke Quicken

J

Justin

I use Excel to do my Checking Account information and with in that I have my
transactions and next to that I have a code that says what it is like Wendy's
is FF(fast Food). I was wondering if Excel can take these and then group them
together and total them for me. I don't like using Quicken when Excel will
give me a better control over what I can and Can't do.

Thanks,
 
J

Jim Rech

You should investigate the Data, Sort function to get like items sorted
together, and the Data, Subtotals function to get sub totals by categories.

--
Jim
|I use Excel to do my Checking Account information and with in that I have
my
| transactions and next to that I have a code that says what it is like
Wendy's
| is FF(fast Food). I was wondering if Excel can take these and then group
them
| together and total them for me. I don't like using Quicken when Excel will
| give me a better control over what I can and Can't do.
|
| Thanks,
 
J

Jay

I use Excel to do my Checking Account information and with in that I
have my transactions and next to that I have a code that says what it
is like Wendy's is FF(fast Food). I was wondering if Excel can take
these and then group them together and total them for me. ...

One way:
Data > Pivot table report

If you haven't used pivot tables before, take a look at Excel's built-in
"Help" about them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top