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:
New posts on this thread. Refresh page
LittleFriendSusan · 15/01/2022 10:49

@NotBabiesForLong

My DH loves indexmatch. Super loves indexmatchmatch and is now raving about XLookup. Don't we have exciting conversations in our house.
Ooohh thanks for this, I've just learnt a new trick 😂
MoanyMo · 13/01/2022 12:34

www.udemy.com there are loads of excel courses on here that are quite reasonable.

Hillarious · 13/01/2022 09:59

I've tried youtube tutorials, and was desperately trying to learn how to do a vlookup. I have a boss who is very good at doing this, showing off her prowess in this, but always reluctant to share her expertise (power, control). I struggled to learn, until my DS, in his final year at uni studying Economics, showed me. I've since taught lots of other people at work to do it.

NotBabiesForLong · 13/01/2022 06:55

My DH loves indexmatch. Super loves indexmatchmatch and is now raving about XLookup. Don't we have exciting conversations in our house.

NickiWap · 13/01/2022 06:44

I'd recommend this free 'course' on YouTube, when I was getting used to using excel I would watch these videos then practice alongside.This guy has videos on almost every single aspect you can imagine from complete beginner to advance.

youtube.com/playlist?list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

dumphies21 · 13/01/2022 06:31

I'll do a training session with you if need one OP - excel is a huge part of my job, and we could go over anything you need/want to know - DM me if you want to

Lougle · 13/01/2022 06:27
shows you how you can customise your ribbon, so that you have all the buttons you commonly use available without having to go through layers of menus.
Lougle · 13/01/2022 06:17

www.howtogeek.com/714701/how-to-switch-back-to-the-classic-ribbon-in-microsoft-office/ This shows you how to get rid of the compressed ribbon (menu) and expand it.

Lougle · 13/01/2022 06:14

@TrickorTreacle

This isn't excel for me, but more specific Office... is there a "system" or technique around learning the new Excel/Office interface?

In the early days of Office, you had a simple toolbar that said File Edit View Format Help etc, and I learnt where everything was.

Then in the 2010s, that toolbar changed so it says Home Design Layout Review with multiple rows of commands and I can't memorise where the old commands were. I'm having to google every time where the old commands are.

Is there a system for learning the above? It's been around for 10+ yhears now and I still can't memorise the new command placements!

If you're doing the same sort of thing all the time on it, you'd be best to create a template which uses the font you like, line spacing, margins, etc., so that all you really need is to be able to adjust bolding, font size, justification, etc., as you go.

Control commands are worth learning. Google 'keyboard shortcuts' if you're not familiar with them. You'll get a list such as CTRL + B = Bold

Riverlee · 13/01/2022 04:27

Go Skills

We’ve used Go Skills before to learn Excel. It seemed a good course.

Wowserme · 13/01/2022 01:08

You should find YouTube to be very helpful

FinallyHere · 13/01/2022 00:51

@TrickorTreacle

I can't memorise where the old commands were.

The version of Excel that I use has a search box in the top bar, something like 'what do you want to do'. I type the old command in there and it responds with a list of things which match. If I select one of these options it takes me to that command.

After using it a few times, I start to remember the new location action.

It is at sort or 'tailored' google search.

Nanny0gg · 13/01/2022 00:32

[quote soisealta]@Lougle

I'm not very good at explaining sorry!

So when I put in the formula in the text box at the top - to multiply two cells in a row eg C3D3 , and press enter, it does multiply those cells correctly in the next 'total' column. However I am supposed to know how to export that calculation down to for example C4D4. So I highlight the first cell with the solution, and I drag it down and press enter. Nothing happens.[/quote]
Why are you putting the formula in the text box and not the cell where you want the answer?

TrickorTreacle · 13/01/2022 00:12

This isn't excel for me, but more specific Office... is there a "system" or technique around learning the new Excel/Office interface?

In the early days of Office, you had a simple toolbar that said File Edit View Format Help etc, and I learnt where everything was.

Then in the 2010s, that toolbar changed so it says Home Design Layout Review with multiple rows of commands and I can't memorise where the old commands were. I'm having to google every time where the old commands are.

Is there a system for learning the above? It's been around for 10+ yhears now and I still can't memorise the new command placements!

