Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Location
    U.S.A
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Any good tutorials for Excel?

    So I built a blog, and I am trying to get a grasp of spread sheet creation to monitor stats such as traffic. Does any of you know where I can find a decent microsoft excel tutorial because I think it would probably be the way to go in terms of spread sheet creation. I took a class back in elementary school, but that is long forgotten lol
    Last edited by Medico; 2012-08-20 at 04:17.

  2. #2
    Star Lounger
    Join Date
    Mar 2011
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    http://www.techonthenet.com/excel/index.php

    I've learn so much on that site. See if it suit you.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2011
    Posts
    552
    Thanks
    3
    Thanked 35 Times in 30 Posts
    A source of paid tutorials I have recommended in past is lynda.com. I do not have a stake in suggesting it, but I personally use it and it is widely used in industry and increasingly in schools. If you visit their site, you can view sample lessons to have some idea of what they are like, and whether or not your setup can receive it well.

    It costs $25 a month (and less for subscriptions of greater length), you can quit after one month, and if you are lucky your employer or educator has it available for your use, or you might talk them into it. You can spend a lot of time online with it, so home use might be expensive depending on the terms of your ISP. Public libraries and internet cafes are a pleasant alternative where available.

    Courses are broken down into chapters and lessons, so you can take things in large doses or small and repeat lessons as you wish. Excel 2010 Essential Training, for example, is 6 hours and 21 min in total, and that is only one (the longest) of the eighteen courses for Excel 2010.
    Of interest of me were two of the three courses on Windows 8 (the third is for programmers, which I am not, and all are based on beta versions). I got the hang of Windows 8 quite rapidly.

    Minor tips: make sure the treble (e.g. ‘tone’ dial on speaker) in your sound system is sufficient to let you hear the spoken word; the viewing frame has a setting at the bottom right of center to let you play a full chapter with no breaks between lessons; there is an icon in the lower right corner of the viewing screen to expand it to full screen. Recent courses in particular have excellent definition (e.g. Effective Public Speaking).

  4. #4
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    1,988
    Thanks
    36
    Thanked 12 Times in 10 Posts
    Microsoft also has some good classes and they are free
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  5. #5
    4 Star Lounger
    Join Date
    Mar 2011
    Posts
    552
    Thanks
    3
    Thanked 35 Times in 30 Posts
    Another (paid) source is the 'Professor Teaches' series of CDs. I used these at least a few versions of Office, but I'm not sure how extensive the coverage would be for a single application, and they are a different style of teaching.

    Much depends on how you learn best, and how much pain your pocketbook can take. Some dash off and spend a fortune on giant textbooks that many of us find daunting, others prefer freeware or nothing, and some of us are most comfortable with repeatable demonstrations whether paid or free. I find demos to be a quick start with sometimes surprising depth (because they love to throw a few tricks at you that are off the beaten path) and remarkably convenient (if you are willing to pay the price, and twenty-five bucks to get you started ain't bad). The big factor with online tutorials is that bandwidth is now available inexpensively to a much bigger user base than was once the case.

  6. #6
    4 Star Lounger
    Join Date
    Mar 2011
    Posts
    552
    Thanks
    3
    Thanked 35 Times in 30 Posts
    I guess I missed the obvious, and should have said that since you appear to be taking it seriously, you might consider going to 'school' for it, since adult education (assuming, rashly I guess, that you are an adult) is often the best bargain, at least in jurisdictions in which it is typically subsidized. You mentioned having taken it in 'elementary school', and that may drive some of us nuts, as we see little kids running around with cell phones while I am going crazy just trying to learn how to use mine.

    If you studied it once, chances are very good that you will pick it up easily, and it's a good idea to get it while it's going and keep your hand in. On the other hand, Tech Republic published a white paper on where the big jobs will be in the future, and it picks up on the fact that 'everyone' under a certain age in the job market is computer-literate, so the big money must be outside that area.

    Edited to add:

    I have just been reminded that the term for the cohort that has been computer-literate from an early age is 'Generation Y', which is persons born in the 1980s-1990s (and for computer purposes everyone since then and forever after). For those of us who are older the learning curve can be very steep, and we need all the help we can get. I happen to be having a very frustrating time of it at present with a cell phone, of all things, and what really bugs me is that apes can learn to use tablet computers, which might be taken as an argument in favour of Windows 8.
    Last edited by dogberry; 2012-09-07 at 14:58. Reason: Frustration

  7. #7
    4 Star Lounger
    Join Date
    Mar 2011
    Posts
    552
    Thanks
    3
    Thanked 35 Times in 30 Posts

    YouTube

    I should have thought of one obvious source (and I'm surprised that no one else posted it) but there are lots of tutorials for every imaginable thing available on YouTube.

    Just click on that link and search on Excel and a vast number of online tutorials, all of them free, will be presented to you. They are standard YouTube (video) format, but you might learn a lot in a short time. You don't have to be a member or to pay anything to watch them.

  8. #8
    New Lounger
    Join Date
    Sep 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, go to http://spreadsheetpage.com/index.php/books and you'll see all the books on Excel by the author John Walkenberg who has been creating the PUP utilities for Excel since 1996. These books are excelent and PUP as an Excel add-in is a hugh assist for all. His site is at http://j-walk.com.
    Last edited by nlesser; 2012-09-20 at 15:06.

  9. #9
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    USA
    Posts
    160
    Thanks
    3
    Thanked 20 Times in 16 Posts
    The Mouse Training Company in London, England has some free Excel training manuals available for older versions:

    http://www.mousetraining.co.uk/ms-of...g-manuals.html

  10. #10
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,197
    Thanks
    45
    Thanked 227 Times in 210 Posts

    Good place to learn Excel

    Ugh...How about

    Last edited by Maudibe; 2012-09-21 at 23:14.

  11. #11
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,197
    Thanks
    45
    Thanked 227 Times in 210 Posts
    Right within Excel 2010 is a beginner's guide. Click on the question mark in the right upper corner>Getting Started with Excel 2010>Basic tasks in Excel 2010:
    • What is Excel?
    • Find and apply a template
    • Create a new workbook
    • Save a workbook
    • Enter data in a worksheet
    • Format numbers
    • Apply cell borders
    • Create an Excel table
    • Apply cell shading
    • Filter your data
    • Sort your data
    • Create a formula
    • Chart your data
    • Print a worksheet
    • Activate and use an add-in
    There are similar links in all versions through the help menu

    HTH
    Maud
    Last edited by Maudibe; 2012-09-21 at 23:25.

  12. #12
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    281
    Thanks
    9
    Thanked 0 Times in 0 Posts

  13. #13
    4 Star Lounger
    Join Date
    Mar 2011
    Posts
    552
    Thanks
    3
    Thanked 35 Times in 30 Posts
    This is a lively thread to be sure. Loungers with a bit of loose change or a generous employer might prefer the $499 ExcelHero course.

  14. #14
    New Lounger
    Join Date
    Sep 2012
    Posts
    9
    Thanks
    1
    Thanked 1 Time in 1 Post
    Also if your having trouble finding stuff on the new ribbon version (2010) microsoft made this site , works really well too.

    http://office.microsoft.com/en-us/ou...01794130.aspx#

    Jennif

  15. #15
    Star Lounger
    Join Date
    Jun 2012
    Posts
    52
    Thanks
    3
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by Jennif View Post
    Also if your having trouble finding stuff on the new ribbon version (2010) microsoft made this site , works really well too.

    http://office.microsoft.com/en-us/ou...01794130.aspx#

    Jennif
    Finally got around to catching up on my Windows Secrets newsletter and stumbled across this thread. Had no idea this site existed and will prove very useful for quite a few people I know. Kudos for sharing that Jennif.. I think the site is brilliant and agree with you in spades.. works very well indeed.

Page 1 of 2 12 LastLast

Posting Permissions

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