+ Reply to Thread
Results 1 to 5 of 5

If you to teach Excel 101/102 to colleagues...

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Vancouver, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    If you to teach Excel 101/102 to colleagues...

    Hello all,

    I have been approached by my office to teach some of my colleagues some Excel tips/tricks, best practices etc!!! Apparently I am seen as hardcore power user with wizard/guru-like abilities... if only they knew the truth! Haha, but I suppose all is relative. I guess I am a bit of a power user and I am a big fan of Excel's capabilities - but really I have learned it all through continual use and experimentation over the past decade!

    Our office is not huge and we have a large range in proficiency of Excel ability and heavy to light users.

    So probably the best approach is to offer a two different workshops, 'novice/beginner' and 'intermediate/frequent' use.

    My question is... what topics would you cover in each of those levels? And how would you approach and deliver the workshops?

    The purpose of these workshops is to:
    • aid internal skills learning and professional development;
    • leverage internal knowledge;
    • reduce the number of times people come up to me directly to say: "I have a problem with Excel... can you have a look at a formula for me?"

    Not that I mind helping them! In fact I always like an excel challenge, but it's not really my day job...

    I imagine the workshop will probably be for an hour or so, and it's stuff like teaching people vlookup - but that's so common and well-known, I'd probably teach them index-match as the upgrade to that...

    I'd really appreciate any thoughts and suggestions!

    Thanks!

    Ian

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: If you to teach Excel 101/102 to colleagues...

    I would strongly suggest to teach the basics and then have each of your colleges pick a meaninful project for them (1 per person)

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If you to teach Excel 101/102 to colleagues...

    ...in the land of the blind, the 1-eye'd man is king...lol

    the division you propose will probably work, but I have found that sometimes people *think* they are good at/know excel, until you start asking questions or telling them *stuff* about functions.

    I think your best bet would be to include everyone in the 1st class. If its only going to be an hour, it wont be a big loss for those that are past that, but will benefit those that are not, and ID those that thought they were past that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: If you to teach Excel 101/102 to colleagues...

    I'd ask everyone to send their most complicated workbook.
    I would analyse those and make for every one a more sophisticated alternative.

    You can start your class analysing each workbook and showing them step by step what can be improved, resulting in presenting your alternative.

    Doing so you can :

    - assess the Excel ability of your colleagues based on their 'products'
    - find out the common 'weaknesses' of their knowledge
    - show immediate improvements by your instruction
    - trigger the curiosity of the folks whose example workbooks haven't been discussed yet in class, so they will ask for more....
    - you will be the one who learns the most of all !



  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: If you to teach Excel 101/102 to colleagues...

    I suggest that you have them record and then edit simple routines - use the ActiveCell and offset method to start and then go from there

    And/snb

    "you will be the one who learns the most of all ! "
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Suggestions to impress my teach on my Excel project
    By AStudent in forum Excel General
    Replies: 1
    Last Post: 11-20-2012, 02:11 AM
  2. Macro Works On My PC But Not On My Colleagues?
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-19-2012, 03:58 AM
  3. Using Add ins to share macros with colleagues
    By zestygirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2010, 12:17 PM
  4. Automatic Calculation:my colleagues
    By kendo2748 in forum Excel General
    Replies: 1
    Last Post: 06-23-2009, 05:33 AM
  5. Replies: 1
    Last Post: 05-10-2009, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1