Excel: Data Import and Export
Duration20'
No. of mini-lessons8
ResourcesTranscript
Duration 20'
No. of mini-lessons 8
Resources Transcript
Course overview
Sometimes, your employees can start working on one piece of software and then need to migrate the data to another. Or they might receive data from someone and need to transfer it into the format, tool, or document you’re using. In Excel, they can import and export data in different formats, making it easier to work with.
This course will show them 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 they can choose exactly what they want to learn, at a pace that suits them.
What's covered
Importing data from text files, excel files, and from external data sources
Cleaning imported data using specific Excel functions
Exporting data to text files, PDFs, and other Excel files
Connecting to data sources with ODBC and OLE DB
Why your teams need this course
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, they’ll need access to a computer and Microsoft Excel.
