I am going to receive a list of names and prices next to them : My question is how do i put that in Excel and then also make it automatically deduct 15% from its price ??? i imagine copy past and then insert a formula on the next cell block, but which formula ?? and how do i make it work automatically for all other prices going down the row ??
to do that, you need to copy the formula over to the other cells, you should be able to do that by simply dragging the outline of the original cell with the formula over the cells where you need the formula (sorry, have no better words to describe it...)
This is assuming you want the deduction to go down (a column) and not to the right (a row). For the fill : Highlight the cell where you put the formula, hold the shift key down and press the down arrow key to cover all the cells you want the formula to apply. With those rows highlighted, press CTRL-D (the control key then D). That should do a fill down of the formula. There's ways you can do it via menus and dragging like SJC said, but I usually use shortcut keys and it's hard describing the drag thing.
