What do you use Numbers/Excel for?

Discussion in 'Mac Apps and Mac App Store' started by bigMAC28, Apr 16, 2012.

  1. bigMAC28 macrumors member

    Joined:
    Apr 16, 2012
    Location:
    Chicago
    #1
    Im just wondering what you guys use Numbers/Excel for? Besides business uses I just don't see the use for a spreadsheet in my life. I feel like it would be a good way to organize though.
     
  2. basesloaded190 macrumors 68030

    basesloaded190

    Joined:
    Oct 16, 2007
    Location:
    Wisconsin
  3. bigMAC28 thread starter macrumors member

    Joined:
    Apr 16, 2012
    Location:
    Chicago
    #3
    What do you mean by that? Do you download all of your credit card transactions daily?
     
  4. charlieegan3 macrumors 68020

    charlieegan3

    Joined:
    Feb 16, 2012
    Location:
    U.K
    #4
    i hope his personal finances arn't that complex!

    i use excel for school Physics experiments, its really useful.
     
  5. basesloaded190 macrumors 68030

    basesloaded190

    Joined:
    Oct 16, 2007
    Location:
    Wisconsin
    #5
    Set up budgets, car payment plans, eventually home mortgage plans, etc. Also keep track on investments and future options. Sure this could all be done online, but if you know the ins and outs of excel it's nice to be able to link multiple spreadsheets and keep everything organized.
     
  6. itickings macrumors 6502a

    itickings

    Joined:
    Apr 14, 2007
    #6
    Excel is the swiss army knife of computing. :p

    Some basic home uses for Excel/Numbers/etc are: Budgets, investment plans/tracking, and health/exercise logging and progress monitoring.
     
  7. Mousse macrumors 68000

    Mousse

    Joined:
    Apr 7, 2008
    Location:
    Flea Bottom, King's Landing
    #7
    Generating invoices, statement, tax worksheets, mortgage calculations, cost-benefits analysis, payroll records, budgeting... basic bean counting.

    I guess I take after my dad. He's a farmer.
    I spreadsheet in columns; I spreadsheet in rows.
    The more I spreadsheet, the faster it grows.
     
  8. iJohnHenry macrumors P6

    iJohnHenry

    Joined:
    Mar 22, 2008
    Location:
    On tenterhooks
    #8
    Volunteer run logs/mileage billing/statistics, personal banking/CC, Condo accounts, Income Tax, even comparing beer values. ;)

    And playing with charts & graphs. :p

    Except I use neoOffice. :)
     
  9. fireshot91 macrumors 601

    fireshot91

    Joined:
    Jul 31, 2008
    Location:
    Northern VA
    #9
    Personal finance basically. It's really easy for me. One column for Money In, one column for Money Out, one column for Current $$.
     
  10. iJohnHenry macrumors P6

    iJohnHenry

    Joined:
    Mar 22, 2008
    Location:
    On tenterhooks
    #10
    How do you reconcile different categories?

    I have 17 sheets in "Accounting", 10 of which are linked to a "Current $$" you describe.

    Yes, I'm severely anal, but not in "that way", not that there's anything wrong with that.

    Being retired, I just have the time available to work my brain.
     
  11. TwinCities Dan macrumors 603

    TwinCities Dan

    Joined:
    May 19, 2008
    Location:
    Double Parked out front of the Courthouse
    #11
    I use Numbers for all invoices and accounting records for my small business. :)
     
  12. -aggie- macrumors P6

    -aggie-

    Joined:
    Jun 19, 2009
    Location:
    Where bunnies are welcome.
    #12
    I usually use Excel to import a table I want to analyze.
     
  13. wrldwzrd89 macrumors G5

    wrldwzrd89

    Joined:
    Jun 6, 2003
    Location:
    Solon, OH
    #13
    I use neither, preferring LibreOffice Calc instead for my calculation needs. Mostly I use it for making tables, though.
     
  14. ender land macrumors 6502a

    Joined:
    Oct 26, 2010
    #14
    I find a lot of uses for Excel.

    Then again, I'm kinda an Excel wizard so it's easy for me to use.
     
  15. mscriv macrumors 601

    mscriv

    Joined:
    Aug 14, 2008
    Location:
    Dallas, Texas
    #15
    Like many have posted, a spreadsheet program can be used for any kind of listing or tracking. In my job I keep a workbook made up of multiple tabs where I keep a growing list of contacts, tracking of outcomes, a work log, and a variety of other things. At home a I track finances on a monthly budget. In DJ work I use it for music lists.

    For major tracking with extremely large amounts of data then a database is ideal, but if you are just doing simple listing and reference then putting together a quick spreadsheet is a no brainer.
     
  16. Happybunny macrumors 68000

    Joined:
    Sep 9, 2010
    #16
    I use Excel to do the accounts for two Clubs that I'm a member of.

    An Excel Spreadsheet is an acceptable format for the Netherlands Tax office.
     
  17. MadMitch89 macrumors regular

    Joined:
    Mar 31, 2010
    Location:
    Brisbane, Australia
    #17
    Data entry and presentation for my scientific research. It's a bit of a jack of all trades excel. I use it for so many things.
     
  18. throAU macrumors 601

    throAU

    Joined:
    Feb 13, 2012
    Location:
    Perth, Western Australia
    #18
    For me:

    Numbers: home budget - planning income vs upcoming expenses by month, to figure out what money i can realistically save

    Excel (work): recording, sorting and analyzing data. I'm a network admin, so i often collect data from say, every machine on the network, or every router, etc and record info in fields - or rather use a tool to collect info, dump to CSV file, then analyze in Excel...


    Spreadsheets are one of those "if you can't think of a use, you probably don't need it" apps.
     
  19. EricNau Moderator emeritus

    EricNau

    Joined:
    Apr 27, 2005
    Location:
    San Francisco, CA
    #19
    Work and scientific research (related to my work).

    Can't recall using Excel for a personal reason any time recently. For personal databases I find Bento more apt.
     
  20. fireshot91 macrumors 601

    fireshot91

    Joined:
    Jul 31, 2008
    Location:
    Northern VA
    #20

    Okay maybe not ONE column for "Current $$$". But rather like 5-7 columns.

    One for each bank account, one for wallet, one for spare cash at home.

    When I started the worksheet, I put in a starting balance, and any adjustments are added/subtracted as necessary to bring it to balance (Basically I take the money from the income/expenses areas, and adjust the accounts based on that).

    It's a really simplified non-accounting solution, but it gets the job done in a (to me) organized manner.
     
  21. sinanziric macrumors member

    Joined:
    Apr 8, 2012
    #21
    I don't own Numbers or Excel because i don't need them.

    If you don't have small business, If you are not making special calculations, you don't need Numbers/Excel.

    I bet many people bought Numbers/Excel but they are not using it.
     
  22. And macrumors 6502

    And

    Joined:
    Feb 23, 2009
    Location:
    92 ft above sea level, UK
    #22
    Work - data transforms, charts for write ups, that sort of thing.

    Personal - personal finances like every one else. I have one spreadsheet with several sheets to keep track of savings, pension. Main sheet is for keeping track of monthly spending. Have been using this system for about 7 years now and have transformed finances, I never used to know how much I spent, I do now.
     
  23. Traverse macrumors 603

    Traverse

    Joined:
    Mar 11, 2013
    Location:
    Here
    #23
    If I may ask, do you create a new spreadsheet for each or or one master sheet?

    Right now I have a large excel file where I keep every transaction (instead of using the check registry). I use collapsible cells so it's okay now with 4 years of data, but I can see it building up over time. I was thinking of creating a new identical one each year with the starting balances of the pervious year.
     
  24. Easttime macrumors 6502

    Joined:
    Jun 17, 2015
    #24
    Spreadsheet apps are great for keeping information in tables, which can become very complex (and hard to troubleshoot). The power of spreadsheets lies in the formulas you can build in cells that reference other cells, to summarize data.

    Advice for spreadsheet beginners: create a separate Excel file for each task. Then within a file create a separate worksheet for subtasks so that you work only in the top left corner of every worksheet.

    Commonest home use probably is as an aid to manage finances. I use it as a supplement to a bookkeeping app like iBank. I use the spreadsheet app to summarize financial data.

    Spreadsheets are great for making graphs of tabled data.

    Spreadsheet apps can be a useful way to make lists of stuff you own, but as someone above suggested, database programs are better for that job. Apps like TapForms are goodfor personal databases like vehicle logging, household inventories, health records, family gift preferences, books to read, movies to watch. Spreadsheets are not well suited to large databases, although experts can really make them sing.
     
  25. rhett7660 macrumors G4

    rhett7660

    Joined:
    Jan 9, 2008
    Location:
    Sunny, Southern California
    #25
    Work, project management, quick calculations, planning a trip, cost analysis, and pretty much anything else I can throw at it.
     

Share This Page