[mikiluv]

Hello!

I do not have any audit experience but will begin my 1st year as an auditor at a Big 4.

What are the skills level needed for Excel as a 1st year? Can you share any tips so I can try to refresh or learn?

Thank you 🙂

[pikachu]

Index match is like using a ferrari in a backyard. I've used it and it's invaluable when I need it (dynamic column selection).

But for all intents and purposes, vlookup is a lot easier to audit and maintain and use and pass on. Even if you have to create helper columns to the left.

https://www.homeandlearn.co.uk/excel2007/Excel2007.html

This site was really helpful in teaching me to pivot and do basic excel things.

FAR: 2/23/14 77 (1 month studying)
AUD: 5/25/14 68
AUD: 7/13/14 72
AUD: 10/12/14 72
I GIVE UP

[RedSoxFan77]

ok so from what i learned about index and match is that you still need to point the formula to the exact column you want to pull data from – just like the vlookup, you tell it how many columns over. is there a way around having to tell excel exactly which column to pull from, i.e. can i say pull data from column with header ‘address'?

btw, I really like mbaexcel.com now.

FAR 75
AUD 74, 82
REG 58, 74, 83
BEC 68, 75
Licensed 7.1.14!!!

[Monkey Wrench]

^^I somewhat agree, at the same time, there is no reason to learn both when one of them will work in all situations. actually this is to pikachu.

to redsox, its not particularly easy for me atleast to explain, better to look up a how to video on youtube.

[mikiluv]

everyone, thank you for the responses!!! 🙂

[Anonymous]

1) Filtering & sorting

2) Functions and compound functions (using two or more functions concurrently). Also, the logical functions are real sleepers that can do a lot when compounded.

3) Pivot Tables can be pretty handy from time to time

4) Using Excel for 20 hours straight

5) Get your MS Access skills up. You can do magical things with Access that will crash your computer in Excel.

6) Learn how to extract sports data from websites so it looks like you're working when, in fact, you are picking out your Fantasy Football lineup for the week.

The most important thing to stand out as an Associate- double check your work. A lot of people don't and it will save you a lot of review comments. It could be the difference between getting out at 7PM or 9PM.

[univegabw]

Filtered.com is a cool website to purchase an excel program and learn from. Very powerful skill to have.

A- 53, 55
B- Passed!
F- Not Yet Taken
R- 1/17/2015

[RedSoxFan77]

After a bit of research, I finally figured out how to use index and match to pull in data with multiple criteria! I'm psyched that I don't have to rely on vlookups now that I have this new information. It's just too bad I didn't know about these formulas before yesterday, it would have saved me a ton of time and frustration.

FAR 75
AUD 74, 82
REG 58, 74, 83
BEC 68, 75
Licensed 7.1.14!!!

[pikachu]

If you're pro enough, look into PowerPivot. You can “join” tables like Access, but pivot like Excel 🙂 And it works great with millions of rows. Lacks some basic pivot features like calculated items though.

FAR: 2/23/14 77 (1 month studying)
AUD: 5/25/14 68
AUD: 7/13/14 72
AUD: 10/12/14 72
I GIVE UP

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[wannabeCPA123]

I recommend not using a mouse for at least 3 months. You'll be amazed at how fast you can get just using shortcuts.

Once you start memorizing even the ribbon chains (alt N,V,T for Pivot table or Alt O,h,r for naming tabe or alt o,h,i for fitting data) things go by really fast.

Especially for formatting or “making PBC's pretty”. I timed my self once, and with a mouse it took me 5 minutes to format a PBC, but with shortcuts it took me 2 minutes!. Think of the time savings in the long term.

FAR 78
REG 87
BEC 78
AUD 78
Passed all exams on first try! Good luck to everyone!

[teeteenounouche]

Anyone have some good tips or links for creating flowcharts in Visio?

Florida:
AUD: 73, 81! Thank you Lord!
BEC: 73, 77! Thank you Lord! and WTB
REG: 71, 82! Thank you Lord! and A71
FAR: 72, 78! Thank you God and my Mommy in Heaven!

CPA Excel, Ninja Notes & Audio, Wiley Test Bank, CPAreviewforfree

[Author]

Replies