Question

can someone please answer this question for me. How much time can be saved from using functions in spreadsheets

Answer 1

It depends on how fast a type you are

If you're slow then it can save you a lot of time but if you're a fast one then not that much.

Answer 2

*i meant typer not type

Answer 3

Functions in spreadsheets change their usefulness overall. For instance it saves me from having to create a database. It also turns a spreadsheet into a high function calculator.

Answer 4

so if you had to estimate the amount of time you save doing a standard spreadsheet you would say how much?

Answer 5

The question is basically un-answerable in it's current form. There are way too many variables. It depends on how complex the spreadsheet is, the number of calulations, how often it needs to be updated, etc. How much time you save depends on how much time it would take you to complete the calculations manually. If you are creating a monthly household budget, you might save a few hours, and more as time goes on. If you are calculating profit/loss information for a company, the time saved is more likely days to weeks.

Answer 6

Thank you Khaldac I have been trying to figure out how to answer this question and I too thought that it really depends on a lot of variables such as typing speed and ones basic knowledge of Excel functions and formulas if you are new to Excel it is gonna take more time learning them before you can use them right?

Answer 7

Yes, if you are new it's going to take much more time :) Excel is a great program but some of its more complex operations can be difficult to understand. It will also require a good understanding of what it is you are trying to model with the spreadsheet. If you don't know much about accounting, for example, it will take much longer to produce a profit/loss spreadsheet.

And, you're welcome :)

Answer 8

BTW, typing speed isn't going to matter all that much. There isn't really that much typying involved in setting up a spreadsheet; as opposed to creating a mailmerge operation with say, Microsoft Word.

Answer 9

*typing. Sheesh, obviously something I need help with :)

Answer 10

ty maybe you can help with this question too how big is too big when using spreadsheets other than the obvious

Answer 11

Hmm, interesting question and one without a clear cut answer. Too big can be a function of the power of the computer involved or it can be related to the amount of information one has to take in to comprehend the spreadsheet. If the subject is very complex, a single worksheet can be a lot. In other cases, multiple worksheets combined into a workbook (or whatever the term is, sorry, I forget) can be acceptable. For my tastes, I prefer keeping a spreadsheet limited to a specific task, say a simple invoice. I"m not sure how much help that will be to you.

Answer 12

well I know it is too big when the computer says it is I guess the size of the spreadsheet is ones preference.

Answer 13

i was just wondering if there was a specific size or amount of columns and rows

Answer 14

I would pretty much agree. Perhaps it's more a question of does the spreadsheet solve the task? Ahhh, there is a limit to the number of rows/columns that Excel can handle, if that's what you are asking. I don't have the numbers at hand but I'm sure I could find them if you need them. I know they are in the docs somewhere or a search of the Internet would probably provide the answer.

Answer 15

If, however, your question wasn't so much about physical limits but more what is actually usable, in my opinion horizontal scrolling is a Very Bad Thing and vertical scrolling should be kept to a minimum. Better to see the entire spreadsheet at once, if possible.

Answer 16

ty

Answer 17

there are so many functions. They save hours depending on the function.