Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to replace formulas, functions, and links to other workbooks with the displayed values. This is called pasting values and allows you to turn dynamic formulas into static values. This is a great feature of Excel which allows you to better analyze data since it won’t be able to change after you copy and paste the values. This is a must for anyone who analyzes data regularly.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!