[leglock]

Do any of you have a recommendation on a great resource to learn vlookup and pivot tables starting from the basics?

[MydnightDarkfyre]

If you can get access to Lynda.com there are some great instructional videos that explain them step by step – I've used them.

FAR: 82 (Becker) 07/09/2014
AUD: 80 (Becker) 10/01/2014
BEC: 76 (Becker) 11/26/2014
REG: 82 (Becker) 02/16/2015

GA Licensed CPA 8/7/2015

CISA: 564 (PASSED) 6/11/2016 - Certification pending

[rsrasc]

Go to YouTube and type:

ExcelisFun

His name is Mike Girvin. He's really good,

I have learned a ton from him.

Give it a try!

[jbarwick]

While you are at it, learn to navigate excel with just a keyboard. Pivot Tables tend to require a mouse to be efficient but once you go mouse-less you can do wonders.

Journey Started - January 2015
FAR - 4/2015 - Passed
AUD - 7/2015 - Passed
BEC - 8/2015 - Passed
REG - 11/12/2015 - Passed

[Mamabear]

I agree with going mouse-less. I spent one entire day working without using my mouse so I could learn as many keyboard shortcuts as possible and increase my efficiency. It has made a world of difference in how fast I can work not having to touch my mouse every 5 seconds. I also agree with going to youtube to learn a lot of Excel functions. There are great videos out there that can really walk you through it. It's better if you have two monitors and can practice while the video is going.

CPA Exam - Finally DONE (November 2014)
BEC (08/10/13) 80
AUD (08/24/13) 65 (11/13/13) 85
FAR (04/12/14) 81
REG (07/19/14) 69 (11/29/14) 87!!

[Anonymous]

My excel skills are probably at a beginner level if even that. Should I buy a course program? I see them on groupon all the time for about $30-40. Should I take a computer class at a community college? Or should I just try to learn through youtube? I don't start working until September. What other programs should I be efficient in? (Sorry to high jack the post).

[leglock]

@mamaberar:

Was there a resource you could direct me to for a comprehensive list of shortcuts? I think I may have seen something on Chandoo but there may be better resources.

Thank you mydnight and rsrasc for your recommendations. I'm in need of tutorials on pivot tables starting with the remedial and progressing from there and will definitely check out your suggestions.

[ajurew1]

Ninja excel book? I e-mailed Jeff about this today.

BEC - 84 (4/13/2013)
REG - 82 (10/17/2013)
AUD - 85 (12/5/2013)
FAR - 75 (10/11/2014)

[Anonymous]

Google my friend. Decide on a project and Google any issues to figure out how to fix them. That's how I learned Pivot Tables, Vlookup, Visual Basic, etc. Google is all you need.

[Anonymous]

https://www.gcflearnfree.org/office2013/excel2013/27

[rp 12]

@Amor D – Thanks for sharing this link!

AUD - NINJA in Training
BEC - NINJA in Training
FAR - NINJA in Training
REG - NINJA in Training

AUD - 67, 62, 77 (lost credit), TBA

FAR - 53, 48, 58, 62, XX

BEC - 53, XX

 

"Success in life comes when you simply refuse to give up, with goals so strong that obstacles, failure, and loss act only as motivation"

AUD: 68, 62, 77✔ (expires 10/31/16)
FAR: 53, 48, XX (retake 6/16)
REG:
BEC: 53

[Anonymous]

GCF is great – that's what I used for everything.

Here's a cool link with a long list of shortcuts I've kept with me:

https://exceljet.net/keyboard-shortcuts

[Author]

Replies