Crucial Excel Skills for 1st Year Auditor at Big 4? - Page 2

  • Creator
    Topic
  • #186968
    mikiluv
    Member

    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 🙂

Viewing 15 replies - 16 through 30 (of 31 total)
  • Author
    Replies
  • #618436
    pikachu
    Member

    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

    #618438
    RedSoxFan77
    Member

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

    #618439

    ^^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.

    #618440
    mikiluv
    Member

    everyone, thank you for the responses!!! 🙂

    #618442
    Anonymous
    Inactive

    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.

    #618444
    univegabw
    Member

    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

    #618445
    RedSoxFan77
    Member

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

    #618446
    pikachu
    Member

    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

    #618447

    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!

    #618448

    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!

    #618449

    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!

    #618450

    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!

    #618451

    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!

    #618452

    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!

    #618453

    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

Viewing 15 replies - 16 through 30 (of 31 total)
  • The topic ‘Crucial Excel Skills for 1st Year Auditor at Big 4? - Page 2’ is closed to new replies.