EXCEL

  Paisley 21:31 16 Jul 2003
Locked

does anyone know where I can find some online help using excel 2000. I need to know how to calulate vat, add symbols such as the copyright symbol, use refrencing,m import and export data, display text at anangle and sort date by component number. Any help would be appreciated.

  VoG II 21:36 16 Jul 2003

click here

If you can post a specific question I'm sure somebody here can help.

To get you started let's take the VAT problem. Let's say you have a price (ex VAT) in A1 then in B1 enter the formula

=A1*0.175

If you have a range of prices in Column A you can copy the formula in Column B down. To dio this hover the cursor over the bottom right corner of A1 and the cursor will turn into a +. Hold down the left mouse button and drag down as far as needed. This will copy the formula down; B2 will refer to A2, B3 to A3 and so on.

  VoG II 21:38 16 Jul 2003

If you have a range of prices in Column A you can copy the formula in Column B down. To do this hover the cursor over the bottom right corner of B1 and the cursor will turn into a +. Hold down the left mouse button and drag down as far as needed. This will copy the formula down; B2 will refer to A2, B3 to A3 and so on.

  Laurenwalker 21:41 16 Jul 2003

to get your text displayed at an angle first type your text then with the cell selected right click and select format cells then select the alignment tab and set your text to the desired angle.

  VoG II 21:46 16 Jul 2003

To sort your data, select all of it then Data/Sort and follow the wizard.

  VoG II 21:48 16 Jul 2003

To Import data, Data/Import external data, point to the file and follow the wizard.

  VoG II 21:49 16 Jul 2003

Export to what?

  VoG II 21:51 16 Jul 2003

To add symbols, Insert/Symbol.

  VoG II 21:51 16 Jul 2003

What do you mean by referencing?

  Paisley 23:28 16 Jul 2003

getting sorted thanks for all the help

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

How Sketch and InVision have revolutionised our design workflow

The best tech gifts for Christmas 2017

Les meilleurs jeux de société (2017)