[win2bet]

I am starting an accounting internship at a midsize CPA accounting firm in a few weeks and was looking for advice on what excel functions I should know. I have been using excel quite often but only really know the basics.

Any books in particular to read? (got a B&N gift card)

REG 68,87
BEC 85
FAR 75
AUD 64,64, 86!

[Anonymous]

vlookups and “if” statements based on my experience thus far

[OlintoJr]

Learn how to utilize pivot tables as well. They can save you a lot of time when needing to massage massive amounts of data into a format that meets your needs.

FAR - 11/30/14 -79
AUD - 2/19/15 -86
BEC - 4/09/15 -86
REG - 11/30/15 -87

I'M DONE! ITS OVER! WOOOOOOO!!!!!!!

[pnielsen1982]

Knowing how to embed a MATCH statement into an INDEX function can be useful and will impress all your friends. With VLOOKUPs, the column you are looking up from has to be to the left of the data you're returning. With an INDEX and MATCH, that isn't the case.

I would also suggest learning some of the everyday keyboard functions you'll use, so you don't have to your use mouse as much. Much faster.

CA licensed CPA

AUD - 08/31/13 - 84
BEC - 11/26/13 - 84
FAR - 08/10/14 - 85
REG - 11/30/14 - 72, 02/20/15 - 87

What have I gotten myself into?

[ocboa]

do you know if there's a site that lists common keyboard functions?

[thechapman]

is there an excel forumula that can place a to go order at Chili's for your team? if so, I'd strongly suggest taking a crack at memorizing it

Passed - 2014

[wr8280]

Vlookup, macros, pivot tables, conditional formatting, and… that's it.

I never had a situation where I needed hlookup or index and matching functions. That's more of a cherry on the sundae type of thing.

FAR- 82
REG- 93
AUD- 89
BEC- 88

You are smarter, more focused, and more brilliant than you give yourself credit for. Believe in yourself and truly know in your heart that you can do it.

[win2bet]

Thanks a lot for the advice everyone!

got a little bit of extra light studying & practice to do.

Happy new year =]

REG 68,87
BEC 85
FAR 75
AUD 64,64, 86!

[Mamabear]

Keynoard shortcuts definitely. There is a list in the Excel help feature. Pivot tables, filters, vlookups, if statements, and sumif.

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!!

[Kettlepot]

This book has got everything you'll need (and then some) and it's written simply with plenty of pictures:

https://www.amazon.com/Learn-Excel-2007-through-MrExcel/dp/1932802444/ref=sr_1_4?ie=UTF8&qid=1420829080&sr=8-4&keywords=Bill+Jelen

Far: 49
BEC: 79 (Expired)
AUD: 51, 67, 64
REG: 59, 64, 59, 69

[Author]

Replies