Excel Training Good Topic Good Materials

Posted on 2014-08-28
Medium Priority
Last Modified: 2014-08-28
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.
Question by:ProfessorJimJam
  • 2
LVL 27

Accepted Solution

Glenn Ray earned 1500 total points
ID: 40291228
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,
LVL 27

Expert Comment

by:Glenn Ray
ID: 40291414
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.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question