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!
Bookmarks