Learning to use Excel

So I have had a bit of a career change and I'm more involved with sales these days. As a result I am now being confronted with excel spreadsheets. Lots and lots of spreadsheets, and I'm expected to create my own. Being a millenial I assumed that I was "ok with Excel" but now working with people who are actually good with it, I realise that I basically haven't got a clue.

What's the best way to learn? Online presumably? Anyone got any recomendations?
 

mikemanc

Winger
So I have had a bit of a career change and I'm more involved with sales these days. As a result I am now being confronted with excel spreadsheets. Lots and lots of spreadsheets, and I'm expected to create my own. Being a millenial I assumed that I was "ok with Excel" but now working with people who are actually good with it, I realise that I basically haven't got a clue.

What's the best way to learn? Online presumably? Anyone got any recomendations?
Stacks of videos on YouTube showing you how to create pivots, use certain functions, write macros, use power BI etc. Mostly by channels specifically set up to teach excel, sure they'll have beginner/intermediate playlists
 
Stacks of videos on YouTube showing you how to create pivots, use certain functions, write macros, use power BI etc. Mostly by channels specifically set up to teach excel, sure they'll have beginner/intermediate playlists
Yea I've used a few of them to do specific things, but some of the "courses" on there were a bit shit. I'm quite happy to pay for something if it is well structured.
 

S.S.R..

Midfield
I find learning is easier when you have a specific task to learn the various functions. If I had someone just reel off dozens of them over a short period of time, I'd just completely forget them a week later.

Everything I've learned from excel has been "I want it to do this, how do I do this?" Googling for it, then fiddling about till it works. I doubt I'd have a clue just being told out of context.
 
Last edited:
So I have had a bit of a career change and I'm more involved with sales these days. As a result I am now being confronted with excel spreadsheets. Lots and lots of spreadsheets, and I'm expected to create my own. Being a millenial I assumed that I was "ok with Excel" but now working with people who are actually good with it, I realise that I basically haven't got a clue.

What's the best way to learn? Online presumably? Anyone got any recomendations?



 

The soap powder

Central Defender
There is a canny site on the internet called You Tube it will show you lots of videos on how to use excel ....... However it also shows lots of funny videos about dogs and cats and stuff ..... enjoy
 

YodasBell

Reserve Squad
I must admit, Google is your best friend. Some functions you might only use once or twice and you will have forgotten how to do it the next time you need it....

Just learn what you need, when you need it.

I always think learning Excel on a course is pointless - you don't really know what you need to know until you need it, and by virtue of the fact that you don't know what it can do, you might not ask the right questions.
 
I find learning is easier when you have a specific task to learn the various functions. If I had someone just reel off dozens of them over a short period of time, I'd just completely forget them a week later.

Everything I've learned from excel has been "I want it to do this, how do I do this?" Googling for it, then fiddling about till it works. I doubt I'd have a clue just being told out of context.
I'm very good with excel, and it's because for the better part of 15 years I've done this.

If an excel job seems like it's going to take fucking ages theres generally a quicker way to do it.
 

Top