Please or to access all these features

AIBU?

Share your dilemmas and get honest opinions from other Mumsnetters.

Help! Can anyone recommend a complete Excel course from beginners?

58 replies

soisealta · 12/01/2022 15:38

I've started trying to teach myself Excel. I've been trying some free resources, but I think what I need is a comprehensive course from beginner upwards.

Preferably in book form, but I could also do it online. I'm on a low income so not too expensive if possible.

I'd really appreciate some personal recommendations because the selection is dazzling!

Thanks

OP posts:
RoomOfRequirement · 12/01/2022 16:48

Coursera has an everyday excel course with 3 levels. It's £49 but you can access all of the videos for free by choosing to 'Audit' the course. The first one especially is great.

drwitch · 12/01/2022 16:46

I think its your confidence more than anything (from what you say). I guess your course is teaching you to use Excel for something specific - if you let us know what this is then perhaps we may be able to give you some more advice.
If it is confidence it may be that doing a course just confuses you more

MaryAndGerryLivingInDerry · 12/01/2022 16:40

Try the goodwill community foundation on YouTube. Loads of free videos on computer skills including excel. I’ve found them really good.

drwitch · 12/01/2022 16:36

I completely agree with @MorningStarling. Once you have the basics (and by that I mean understand what a spreadsheet is and how to navigate (up and down and between sheets)) you should work on what you need to do and use the excel help and google to work out how to do it. -

soisealta · 12/01/2022 16:33

@itwasntaparty I did see all the courses, I just have no idea which ones to do.

OP posts:
soisealta · 12/01/2022 16:31

Thanks @MorningStarling

It's actually for a college course I am already on! We are starting to do Excel just now and I have realised that it has been soo long since I was at school that I don't even think I did excel at school. We have started this week and it's like gobbldegook to me Grin Grin. It's supposed to be A Level Administration equivalent and technically i have the GCSEs for it but they are assuming some kind of basic Excel knowledge when I have none. Most of the class are younger than me and seem to get it. The tutor is nice but she can't spend hours getting me up to starting level.

I have the next couple of weeks to getting myself up to speed or I am going to fail the unit sadly.

OP posts:
itwasntaparty · 12/01/2022 16:29

Google, there are loads of free entry level courses on line.

MorningStarling · 12/01/2022 16:10

Check with your local library to see if they do Excel courses. Some do, for instance there's this one in March but won't be any use for you if you're not local.

This advice probably doesn't answer your question but in my experience books were never helpful. I tried a few ("...For Dummies", that kind of thing) but they always seemed to assume a certain amount of knowledge. It's much easier in a face-to-face course where you can ask questions.

The best thing you can do to begin with is just "play" with it. Experiment with things, see what works and what doesn't. Investigate one topic or area at a time - trying to run before you can walk will set you up to fail, you will probably get frustrated if you try to many things at once.

Think about what you want to use Excel for. It has many uses but 90% of users probably only need 10% of what it can do. If you want to use it for home budgeting for example you'll want to focus on different areas to if you were intending to write macros in Visual Basic. You'd also need different skills to begin with, for example if you are using it to calculate a budget you'd need maths skills because otherwise if you're setting up a spreadsheet you won't know whether it's giving the correct values. Likewise you need to understand how to do something manually before you can create a macro to automate it.

Hopefully someone else will recommend a course that they've used, I've been Excel-ing for so long I've kind of forgotten how I got started.

Oh, and there's nothing wrong with being one of the 90% who only ever use 10% of the package available. That first ten percent gets you a long way.