Free excel course?

[Diddums]

I find myself in need of an Excel course. I don't mind paying for it but I thought I'd go down the free route first as I've heard that there are some decent ones out there.

I'm not looking for anything advanced, just basic stuff to get to grips with it whilst I've got some free time, and once I'm confident with it I'll explore my options as to moving on.

Any suggestions?

 

[Diddums]

Well I'll be damned. I just had a nose around on our Intranet and found a relevant place to start.

Overview/Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Prerequisites
n/a

Expected Duration (hours)
1.0

Lesson Objectives
Creating Workbooks, Worksheets, and Data in Excel 2013

create a new workbook and open a workbook in Excel 2013
decide how to create a new workbook in Excel 2013
move around Excel and enter data
cut, copy, and paste in Excel 2013
edit data in Excel 2013
delete or hide a worksheet
organize and modify worksheets in Excel 2013
choose the best way to organize and modify worksheets in Excel 2013

I don't expect it to be of the highest quality so if anyone has any recommendations, please do share them

 

[dowie]

any book by this guy:

http://spreadsheetpage.com/

 

[Tomsk]

Try searching on youtube for basic tutorials

 

[Cosimo]

Might find one in here:

http://forums.overclockers.co.uk/showthread.php?t=18374237

 

[RDM]

http://www.gcflearnfree.org/office

Gives you the basics depending on the detail you want.

 

[Redz]

http://www.homeandlearn.co.uk/excel2007/Excel2007.html

http://chandoo.org/wp/advanced-excel-skills/

 

[Pawnless Endgame]

Do you work for a big firm? If so, check your IT department for in-house courses. I did this and was allowed to take paid time off work as it counted as training.

 

[wesimmo]

Personally I've never done an Excel course in my life but tend to be the "expert" in a department of analysts.

I'm not saying that to boast, more to suggest that if you are like me you'd get more benefit from having a problem, using mrexcel.com to help learn a technique to resolve that problem, rinse and repeat until you end up referring less and less to mrexcel and contributing solutions to others problems.

When I've done similar courses for SAS and things like that they don't suit my learning style, I end up with a load of techniques etc but little context as to when best to use them.

 

[Diddums]

Thanks all. I've got a few days off next week so I'll probably fire up a course or two and have a go


Pawnless > I work for BT and they do in fact have a training matrix but only in my own time.


That said, there's a very clear cut case of why I need to learn this so I need to just get on with it. I can afford to lose a few days to studying. Might wake my brain up a bit

 

[nas]

not free, but I've done quite a few MS Courses here:

http://www.happy.co.uk/happy-computers/

Push to have this paid for by your employer if possible.

 

[Roar87]

Just assign yourself the task of making something with it, either work related or personal/fun (football predictions, personal finance, diet, etc), then when ever you come up with problems use Google.