Title:
Two Ways to Transpose Excel Data
Video:
Description:There are at least Two Ways to turn an Excel data set "on its side." Changing from a " row based" orientation to a "column based" orientation or vice-versa. In this lesson - Using Excel 2010 for the first time - I demonstrate how to use: 1) Copy - Paste Special - Transpose - great for quickly restructuring your data. 2) The TRANSPOSE Function which is an ARRAY Function I find that many of my clients and viewers are now familiar with Copy - Paste Special - Transpose. I really like the new "Live Preview" tool for paste Special in Excel 2010! The only "drawback" with this method is that it does not preserve a "link to" the original cells. Not a major drawback considering that it does preserve the Functions correctly. With the TRANSPOSE Function - which is an ARRAY Function - you are able to maintain a link to the source data - as long as you do not delete it! ARRAY Functions are powerful - and easy to use provided you understand the several "got'chas" involved. I invite you to visit my online shopping website - shop.thecompanyrocks.com - to preview all of the resources that I offer you. Danny Rocks The Company Rocks
Published:
26/May/2011
Two Ways to Transpose Excel Data
Video:
Description:There are at least Two Ways to turn an Excel data set "on its side." Changing from a " row based" orientation to a "column based" orientation or vice-versa. In this lesson - Using Excel 2010 for the first time - I demonstrate how to use: 1) Copy - Paste Special - Transpose - great for quickly restructuring your data. 2) The TRANSPOSE Function which is an ARRAY Function I find that many of my clients and viewers are now familiar with Copy - Paste Special - Transpose. I really like the new "Live Preview" tool for paste Special in Excel 2010! The only "drawback" with this method is that it does not preserve a "link to" the original cells. Not a major drawback considering that it does preserve the Functions correctly. With the TRANSPOSE Function - which is an ARRAY Function - you are able to maintain a link to the source data - as long as you do not delete it! ARRAY Functions are powerful - and easy to use provided you understand the several "got'chas" involved. I invite you to visit my online shopping website - shop.thecompanyrocks.com - to preview all of the resources that I offer you. Danny Rocks The Company Rocks
Published:
26/May/2011
No comments:
Post a Comment