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:
LittleFriendSusan · 12/01/2022 22:42

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.

BookFiend4Life · 12/01/2022 22:41

Are you grabbing the corner of the cell with the formula?

Lougle · 12/01/2022 22:38

Oh, so what I would do is click on the cell with the first answer, hold down Ctrl + C (copy), then click and drag all the other cells you want to put the formula in, and press Ctrl + V (paste).

soisealta · 12/01/2022 22:37

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

OP posts:
soisealta · 12/01/2022 22:35

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

OP posts:
Lougle · 12/01/2022 22:33

This is on my mobile phone, but you can see that I've clicked in one cell and dragged down the next 4, so it's put the range in the formula. In desktop Excel, the colours of the first cell and second cell in the range would be different.

Help! Can anyone recommend a complete Excel course from beginners?
PlanetNormal · 12/01/2022 22:32

I’m a regular but inexpert Excel user, and I’m completely un-techie, so it can be a struggle at times. When I don’t know how to do something, I find the ‘JFGI’ command is often very useful.

Just F***g Google It. Grin

Lougle · 12/01/2022 22:26

[quote soisealta]**@Lougle* The =sum(C3C4) works to multiply that particular cell, but when I drag it down the table and press enter - nothing happens?

@TildaRae Thanks I am having a look.[/quote]
What are you dragging down the table and what are you hoping it will do? Sorry, I didn't quite understand.

soisealta · 12/01/2022 22:24

@Lougle The =sum(C3*C4) works to multiply that particular cell, but when I drag it down the table and press enter - nothing happens?

@TildaRae Thanks I am having a look.

OP posts:
TildaRae · 12/01/2022 22:20

I also recommend udemy. The course is really good and detailed and reasonably priced as well.

Lougle · 12/01/2022 22:17

Adding up cells can be really easy by using =sum(first cell:last cell).

You can either type in the cell references, or click and drag to highlight all the cells you want added up. The : indicates that you're selecting a range of cells.

drwitch · 12/01/2022 22:10

Its also tricky making sure that the formula box is linking to the correct cell. If you are not careful with the return or enter key it can link to a different one. (This may be the trouble you were having).

soisealta · 12/01/2022 22:06

Thanks @thegcatsmother Love your name btw!

OP posts:
thegcatsmother · 12/01/2022 22:03

Udemy have Excel courses on offer for about £10 at times. Very slow, but great for Excel novices like me. It's an online course you do at your own pace.

soisealta · 12/01/2022 21:55

@BookFiend4Life Thanks that is useful.

OP posts:
BookFiend4Life · 12/01/2022 21:53

Hey OP, lots of good recommendations on here! My whole job is pretty much using excel and I'm no expert. My husband also uses excel a lot and we are always amazed by what the other one doesn't know! I recommend YouTube videos and looking up "how to (blank) in excel" over using a book because you can see things happening in real time. I will say pivot tables can be very useful because they can crunch a lot of formulas for you, so maybe try to find a tutorial on those. My favorite function is Index/Match. If anyone tries to tell you to use VLookup instead they're wrong!

soisealta · 12/01/2022 21:22

Thanks @SquishySquirmy, @Lougle, @HalfShrunkMoreToGo

I hope I don't have to memorise it, because it seems a bit too much like maths for my abilities!

OP posts:
HalfShrunkMoreToGo · 12/01/2022 21:04

Microsoft have a suite of free trainin* for all 5heir products. Here's the link to the excel series

support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb

Lougle · 12/01/2022 21:00

But if you make mistakes, a box flashes up, either to suggest a change that would fix the formula, or saying that you need to fix it.

I think as a beginner, the most important thing is to save your spreadsheet before you make significant changes. Give the spreadsheets a title that makes sense and a version number. Save regularly, and save a new version before you make the next significant change. You can always delete old versions later. It will save you many tears when you've spent 20 hours on a sheet and then one formula completely mucks it up but you can't work out which one.

Lougle · 12/01/2022 20:57

