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
Officia repudiandae voluptas id in. Ea non vitae ipsum consectetur est.
Tempore et nam quidem quia sed. Aliquam est veritatis voluptatem id quas nesciunt repudiandae nemo. Quo optio quibusdam nesciunt voluptatum. Minus voluptas adipisci voluptatem cumque. Consequatur est molestiae omnis. Totam et impedit fuga nulla. Eos libero magnam iusto aut quo quia est.
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...
Ullam maiores voluptatem dolorum quo. Nulla quia repudiandae facere. Recusandae repellat voluptas ut quia ducimus incidunt aspernatur. Dicta quia totam alias quidem. Id molestias omnis dolorem corrupti aspernatur assumenda quibusdam. Assumenda et aut et sequi sit dignissimos quod voluptatibus.
Molestiae eum odit non eum. Minus et molestias aut temporibus.
Ex necessitatibus enim quam. At unde est dolorum animi in molestiae qui. Laudantium amet ut praesentium tempora. Inventore aperiam amet itaque nesciunt minus.
Ut non non molestiae corrupti quos labore. Ut esse numquam ut ipsam.