You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have very basic excel skills, like I can sort and filter and that’s about it.
A change in role at work is exposing me to vlookups and pivot tables, which are pretty much an alien language to me...
Any good online tutorial type sites where I could spend some time most days learn what on earth to do !?
Hi Iainc,
I don't have a specific recommendation, but there'll be hundreds of channels on YouTube with what you'll need. My advice would be watch a few and find someone you like listening to and understand then search through their channel for the specifics. I did this with a similar MS product and learned loads.
RM.
Exceljet is a great resource.
I find YouTube videos overly long in attempt to intro / hit 20mins to monetise on ads and don’t get to the point quick enough.
Worth seeing if your work will pay / throw you into a one / two day in person course. You’ll prob be only person in classroom and pick up quick without distractions.
I generally find it helps to have a specific task in mind and learn how to complete that task.
I had to write an insurance quote engine in excel once for example so had to learn look-ups, nested if statements, conditional formatting etc but as it was goal orientated I quickly learnt what I needed and I don’t I would have gained the same knowledge but just ‘trying to learn excel’ if that makes sense.
I then just googled for each bit I needed and worked from there
Plenty of training sites out there that will offer trial or free accounts. Pluralsight, Skillshare, Udemy, Coursera are a few that spring to mind.
Microsoft also offers some basics to get you started:
Cheers folks, some great pointers
Self-taught and probably not a good man for advice but:
If you're genuinely learning from scratch & doing things yourself, not working out what your predecessor has done, I'd learn Index/match instead of lookup
Pivots are pretty much a doddle
I hate videos, much prefer readable pages
Check out ExcelisFun and WiseOwl on youtube.
Never admit you can use pivot tables or you'll have to do them all the time.
The secret is that they're daft easy so don't do it too quick or you will miss out on stw time.