Excel: Data Import and Export
Price:
$4.00
Description:
<p id="isPasted">Sometimes, you can start working on one piece of software, and then need to migrate the data to another. Or you might receive data from someone and need to transfer it into the format, tool, or document you’re using. In Excel, you can import and export data in different formats, making it easier to work with. </p><p><br></p><p>This course will show you how to import and export data in Excel. It’ll focus on how to import and clean data from external sources, and how to export into different formats. Each video will cover a specific action, so you can choose exactly what you want to learn, at a pace that suits you. </p><p><br></p><p><strong>This course contains useful information on: </strong></p><p><br></p><p>• Importing data from text files (CSV and TXT) </p><p>• Importing data from Excel files </p><p>• Importing data from external data sources (SQL, Access, Web) </p><p>• Cleaning imported data using the functions: Trim, Clean, Text to Columns, and Remove Duplicates </p><p>• Exporting data to text files (CSV and TXT) </p><p>• Exporting data to PDF </p><p>• Exporting data to other Excel files </p><p>• Connecting to data sources with ODBC and OLE DB </p><p><br></p><p><strong>Why take this course? </strong></p><p><br></p><p>Sometimes, it’s necessary to work with data from elsewhere, or move data somewhere else. This course is ideal for anyone who’s familiar with Excel and wants to successfully import and export data, to make it more versatile. To get the best out of this course, you’ll need access to a computer and Microsoft Excel.</p><p><br></p><p>20 mins | SCORM |<strong id="isPasted"> </strong>Transcript</p>