That should read
=IF(ISBLANK(D2),"","Sum(D2 + C1)"

Lougle · 12/01/2022 20:56

Generally, if you put into Google 'how do I....in Excel" you will be able to copy and paste the formula.

There is a standard form in Excel and once you learn that, it makes it easier to understand why the formula works.

Every formula starts with '='. Every cell in the spreadsheet has a cell reference, which is the column letter and the row number. So B2 is second column, second row.

When you use a formula to add two cells together, you can type '=A1 + B2', for example. If you copy and paste that formula, though, it will change A1 and B2 as it goes down, so the next line would read "=A2 + B3". If you don't want that, you put a $ before the bit you want to keep the same. So "=$A$3 + B1" means that the cell referenced A3 would always be used, and the cell that is added to it would change.

  • is multiply / is divide

IF compares a cell against a statement and you give two outcomes. So a classic one is when you want to make your spreadsheet neat. You can type =IF(ISBLANK(D2),"","Sum(D2 + C1")

That's saying:
"Check if the cell in the 4th column and 2nd row is empty. If it's empty, leave this cell empty. If it isn't empty, add the number in the 4th column and 2nd row to the number in the 3rd column and 1st row, then show that number here."

SquishySquirmy · 12/01/2022 20:34

I use excel a lot, and I am pretty confident with it.
However, I still only use a tiny part of excel capability on a day to day basis, and when I have to do something I'm rusty on/new to I use the help function!

So even once you have got used to the basics, don't be afraid to use the help function or google to check how to do certain things.
I find that learning as I go by doing is better than reading a book or similar.
Sorry I'm not more helpful with course suggestions. But whatever course you do, make sure it has practical exercises. Experience over theory. And see it as something you will never really finish learning, iyswim.

soisealta · 12/01/2022 20:18

Thanks @MaryAndGerryLivingInDerry. I will look at those tonight.

@drwitch Yes it is a bit of a confidence thing I think since I've been out of education for nearly 20 years since my GCSEs. I'm wanting to learn Excel because I ultimately want to get into Admin work so I'm doing a course which is the equivalent to A Level Administration and Business. If I can work it around my current jobs financially (and with my health) I hope to do HNC as well.

@RoomOfRequirement Thank you I will look at this.

@Graphista Thanks the links would be good. I'm disabled too now although I do manage some freelance type work at the moment. It's great that you are relearning it as they do seem to change. I have very vague recollections of doing spreadsheets in the early 2000s but I don't even know if that was even Excel. It would be good to learn together, as you say, it does just seem to be about muddling along as we go. I got myself a bit stressed earlier because I am understanding the other 4 classes I have just not this one at all. Don't think it's the class pitched too high I think it's that technically I have GCSE Admin so I got into the course, so they assume that level of knowledge but I don't remember a thing about it and everyone else in the class seems to have some either recent-ish school or work experience with it at the GSCE level. We've been doing it all of December before the Christmas break and I don't understand. Today we were doing IF function (whatever that is!) and I still cannot work out how to do the additions AND copy the formula for more than one cell, and I am not getting the language and terms either.

@Mercurial123 Thanks I saw that one.

OP posts:
Mercurial123 · 12/01/2022 16:59

I have Excel for Dummies at work. I don't use it that often, and this book is great reference for a quick and easy explanation.

Graphista · 12/01/2022 16:51

I'm gradually "relearning" myself I found some good video tutorials I think by a Canadian chap. I'm not at home at the moment but placemarking so I can check and post you the links later.

But yes good to do a "dummy" one and play around with it - you won't break anything. The software itself tends to give a heads up if you do something weird too.

I've just figured out how to do equations across multiple worksheets

I used to use ms office a lot in my work but disabled and unemployed now and the shortcuts have changed a fair bit I've found.

Maybe we can muddle along and learn together? Perhaps with help from other mners?

I have my own and dds budget on mine but I'd like to learn more with a view to hopefully returning to work or self employed admin work later this year

You could ask the college tutor for recommended books and online courses etc I'm sure she'll have come across this issue before

Tbqh I bet if you raised it in class chances are you're not the only one and maybe she's pitching the class too high? Come across that before!