Excel training classes

[Eric]

I was wondering if anyone knows of any good excel
classes. I would say my level of excel knowledge is
moderate and I'm looking for some advanced training. I
have not been able to find anything yet. Any ideas?

Thanks,

Eric

 

[GerryK]

Read about concepts and ideas in this discussion group and
make yourself a working file of relevant samples and
formulas as posted. Note the common threads in solutions
and the alternate ways of doing the same thing! That is
what I did and found it very rewarding. I signed up
for 'Excel Advanced' delivered through contractor training
but fould this Newsgroup far beyond the level of the
course.
You can also visit the MVP's pages for a lot of good
information.
When you are confident enough, help out someone else!

"The help you receive in internet newsgroups is not really
free, though it is willingly and happily provided at a
very low and reasonable cost. The price of admission is
respect and professionalism and is due and must be paid in
full with each post and reply. That's what makes it such a
great place for learning and for sharing what we have
learned."

HTH

 

[Eric]

I mean no disrespect, but I have tried that and get board
with the vast amount of remedial questions. I know plenty
of excel "tricks", but want to take it to the next level.
I'm thinking maybe learning more VBA is the next step. I
just asked the general question for other peoples
insight.

I was not aware of the MVP's page. I will check that out.

Thanks for your reply,

Eric

 

[Ken Wright]

LOL - Anyone that can deal with most of the 'remedial' questions in these
groups, as well as actually understanding all the solutions offered and then
being capable of reproducing them on an ad-hoc basis as and when the need arises
during their day job, shouldn't be looking for classes, they should be giving
them.

VBA will allow you to automate a vast number of things in Excel, but you are
kidding yourself if you think that ignoring Normal Excel functionality in favour
of learning VBA will put you in good stead, as what you will invariably end up
doing is trying to write VBA routines to do things that standard Excel
functionality will do in a heartbeat - That just ends up looking dumb. Two of
the most useful areas I have found to learn have been Pivot tables and arrays.
The power you have at your fingertips is phenomenal when you get these under
your belt (Oh and did I mention, I haven't yet - And probably never will 100%,
but I'll keep reading and I'll keep learning)

And oh by the way, I don't think any of the regulars in here would say they
don't still learn from various posts, and that includes some of the brightest
minds you'll come across, MVPs or not - Some of the most respected minds in here
are not MVPs!!

 

[Dave R.]

Remedial questions are the most fun to answer though..

If you want to learn VBA and excel, try the programming group.

With me, I learn best when I can apply something. So most of the Excel stuff
that I've learned on my own I had the desire to learn (through reading these
newsgroups and trying stuff on my own) so that I could do a specific task.
Whether the task was born of curiosity or a specific need for work -- that's
something else!

If you are bored, set out to do something challenging with Excel that you
want to use VBA to do (or even try to do easy stuff in Excel, using VBA to
do it instead of worksheet formulas), then research how to do it on here and
on the web and see if you can get it to work. At least, that is how I've
found is the best way to learn something well and have it more or less
stick!

If you want a specific class, I don't know of one in particular, but Bob
Umlas (an MVP) has offered a class, or masterclass, recently which maybe
geared towards your level.

 

[Norman Harker]

Hi Eric!

If you're in the New York area then Bob Umlas runs some pretty
powerful courses:

(e-mail address removed)

I'm not sure where else he might run programs and have lost the link
to a pretty impressive program.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Eric]

I think you're right on the mark. To this point I have
learned excactly the same way you have, one problem at a
time. I guess that is the best, and possibly, only way.
I would like to accelerate my learning, but as you pointed
out I should just be patient and continue to learn one
problem at a time.

Thanks for your insight.

Eric

 

[Guest]

Easy big fela, no need to take this personally.

Your points on VBA are well taken, and I agree
wholeheartedly with your comments regarding pivot tables
and arrays. To be clear I certainly do not think I am in
any way superior to someone who posts, what to me is
a "remedial" question. I just get bored looking through
20 or 30 posts before coming to something I am not
familiar with. That's all.

Thanks for your post it was very helpful. I might suggest
toning down the hostility in the future.

Thanks,

Eric

 

[Ken Wright]

LOL - Wasn't aware that there was any included - I'd have given up the ghost
long ago if I had thought that amounted to hostitility.

 

[Eric]

So you will forgive me then. Right?

 

[Eric]

I am in NY from time to time. Thanks for the info.

Eric

 

[Ken Wright]

hehehe - what's to forgive? - Stick around and see some fun and games when the
fur really starts flying

Seriously though, I personally think this is one of the best learning mediums
around. I like to monitor 4 or 5 main threads as a rule, and I find it hard to
keep up with half of them, let alone get bored with them. Just in case you
hadn't seen all the others, here are a selection of the main ones:-

microsoft.public.excel
microsoft.public.excel.charting
microsoft.public.excel.links
microsoft.public.excel.misc
microsoft.public.excel.newusers
microsoft.public.excel.programming
microsoft.public.excel.worksheet.functions