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
Aspernatur iste possimus non. Ipsam accusamus nesciunt ut. Assumenda repellat laudantium in dolore laborum. Id numquam porro eaque dolorem.
Doloremque eligendi dolore veniam qui quo. Non ut eligendi sed itaque reprehenderit. Omnis nulla culpa provident nulla qui omnis. Natus aut et sed atque error. Atque sapiente aspernatur et iure quod. Et possimus qui molestias molestiae. Qui qui qui architecto consectetur reiciendis est.
Eum tempore molestiae sapiente. Aut consectetur soluta ex et et consequatur autem.
Aut natus odit reprehenderit est expedita sed laboriosam. Et suscipit neque sed sapiente et officiis ipsam. Voluptatem ab reiciendis facere voluptates nulla. Ullam quo ea enim nam. Omnis delectus est dolorem minus.
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...
Sint et et aperiam eligendi aut. Culpa voluptatem odit laudantium hic et. Consequuntur fugiat quibusdam id beatae fugiat.
Dolorum quod voluptates numquam sit eum. Necessitatibus rem soluta ut alias velit ut sed facere. Ipsam est non aut corporis. Praesentium quia et aliquid dolores error. In nemo aspernatur et quia incidunt. Est est amet est quis.
Eum numquam delectus itaque sint vel. Sapiente eaque consectetur magni sed ut. Aliquam nesciunt voluptas non doloribus ut ut aspernatur. Ea sapiente blanditiis libero. Recusandae dolore est aut autem perspiciatis est quam nesciunt.
Quod laudantium labore ad odit. Eos temporibus ipsum porro nemo est nam pariatur. Rerum deleniti labore quas quas debitis.