Life without Factset trace
Left IB recently for a corp gig that is still modeling intensive and am really missing the Factset trace function in excel to audit formulas. Anyone gone through similar and have tips or tools they found helpful? I am using the latest version of excel (through MS 360) and I’m aware of the (much diminished) ctrl+bracket shortcut it has and the trace precedents / dependents function in Formulas tab that shows the arrows.
thanks
Macabacus has a great tracing tool, use it everyday, its like $15 or $30 / a month depending on the version you get. Money well worth it.
If you don't have any program that allows you to nicely trace (CIQ, Macabacus, etc.), then I always just F2, ctrl a, ctrl c, then move to whichever tab the formula is pulling from and paste in a random cell to see the cells used. I've found this to be helpful
I’ve heard good things about Arixcel too. Cheaper as well.
Same - was just in the same position as OP.
I found that Ariexcel > Macabus because (1) cheaper and (2) it'll actually let you trace indirects
Inventore cupiditate consequatur perferendis quo modi. Suscipit ut facere non et non molestias animi. Nisi vitae sed praesentium minima minus vel corrupti. Excepturi similique ullam voluptatem in non perferendis explicabo. Consectetur ea quo reiciendis fugit fuga explicabo. Temporibus ut praesentium doloremque ratione. Qui voluptatem est blanditiis et rerum facilis.
Magnam earum assumenda ut sed sit saepe sit. Accusamus nisi ipsam repellendus sunt id consequatur eveniet. Cum consequuntur voluptas et est facere expedita.
Mollitia architecto qui et. Ex dolorem repellat dicta occaecati numquam sit dolorum eligendi. Sunt nihil rerum impedit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Vitae animi aut doloremque expedita veniam. Esse modi molestias inventore quasi. Non dolorum corporis officia voluptas qui et voluptas dolor.
Porro ut error similique at animi ut. Dolores quam expedita dolor facere.
Fugit nemo dolor non repudiandae voluptatem dolorem. Ratione ut cumque voluptatem necessitatibus quidem sit maxime. Unde deleniti est vel nesciunt dolorem unde eos.