+ Reply to Thread
Results 1 to 10 of 10

Looking for for excel gripes and suggestions

  1. #1
    Registered User
    Join Date
    01-19-2012
    Location
    Urbana, IL
    MS-Off Ver
    Excel 2010
    Posts
    0

    Looking for for excel gripes and suggestions

    Hello excelers,

    Hopefully this is the right place for this kind of thing if not please let me know what a better venue would be.

    I'm currently doing research to see what can be developed to make Excel a better tool for getting your work done. In order to better understand what should be done I'm looking to hear some of your stories about what it's like to work with spreadsheets.

    I am looking for repetitive operations or error prone operations that lend themselves to automation. Specifically, operations that change the content of existing cells in spreadsheets. Examples of operations that I've had in mind include: Adding a new column to a table by pulling out a value from an already existing column. Even something as simple as automatically adding dollar signs to your cell references is something worth mentioning.

    Here are some questions that I'm looking to get answers to:
    What are some things that you really dread to do in Excel?
    What are some things that you have to do all of the time that are tedious?
    What are some things that you do all the time that are easy?
    What are things that you do that are particularly error prone?

    I'm surveying the excel landscape so please lets hear it!

    Thank you!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Looking for for excel gripes and suggestions

    Moved to the Water Cooler
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Looking for for excel gripes and suggestions

    I think we already have a thread similar in nature to this one (probably many threads), here's a link:
    http://www.excelforum.com/the-water-...-you-like.html
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    01-19-2012
    Location
    Urbana, IL
    MS-Off Ver
    Excel 2010
    Posts
    0

    Re: Looking for for excel gripes and suggestions

    Quote Originally Posted by tigeravatar View Post
    I think we already have a thread similar in nature to this one (probably many threads), here's a link:
    http://www.excelforum.com/the-water-...-you-like.html
    Ah that's a cool thread. I was thinking more along the lines of common cell operations. Although seeing what functions people are begging for is pretty intriguing.

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Looking for for excel gripes and suggestions

    Its all good
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  6. #6
    Registered User
    Join Date
    01-19-2012
    Location
    Urbana, IL
    MS-Off Ver
    Excel 2010
    Posts
    0

    Re: Looking for for excel gripes and suggestions

    I hate to raise the dead but I've made a youtube video that should better describe that stuff that I'm talking about: http://www.youtube.com/watch?v=wGIu6Muvd8I

  7. #7
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Looking for for excel gripes and suggestions

    hmm summing is easilly done with the sigma tool. so no real avantage there. i suppose the others functions cold be handy but it starts to get that thereare more tools to learn when just using your brain with whats already there is easier
    Last edited by martindwilson; 02-21-2012 at 07:39 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  8. #8
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Looking for for excel gripes and suggestions

    Quote Originally Posted by sbadame View Post
    Even something as simple as automatically adding dollar signs to your cell references is something worth mentioning.
    Pressing F4 while your cursor is on the reference will cycle through the reference types.

  9. #9
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Looking for for excel gripes and suggestions

    What are some things that you really dread to do in Excel?
    I dread moving data to new tabs using some criteria but removing blanks. Something like
    Please Login or Register  to view this content.
    What are some things that you have to do all of the time that are tedious?
    I'd like a random sort option. Select column, select "randomize".
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  10. #10
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Looking for for excel gripes and suggestions

    I think this thread was started more to try and get you to watch the video and gain interest for the tool that they're developing more than actually out of interest in any real gripes you've got. I don't see much use for what they've done so far so they might really need help though.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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