Any good tutorials for Excel?

Topic

New Reply

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

Reply | Quote

Replies

http://www.techonthenet.com/excel/index.php

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

Reply | Quote

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).

Reply | Quote

Microsoft also has some good classes and they are free

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

The Mouse Training Company in London, England has some free Excel training manuals available for older versions:

http://www.mousetraining.co.uk/ms-office-training-manuals.html

Reply | Quote

Ugh…How about

Reply | Quote

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

Reply | Quote

I have learned so much from mr excel http://learnmrexcel.wordpress.com/ and http://www.youtube.com/user/ExcelIsFun,

Reply | Quote

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.

Reply | Quote

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/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-and-related-products-HA101794130.aspx#

Jennif

Reply | Quote

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/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-and-related-products-HA101794130.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.

Reply | Quote

Perhaps not tutorials but these MVPs have some great info http://www.mvps.org/links.html#Excel

Reply | Quote

Perhaps not tutorials but these MVPs have some great info http://www.mvps.org/links.html#Excel

If there is a prize for the most impressive link ever, you have just won it. I’ve never seen that page before, but it will definitely be bookmarked.

Reply | Quote

not sure if they have though since they are helpful to most people and i seen this thread — (ALL FREE) edx.org udacity.com coursera.org

p.s. do not support those heavily commercial teaching sites

Reply | Quote

not sure if they have though since they are helpful to most people and i seen this thread — (ALL FREE) edx.org udacity.com coursera.org

p.s. do not support those heavily commercial teaching sites

The second of your three sites is flagged by Spybot – I’m not sure what that is all about, but the sites are very useful.

As for not supporting those heavily commercial teaching sites, I take it you haven’t checked the tuition fees to attend university recently. Surely you do not mean to imply that I should have no choice, or that I should be denied the opportunity to learn at my own expense.

Reply | Quote