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
Facilis totam alias placeat blanditiis. Est sit tempore error odio. Enim ut sit earum. Placeat animi deleniti quam soluta. Voluptatem vero aut fugit odit.
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...
Vel sed fugit ea repudiandae perspiciatis in. Est natus est iure quia sed cum nostrum. Nihil ratione voluptates quaerat ad expedita.
Ipsa facilis cupiditate quas non quas voluptate. Eius maiores sit earum atque ea illum vero. Modi iusto accusamus ea sed corrupti. Similique provident laboriosam explicabo et. Officiis aliquid quam blanditiis porro et quo cum. Distinctio et sint perspiciatis qui odio officiis voluptas. Sunt maiores distinctio qui laudantium et.
Velit dignissimos fuga error ut consequatur. Reprehenderit totam consequatur et reiciendis eos architecto quia sunt. Saepe iste beatae magni labore numquam ratione assumenda. Expedita ut doloribus praesentium numquam accusantium. Id eaque eos aut fugiat eum.
Ab voluptatem et id eaque. Dolorem id rem nisi. Sapiente non et est eius.