Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Comparing Models
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
advanced excel ms training - Comparing Models
Resolved · Low Priority · Version Standard
Reply Thu 6 Sep 2007, 13:58Delegate Tim said...
Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Comparing Models
Is there a tool that will allow you to compare 2 financial models to check what the differences are between them and what changes have been made?
For upcoming training course dates see: Pricing & availability
RE: Comparing Models
Hi Tim. There doesn't seem to be a straight worksheet comparison tool in Excel, so I'm thinking there must be a downloadable add-in out there to perform this function. Secondly, you could feasibly copy and paste the cell values into Word as a table and then use its Compare function to highlight alterations between versions. Thirdly, there's a package called Deltaview which is used by law firms to compare Word documents, which might be able to generate Excel comparisons.
Finally, you could use worksheet formulas to compare cells and then change cell formatting if a difference is found, but that would add in a whole extra laying of formulae ontop of the model, so I wouldn't advise it.
Hope this helps,
Anthony
|