[Anonymous]

Title says it all. I briefly toyed with Pivot Tables in school but never went into depth with it. I am familiar with VLOOKUPs but haven’t used them. Any websites that have detailed exercises on what I would need to know for an entry level accounting position?

[monikernc]

cpaacademy.org has free excel webinars in its archives. look there to see if any cover those.

FAR 7/25/15 76!
AUD 10/30/15 93
BEC 2/27/16 82
REG 5/23/16 88!
Ninja Book and MCQ and the forum - all the way!!!
and a little thing i like to call, time and effort!
if you want things to change, you have to do something different

[monikernc]

bump!

FAR 7/25/15 76!
AUD 10/30/15 93
BEC 2/27/16 82
REG 5/23/16 88!
Ninja Book and MCQ and the forum - all the way!!!
and a little thing i like to call, time and effort!
if you want things to change, you have to do something different

[RE2PECT]

Subscribe to Excelisfun on youtube. There's a ton of excel tutorials on there.

FAR: 75 Roger & Ninja (notes/flashcards/audio/MCQ)
AUD: 73, 81
BEC: 71, retake 8/29
REG:

[monikernc]

I also recommend learning INDEX with MATCH functions in excel. I use them a lot here lately and they are good when you have to extract a field based on matching elements in different spreadsheets. I use them with asset numbers in large files and things go very quickly. I love pivot tables!! Yes. Love. My asset listings end up in pivot tables. Very helpful, indeed.

FAR 7/25/15 76!
AUD 10/30/15 93
BEC 2/27/16 82
REG 5/23/16 88!
Ninja Book and MCQ and the forum - all the way!!!
and a little thing i like to call, time and effort!
if you want things to change, you have to do something different

[Anonymous]

Great thread. Thank you everyone.

[Anonymous]

Try this:

https://www.gcflearnfree.org/

[1koolcat]

This is an easy tutorial:

https://office.microsoft.com/en-us/excel-help/overview-RZ101862716.aspx?section=1&AxInstalled=1&c=0

AUD - 77
REG - 73, 80
FAR - 69, 73, 79 and DONE!
BEC - 82

[Author]

Replies