Excel 2010 Courses?

fleesaurus

I once went to a training centre for an excel course. Was quite a sight watching the manager scold one of his employees in front of customers. The mouthing off lasted approx 10 minutes and the employee ended crying.

EchoLocation

Pivot Tables and advanced Charts I can understand, but are vlookups really considered 'advanced' Excel? They really aren't complicated; I've taught people with very basic Excel experience and had them building formulas, including lookups, easily within a day.

I agree with marybelle01 in that most employers who ask for 'advanced' Excel don't really require that level at all. They usually just want someone who has 'experience' using Excel at a basic to intermediate level. It's really only data Analyst positions that do genuinely require advanced Excel skills.

If you already have a good understanding of Excel then why not google some of what the advanced course covers and see if it's something that you can pick up from the many free resources available on the web.

SueC_2

MissSarah1972 wrote: »

If you have only ever used 2003 then when a company has 2010 you stand no chance getting the job if you have never used it thats why I need to do a course and ALISON is not really recongnised by anyone and does not allow you to practise. I just need to now find the £ to get 2010

If you can use 2003 you can use 2010. The functions work in exactly the same way, you just have to work out where Microsoft have hidden the sodding things in the new menu systems!

Sambucus_Nigra

Totally agree; if you know how to do pivot tables, vlookups etc, the actual understanding and process doesn't change. If it helps, I was taught spreadsheets on Lotus123 and have used excel since it came out, and now am more than happy with Excel for Mac and have also used open office - it's all the same fundamental principles just with different wording.

The versions are just that, slightly different menus, the principle is the same throughout.

fleesaurus

SueC wrote: »

If you can use 2003 you can use 2010. The functions work in exactly the same way, you just have to work out where Microsoft have hidden the sodding things in the new menu systems!

Employer doesn't want to hire you to spend several hours each week finding out where things are instead of actually working.

MissSarah1972

EchoLocation wrote: »

Pivot Tables and advanced Charts I can understand, but are vlookups really considered 'advanced' Excel? They really aren't complicated; I've taught people with very basic Excel experience and had them building formulas, including lookups, easily within a day.

.

So I would need a basic course? I have looked up courses and never saw vlookups on the beginers one
You said 'taught' well that's what I need, a teacher. If have never needed to use them at previous jobs you can't be expected to know how it works.

EchoLocation

MissSarah1972 wrote: »

So I would need a basic course? I have looked up courses and never saw vlookups on the beginers one
You said 'taught' well that's what I need, a teacher. If have never needed to use them at previous jobs you can't be expected to know how it works.

I suspect it's because vlookups are not 'every day' functions like Sums, Counts etc. I guess it's their usage that's considered 'advanced', rather than the understanding needed to use them.

What sort of formulas / functions have you used so far?

SteveJW

If you carry out a web search you should be able to download a 60 day trial of Excel 2010.
Cannot remember the site I got it from
Long time user of Excel 2003, employer updating everyone to 2010, first look was very daunting, wheres everything gone. Trip to the library borrowed Excel 2010 for Dummies and away I go
I think anyone using excel needs to have a good look at what they want to do and if Excel is the best program to carry out the task. I constantly get spreadsheets sent that the information would be would presented in word
Advanced, it appears one persons advanced is anothers basic. We have sent people on advanced courses, they come back and create spreadsheets with wonderful formatting, different colours everywhere, you can spend 10 minutes looking for the data
Remember receiving a spreadsheet once that looked great, a couple of figures were wrong, changed them to the correct figures but the spreadsheet did not update. It turned out the person creating it had added up the totals on a calculator and inputted the total.

Must agree with other posters, if you know what you want to do but dont know how "Google" it

Good luck to the OP

tyllwyd

SGina wrote: »

There's the Mike Smart Excel course which I think is very good. You can try a few lessons for free online before you buy the rest of the course. I think the cost is around £20 per CD, but don't quote me on this. He has a very nice style of teaching. Have a look online http://www.excel2010tutorial.com/

I know this is an old thread, but I came across it the other day and bought a Mike Smart book, and I'm really happy with it. I have a reasonable self-taught knowledge of Excel, but the book has shown me some useful tricks of the trade, and there are sample files to download for the exercises, so you can get on and learn quickly. I'm just working through a few pages whenever I have half an hour free.

saintjammyswine

as the thread has been bumped anyway, you could always try the website called Alison. (google it) It provides free online training for a variety of programmes.