Excel Training Good Topic Good Materials

Posted on 2014-08-28
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
    LVL 27

    Accepted Solution

    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
    Of course, there are lots of other Excel resources online (Chip Pearson,, MrExcel) but I tend to refer folks to Microsoft first as it's a good centralized repository.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now