[mightymike23]

I start working in a public accounting firm next month and I wanted to master excel before going in as an audit associate. Does anyone know any good online excel courses/tutorials that can possibly prepare me in excel before I start working next month? Thanks.

[leglock]

someone on here directed me to lynda.com

i was seeking info on quickbooks, but it appears they have info on excel as well. i think it's 25 per month, cancel any time.

I'm curious too if there are other excel resources.

[stoleway]

There are lots of them on youtube that are free, I prefer to pay to get a deeper understanding of the courses. Currently I'm using the following websites for excel training.

https://excelandaccesstraining.net/access-tutorials-training-2013.html

https://www.elearnexcel.com

REG -63│ 84!!
BEC- 59│70│ 71 │78!
AUD- 75!
FAR- 87!

Mass-CPA

[Myredstapler]

Pivot tables and V-Lookup will be your best friend

[Smashbox20]

Myredstapler is right, pivots and lookups are great skills to have. My advise to you is this: If you feel like something is taking too long, there is definetly a faster way. Do a quick google search and you will find something golden. Good luck!

FAR: Passed
REG: Passed
BEC: Passed
AUD: Passed

[Lindrobe]

I am an aspiring excel nerd also and found a cool feature called “index+match” that I didn't know about on this website:

https://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/

FAR 12/3/14, 87
AUD 2/3/14, 90
BEC 4/1/14, 88
REG 5/27/14, 94

Licensed CPA, Indiana

"Successful people do things that unsuccessful people don't want to do"

[MUCPA]

Chandoo is a fantastic resource. Myredstapler is correct – Vlookup and pivots are pretty huge.

Honestly, when I was in public, the average excel skill level l was significantly lower than it was in the industry jobs I've had since then. Master the basics – learn what you need to as you go. You'll be fine.

- 2.5 years experience in Public Accounting (Audit)
- 2.0 years experience in corporate accounting
- All 4 CPA Exam sections passed first time
- Currently CPA & Controller at a small manufacturing company

[stoleway]

Index and match are really interesting and good to know, it alternates VLOOKUP to a greater degree, I just don't like it when both index and match are put together. Thats too much formulas and processes to memorize:( I'm still working on it.

Macros is gradually becoming interesting for me.

REG -63│ 84!!
BEC- 59│70│ 71 │78!
AUD- 75!
FAR- 87!

Mass-CPA

[Smashbox20]

@stoleway – index match is my favorite formula ever. You don't run accross many people who know about it so it's cool to hear you bring it up!

FAR: Passed
REG: Passed
BEC: Passed
AUD: Passed

[NYCaccountant]

A good one to use is combining multiple sumproduct formulas so you can sum by multiple criteria. Has made my life so much easier.

FAR - 93
REG - 87
BEC - 84!!!!
AUD - 99!!!!!! CPA exam complete.

[CPA soon]

Check this link for affordable seminars https://www.pryor.com

Personally I suggest you search youtube tutorials, watch a basic one, watch a vlookup one and watch a pivot table one and you'll be good to go, that's all you'll need.

FAR - 71, 68, 74, (8/31/14) 78 ✔
REG - 67, 71, 71, (10/18/14) 78 ✔
BEC - (11/29/14) 86 ✔
AUD - 73, (4/4/15) 86 ✔

I can't believe this is over! 2 years and 3 months..

[Author]

Replies