advanced excel ms training - Comparing Models

Resolved · Low Priority · Version Standard

Comparing Models

Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

by - delegate Tim [14 posts] (2007 Sep 6 Thu, 13:58) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Comparing Models

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 11:04) Reply

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