Excel

[wb]

Anyone know of any free online excel tutorials.

Im working on a system at the moment and I only have a basic knowlege of excel.

could do with some help with it.

thanks,

Wayne

[mathare]

There are a few about but it depends what you want to know...

[sparkyminer]

http://www.exceltip.com/
http://www.jmu.edu/computing/ittraining/tutorials/microsoft/excel/index.shtml
I've used these in the past Wayne, but for one off problems. Mat's yer man.:)

[wb]

nothing too fancy. at the moment, all i can do is the basics (i.e. add, subtract multiply and divide). I want to bring in percentages/ averages etc.

[wb]

http://www.exceltip.com/
http://www.jmu.edu/computing/ittraining/tutorials/microsoft/excel/index.shtml
I've used these in the past Wayne, but for one off problems. Mat's yer man.:)

these look like what im after.

thanks :)

[markwales]

Post exactly what you want on your spreadsheet here, and I'm sure one of us will knock something up for you in a couple of minutes :D

Alternatively, email me your requirements at mark at racingsim.co.uk and I'll take a look when I get home from the office tonight (10pm-ish).

Mark.

[wb]

fist of all, how do i copy a formula, so it works on the next row??

for a (simple) example. lets say the number in A1 is 100, and the number in B1 is 200. and I add them together

The total column (C1) reads 300

now, if i want to copy that simple addition formula for the the next set of numbers in A2 B2 and C2 how is it done

[markwales]

Loads of different ways to do it....

Click on cell C1, and press CTRL+C, then go to Cell C2, and press CTRL+V

or

Click on cell C1, and click edit, then copy, then go to Cell C2, and click edit then paste.

or

Click on Cell C1, then hover the cursor over the bottom right hand corner of the cell (your cursor will turn to a black cross), simply click the bottom corner and hold the left mouse button down, and drag the cell downwards...when you release the mouse the formula will have copied.

[wb]

thanks mark. I know it is very basic stuff, but i have not used excel in ages, and have a formula on paper that takes me hours to try figure out. Im going to go back to it and play around.

no doubt ill be back to bug you with more questions :yikes:

thanks, Wayne

[markwales]

As mentioned above, if you tell us exactly what you want the sheet to do, one of us will knock it up and send it over to you.

That way you can see all the calcs, and learn from a working document, rather than try to create something from scratch, unless of course you wish to do the latter.

[wb]

will do, have to get it sorted out at the moment. its a mess right now, but im playing around with it

[mathare]

This reminds me - SANDMAN - I haven't forgotten your spreadsheet :D

[wb]

:censored: :censored:

I have been working on the excel spreadsheet all day in work.

now that i get home. my pc wont open it. i have windows xp, which uses a crappy microsoft works spreadsheet.

is there anything i can do to open it at home??

[presto]

:censored: :censored:

I have been working on the excel spreadsheet all day in work.

now that i get home. my pc wont open it. i have windows xp, which uses a crappy microsoft works spreadsheet.

is there anything i can do to open it at home??

download XL :wink

[presto]

failing that.

if (when using XL at work). you save it as a file that will be compatable with the spreadsheet on 'works'. you should be able to open it at home. although some of the functions may not work.

[wb]

download XL :wink

is this free? where do i find it?

thanks, wayne

[GlosRFC]

You can always try my free virtual spreadsheet software :)

[GlosRFC]

Oh dear, I forgot to include the link (http://www.pi.pwp.blueyonder.co.uk/spreadsheet.html)
:anger

[mathare]

is this free? where do i find it?My copy was free but Microsoft prefer people to pay a couple of hundred notes for it :yikes:

[presto]

is this free? where do i find it?

thanks, wayne

it's 'free' if you download it from 'limewire' or a 'bit torrent' site (search google). but not realy legal.

[wb]

Oh dear, I forgot to include the link (http://www.pi.pwp.blueyonder.co.uk/spreadsheet.html)
:anger



:laugh :laugh

thanks glos!

[wb]

it's 'free' if you download it from 'limewire' or a 'bit torrent' site (search google). but not realy legal.

ok, will try that option.

[buddhabee]

fist of all, how do i copy a formula, so it works on the next row??

for a (simple) example. lets say the number in A1 is 100, and the number in B1 is 200. and I add them together

The total column (C1) reads 300

now, if i want to copy that simple addition formula for the the next set of numbers in A2 B2 and C2 how is it done

Add the formula to go down a column...
Start in the cell with the formula in, highlight all the cells in the column you want the formula to go in and press ctrl+d

Add the formula to go along a row...
Start in the cell with the formula in, highlight all the cells in the row you want the formula to go in and press ctrl+r

[wb]

ok mathare, you may be able to help with this one.

once i have ran my system, each horse ends up with a number (the highest most likely to win)

how do i sort the final results numerically.

(making sure that the horse name corresponds with its number)

sorry, i dont have a sample yet

hope this makes sense


thanks, Wayne

[mathare]

Select the cells you wish to sort - in this case that sounds like horse name in one column and associated rating in another column (plus any data such as race time, course etc but we will ignore that for now). If the horses are in column A and the ratings in B select all the cells in columns A and B you want sorted then from the menu at the top select

Data - > Sort

You'll be given the option to sort on three selections in ascending or descending order. Sounds like you want to sort only on column B in descending order here. Then your list of horses should be in order with the most likely to win at the top :)

[wb]

Thats exactly what i wanted to do.

Great, thanks for the help.

Man, I love this forum