+ Reply to Thread
Results 1 to 3 of 3

Can Excel do things lilke Quicken

  1. #1
    Justin
    Guest

    Can Excel do things lilke Quicken

    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,

  2. #2
    Jim Rech
    Guest

    Re: Can Excel do things lilke Quicken

    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
    "Justin" <[email protected]> wrote in message
    news:[email protected]...
    |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,



  3. #3
    Jay
    Guest

    Re: Can Excel do things lilke Quicken

    > 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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1