advanced excel ms training - comparing models

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Comparing Models

advanced excel ms training - Comparing Models

resolvedResolved · Low Priority · Version Standard

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?

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


 

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips


Server loaded in 0.09 secs.