Excel Training Good Topic Good Materials

I was asked to conduct Excel Training from Basic to Advance during a course of two weeks.
i have been working with excel since 1997. i have knowledge in all functions and VBA and etc.
since this will be my first long session training, i am looking for some tips and advise or some handy materials and or some useful topics that will be useful and interesting to the workshop participants.

any help is appreciated.
LVL 27
ProfessorJimJamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Glenn RayExcel VBA DeveloperCommented:
I conduct monthly Excel training sessions for my company and have a couple of suggestions for you:

1) Send a follow-up email to each attendee with resources/links to more information.  Often there isn't enough time in each session to cover everything and online help through Excel is lacking.  I can recommend the following:
Microsoft Excel Functions (2010)
I ask all attendees to bookmark this page as a handy reference.
Keyboard Shortcuts in Excel 2010
A standard reference; most users don't know or take advantage of these shortcuts.

Microsoft offers online videos that cover the above topics as well.   Just search for "tutorials" at the Office website.

2) Whenever possible, create example workbooks and deliver those to attendees in advance.  If your topics involve data tables (ex., Lookup/Indexing functions, PivotTables), it will be good for them to see the data before a session.  Have them bring laptops when possible (or provide computers during the session).  Nothing beats hands-on experience.

Good Luck,
Glenn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Glenn RayExcel VBA DeveloperCommented:
Of course, there are lots of other Excel resources online (Chip Pearson, Chandoo.org, MrExcel) but I tend to refer folks to Microsoft first as it's a good centralized repository.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.