ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to (https://www.excelbanter.com/excel-worksheet-functions/148639-how.html)

George the drummer

How to
 
Day one beginner here. Please point me in the right direction is this
is not where I should be.

Two questions:
1.What is the best free online tutorial for Excel 2003?

2. I want the percentage cost (40%) of all list prices in column B to
calculate automatically in column A. What is that forumula and where
do I insert that formula?

George the drummer


Gord Dibben

How to
 
George

Don't know which is "best" but have a look at these.

Some tutorial sites for basics of Excel........

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx

For the second part about percentages.

You have list prices in column B

In A1 enter =B1*.40

Format Column A to percentage......formatcellsnumberpercentage

Double-click on the small black lump at the bottom right corner of B1 to copy
the formula down as far as you have data in column B.


Gord Dibben MS Excel MVP

On Sun, 01 Jul 2007 18:26:14 -0700, George the drummer
wrote:

Day one beginner here. Please point me in the right direction is this
is not where I should be.

Two questions:
1.What is the best free online tutorial for Excel 2003?

2. I want the percentage cost (40%) of all list prices in column B to
calculate automatically in column A. What is that forumula and where
do I insert that formula?

George the drummer




All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com