Excel training

brightonman123

play around with the excel help pages- the most advanced i've needed to do in any job is get total of a range of figures - eg, SUM=(A1:A5) where A1 cell is first item, and A5 the last..

you can get same result, by highlighting the cells you need,, drag cursor down / sideways (if doing a row), and click on the Z looking button on toolbar.

[Deleted User]

Poppy9 wrote: »

I use Excel everyday in work. I set up spreadsheets, input formulas, use lookup tables. link s/sheets. I started with spreadsheets in the 80s when there was no tuition available from my employer and everytime we moved packages we had a huge manual available to us!

My employer now runs in house basic and advanced Excel courses. I have only done the advanced one and it didn't cover anything I didn't know at the time!

I found the best source is other people and now today the web. Anything I can't do or can't remember how to do I google.

A few things to find out on line how to do:

• format cells i.e. no decimal places, currency etc. orientation, left, right or centre
• name ranges - easier to use tables then in lookuptables. (it's on the insert menu)
• lookup tables
• concatenate/left/right to extract part of a cell or combine cells is useful
• data to text again useful for breaking up data
• filter - automatic, advanced. On auto filter learn how to use "custom" plus how to copy only visible cells
• formulae have been mentioned "if" "round" are a couple I use frequently and of course SUM.
• tabs - renaming, colour, working with more than one tab
• simple macros
• $ F4 fixing/unfixing cell references
• copy and pasting data and formulae

I've added these to my list. Brilliant - thank you ! :T

hcb42

You can also buy books which can get you through E c d l advanced course level on amazon for about £6, the book refers you to down load the exercises to work through, quite quick to learn up to an intermediate level, including vlookup pivot tables etc

saintjammyswine

Contact your local FE College and rather than ask about short Excel courses (which will be run commercially), speak to the student services/admission team about funded IT training. It can be funded if embedded within literacy/numeracy courses for most people.