1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can anyone recommend an online Excel course

Discussion in 'BlackHat Lounge' started by meathead1234, Apr 13, 2012.

  1. meathead1234

    meathead1234 Moderator Staff Member Moderator Premium Member

    Joined:
    Sep 24, 2008
    Messages:
    3,816
    Likes Received:
    13,930
    Hey guys,

    I have a couple of staff who could do with some training on Excel. I don't have time to do it myself (and I'm not amazing, either), so would like them to do a course.

    Doesn't need to be too advanced - probably beginner/intermediate level. Does anyone know of any suitable online courses? Preferably with case studies and an exam so they can follow it and get results.

    + rep for the best suggestions!

    Thanks!
     
  2. ljt3759

    ljt3759 Regular Member

    Joined:
    Nov 18, 2009
    Messages:
    228
    Likes Received:
    100
    Occupation:
    Entrepreneur
    Location:
    Lewis-Tisdall.com
    Home Page:
    lynda.com has some great courses, I'm very sure they have one for Excel, they make them in different levels too! Video courses with case study files to follow along with! Should be perfect for the situation.
     
    • Thanks Thanks x 1
  3. lancis

    lancis Elite Member

    Joined:
    Jul 31, 2010
    Messages:
    1,632
    Likes Received:
    2,384
    Occupation:
    Entrepreneur
    Location:
    Milky Way
    Home Page:
    • Thanks Thanks x 1
  4. Knoxgates

    Knoxgates Supreme Member

    Joined:
    Aug 9, 2008
    Messages:
    1,266
    Likes Received:
    918
    Simple tutorials can be found over here
    Code:
    http://www.free-training-tutorial.com/
    If you want advanced tutorials you download this torrent[Lynda tutorial]
    Code:
    http://extratorrent.com/torrent_download/2389380/Lynda+com+Excel+2010+Essential+Training+%2B+2+Extra+Courses+-+Team+MJY.torrent
    Both are video tutorials.
     
    • Thanks Thanks x 1
    Last edited: Apr 13, 2012
  5. bakxos

    bakxos Regular Member

    Joined:
    Aug 8, 2010
    Messages:
    498
    Likes Received:
    292
    Location:
    Scotland
    Yea Lynda.com has quite a few for excel.
    I suppose you want them to learn about data entry, data manipulation etc so I think thats a good one.
     
    • Thanks Thanks x 1
  6. meathead1234

    meathead1234 Moderator Staff Member Moderator Premium Member

    Joined:
    Sep 24, 2008
    Messages:
    3,816
    Likes Received:
    13,930
    Thanks guys.

    To clarify it will be basic things like data manipulation, basic accounting etc. A solid knowledge of formulae and formatting would be all I need for now.
     
  7. sirgold

    sirgold Supreme Member

    Joined:
    Jun 25, 2010
    Messages:
    1,260
    Likes Received:
    645
    Occupation:
    Busy proving the Pareto principle right
    Location:
    A hot one
    Well for how obvious it might sound for a quick reference of the super basic formulas nothing's probably better than hitting F1 in excel. But since you said you need help understanding data manipulation (so I assume an intermediate level), I think this website http://www.functionx.com/vbaexcel/ might come handy. It teaches with practical examples and scripts how to start dealing with the most interesting things you can do with Excel. So that you can use excel for what it was meant to be: a simple database with a streamlined "standard" visual view.HTH
     
    • Thanks Thanks x 1
  8. rinksrat

    rinksrat Registered Member

    Joined:
    Jul 10, 2009
    Messages:
    78
    Likes Received:
    4
    Occupation:
    engineering
    Location:
    Portland OR
    Lyndia.com will teach you everything and more than you will ever want to know.
     
  9. meathead1234

    meathead1234 Moderator Staff Member Moderator Premium Member

    Joined:
    Sep 24, 2008
    Messages:
    3,816
    Likes Received:
    13,930
    Lynda looks pretty solid - think we'll give that a go next week and see how it goes.
     
    • Thanks Thanks x 1
  10. fad3r

    fad3r Power Member

    Joined:
    Sep 17, 2011
    Messages:
    733
    Likes Received:
    115
    Location:
    nyc
    Youtube has a ton also.
     
    • Thanks Thanks x 1
  11. oxonbeef

    oxonbeef BANNED BANNED

    Joined:
    Jan 4, 2009
    Messages:
    2,242
    Likes Received:
    7,872
    Lynda is great but I don't know why so many people miss this
    wealth of information.

    Rep given.

    Everyone wants to be at the top of Google but no one uses it.
     
    • Thanks Thanks x 2
  12. fad3r

    fad3r Power Member

    Joined:
    Sep 17, 2011
    Messages:
    733
    Likes Received:
    115
    Location:
    nyc
    Lynda is great as is learnkey but youtube is great and free. Can pretty much learn anything on it.
     
  13. maestropanda

    maestropanda Junior Member

    Joined:
    Nov 1, 2009
    Messages:
    191
    Likes Received:
    56
  14. meathead1234

    meathead1234 Moderator Staff Member Moderator Premium Member

    Joined:
    Sep 24, 2008
    Messages:
    3,816
    Likes Received:
    13,930
    Yeah - although, I'm more looking for something structured than specific units. I'd rather have some fancy sheets and tests to work through. I will have a browse of YouTube, but I'd quite like to just give them a fixed course to follow and leave it at that. I know if I tell them to look on YT and follow a few examples, they will just end up watching funny videos and music :)
     
  15. shailzrocks

    shailzrocks Jr. Executive VIP Jr. VIP Premium Member

    Joined:
    Jan 1, 2012
    Messages:
    1,113
    Likes Received:
    1,766
    Occupation:
    Dolphin Seller in a Black Market
    Location:
    No Man's Land