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.
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'?
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.
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.
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
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!
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!
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!
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!
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!
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!
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
.