My Best Practices for Importing Data Into Excel
Pay attention to the "format" of the data that you import into each field in an Excel Workbook. I created this video lesson after helping a viewer find out why his Pivot Table results were not producing the expected results.
The problem turned out to be that the field containing his Invoice Numbers was improperly formatted. This field should have been imported as a "Text" values field. The records contained a mixture of numeric and text value entries. Yet another example of GIG (Garbage In delivers Garbage Out!)
Watch as I demonstrate the proper way to import External Data in Excel.
Watch video My Best Practices for Importing Data Into Excel online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 09 March 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,560 once and liked it 25 people.