SkiingIsHeaven · 12/01/2022 23:22

Excel for dummies is a good book.

I reckon that would be cheap second hand.

Good luck.

soisealta · 12/01/2022 23:15

Thank you so much everyone, I really appreciate all your help.

I'm going to bed soon as I've just finished my current job but I will be off tomorrow and attempting Excel once again so I will come back and reply.

Thanks again.

OP posts:
littledrummergirl · 12/01/2022 23:10

I'm self taught at excel and would love to do a course but I think that I would struggle because although there are some basics I'm missing, there are a few areas that I don't think they would teach for a while (drop down boxes, developer mode, multiple books). My main problem is how to write more complex equations (if a1= b6 and c5 then do action x if a1=b6 or c7 then do y, etc).

I find online tutorials for each task are fab. The last thing I learnt to do was import a data sheet to save writing it and sort into usable data.

PiscesScot · 12/01/2022 23:08

www.excel-easy.com/

This is a good resource for getting to grips with excel. Don’t be scared of formulas, you’ll get your head round the basics quickly!

SquidGin · 12/01/2022 22:59

Also I see you’ve mentioned IF formulas obviously I would need to see your spreadsheet to help exactly!

Personality when I am teaching colleagues how to use excel I prepare generic formula which is copied on to a word document which they can then apply to their spreadsheet only needing to change particular trigger cells

It’s unlikely you will need to use vast differences of the same formula unless you work to an advance level

The customisable formula based on your needs are a real help to people with a basic knowledge of excel

Anyway happy to help if you want to pm either way just have confidence! Wishing you the best of luck with your new future career x

FinallyHere · 12/01/2022 22:46

@soisealta

I'm a self taught but very keen Excel (XL) user who would love to help. It would be much easier for someone to help you if they could see your screen.

You are welcome to PM me, I'd be happy to screen share with you to get over any specific problems. I can't imagine what would be stopping that cell from being copied but am confident that I would know immediately if I could see the screen.

I'd be glad to support your efforts to learn Excel.

SquidGin · 12/01/2022 22:46

Hi,

Not sure what sort of specific things you need for excel but just with you simple C3*D3 (which should be simple Grin) it sounds like excel is not isolating the data so I would suggest highlighting the above formula in the formula bar and clicking f4 and then enter then hovering over the right bottom corner of the box displaying the correct calculation and double clicking this should automatically pull down all data correctly!

How to books/ even training programmes can be a minefield, it’s not because someone is clueless just a direct explanation and positive outcome can help the information stick in your memory and become a building block!

Google is massively helpful but before you can understand the instructions properly you need a good round all knowledge.

If there’s anything I can help with directly just drop me a pm Smile

Lougle · 12/01/2022 22:44

[quote soisealta]@PlanetNormal Believe me, I've tried that! It just confuses me more. I think my mind just doesn't work like this (!) so I'll need to put in serious effort and repetition to 'get' this.[/quote]
<a class="break-all" href="https://www.google.com/url?sa=t&source=web&rct=j&url=m.youtube.com/watch%3Fv%3DAY3Ef5VHB-Q&ved=2ahUKEwiKkqL5pK31AhVIQMAKHTDNDEAQxa8BegQIDBAE&usg=AOvVaw1St5G3AgGPckITpAw2cxuI" rel="nofollow" target="_blank">YouTube video try this Smile

MsAgnesDiPesto · 12/01/2022 22:44

@LittleFriendSusan

If you hover in the bottom right corner of the cell containing the formula until a cross appears, and then drag down, this should copy the formula into the cells below. Or copy the cell (CTRL + C), highlight the cells you want to copy to, then paste (CTRL + V). You can also choose paste special / paste formula.
This is my method too. I think that you need to click away from the box you’ve just typed the formula in to, before you can then click back on it and ‘grab’ the handle to pull it down the rest of the row - could this be why it’s not working for you?
FGSWhatNow · 12/01/2022 22:43

When you drag down you need to click on the cell, then click on the bottom right corner of the cell border (the cursor changes to a "+" if you've clicked in the right place) and drag down. Is that how you're doing it? It sounds as though you're just highlighting a range of cells instead.

BookFiend4Life · 12/01/2022 22:42

Look up how to sum column and watch a video!

Swipe left for the next trending thread