Excel: Data Import and Export
Train your employees on importing, exporting, and cleaning data in Excel, and connecting to data sources using ODBC and OLE DB.
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.
Accredited by CPD
TalentLibrary is recognized as reaching the standards and benchmarks required by the Continuing Professional Development (CPD) Certification Service.
The CPD Certification Service is the world’s leading and largest independent accreditation organization for professional development courses across all industry sectors.
Other courses in this collection
Excel: Custom Templates and Add-Ins
Train your employees on creating, saving, and managing Excel custom templates, and using Power Query, Power Pivot, and VBA add-ins effectively.
Excel: Scenario Analysis and What-If Analysis
Train your employees on Excel’s Scenario Manager, Goal Seek, Data Tables, Solver Add-In, Forecast Sheets, and Monte Carlo simulations.
Excel: Integration with Other Tools
Train your employees on linking Excel data to Word, PowerPoint, and Google Sheets, exporting to PDF, and using Power Query and APIs.
