Exam Version of Excel

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #3305717
    thelatebloomer
    Participant

    I'm prepping for FAR and decided to change my approach slightly for these exams with Excel being implemented into them. I use Excel extensively at work, and I noticed in doing practice problems my ‘stupid mistake' rate dropped dramatically while using it. It just seems to click in my mind a lot better in spreadsheet form. In past exams I just used the calculator and it seemed to work out, but there were certainly a lot of steps I would do in my head this way. The other thing I noticed is that when I used Excel to write out some basic journal entries, conceptually I was able to work out answers a lot more consistently on the first attempt and sometimes saved time where I would otherwise get ‘stuck' for a bit. I'm thinking that it could help with sims and very likely with future professional work as well. I recognize that speed of use has to be a huge priority and accuracy is not the only factor. I will be monitoring my speed to make sure it's worth it. My strategy is to be doing all my practice problems with Excel to improve quickness of setups and calculations. I'm also taking a bit more time with this one to improve my pass rate because I'm restarting the 18-month window.

    Is there an extensive list of the formulas and functionalities for this exam version? I'm not satisfied with ‘most of the basic formulas' because there are some formulas like PV() that I would like to practice with and some would construe those as ‘basic'. I want to ensure what I practice will be available in that version before I continue.

    BEC: 88 (expired)
    REG: 77 (expired)
    FAR: October
    AUD: TBD

    Wiley CPAExcel + Ninja MCQ + Ninja Audio + Ninja Notes

    #3305720
    CPAHOPE
    Participant

    For excel, you dont need to know the formulas. You just need to know how to add and subtract in excel. Lol
    I found excel to be extremely helpful when i had to add or subtract extensively.
    To add in excel: input =3+5 , then it would give you the answer.

    AUD - 78
    BEC - 76
    FAR - 80
    REG - 77
    FAR 57,61,57,56,68, 80

    REG 53,49,69,66, 79*,77

    AUD 39,66,72,73,66,70😭, 78!!! Final

    BEC 64,60,50,70,67,71,76

    "Theres no limit unless you allow it"

    *expired

    #3305753
    thelatebloomer
    Participant

    Thanks. Upon review, I think it's clear that there's no need for PV() considering they will always give you the PV factors. I find the biggest utility is setting up quick T-accounts, journal entries, as well as quickly putting the relevant numbers in cells as you read the problem for even faster calculations. That way, you can just grab the cell references as soon as you finish the problem. I feel like that helps my brain prune the relevant data from the problem and not getting lost in blocks of text.

    BEC: 88 (expired)
    REG: 77 (expired)
    FAR: October
    AUD: TBD

    Wiley CPAExcel + Ninja MCQ + Ninja Audio + Ninja Notes

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.