I need a program to write up a sheet of sales data (such as name, address, phone number, etc.) as well as total sales and sales tax daily. I also need the program to be able to add the sales tax daily then to add the daily sales tax quarterly. I have Quicken Basic as well as Excel, would either of these programs have the capability to do these tasks? Maybe I could combine a word and excel document to do the task. I also need a program to list a set of data and then to save each sheet of data daily. What programs would you recommend for these tasks?
OK, I am having a few problems with Excel so far. 1. I want to apply a constant value (sales tax) to an entire column and I even want the value in that column if I insert a new row or something like that so that I do not have to enter it in the new cell in that row but I cannot figure any other way to do it besides copying and pasting the value in every, single cell in the column I'm trying to do this with. 2. I need to do some adding and multiplying across rows but have not figured out how to do it. I know how to add and entire column but I cannot add and multiply a row. Also, is there any way to add and multiply without having to do it by naming specific cells because in each row I want the product price multiplied by the sales tax and then the sales tax added to the price to make a total value. Is there any way to do that and keep it constant so that if a new row is created I do not have to enter the formula for the new row? 3. Is there any way to round decimal number because when sales tax is calculated I do not want a sum of $24.15795, I would want it to read $24.16 instead, is there any way to do that and keep it constant within that column? 4. Is there any way to create more sheets. I need twelve sheets for an entire year of stats, is there any way to do that? 5. If there any way to paste exactly (letters, numbers, formulas, etc.) everything I have on one sheet to another? I tried copy and paste but that didn't go to well. I was thinking that if I could do this I would just copy the month I have already created and paste it on a new sheet the rename it and keep doing it until I have went from January to December.
not sure if i understand your questions, but i'll give you a couple hints. excel can handle any of this without question - its just a matter of me addressing the right question. you can copy and paste formulas and excel will change cell references in a logical manner. the "$" locks in a cell reference. you can lock in a column reference (i.e. $B2), a row reference (i.e. B$2) or both ($B$2). multiplying is just =B2*B4 or whatever the appropriate cell references are. adding rows will automatically adjust the reference properly.\ the rounding thing is =round(B2, 2). B2 would refer to the cell you are trying to round. 2 is the number of decimal places. you may want to also consider just formatting the cells for currency (try control +1 and play around) to add a sheet, right click on the tab that says sheet 1 (or whatever it is titles) and say "Insert" and then choose "worksheet". even better, you may just want to copy the worksheet. that way the formulas are already set up and you just have to change the data. other random tips: control+A means select all. you can use paste special to paste values only or transpose or format or whatever. for help with functions, use the function wizard. excel is an amazingly powerful tool. you can do damn near anything with it, but you need to play around with it to learn the nuances. hopefully this helps with some basic hints and gets you started. good luck
