Excel: Integration with Other Tools
Duration15'
No. of mini-lessons8
ResourcesTranscript
Duration 15'
No. of mini-lessons 8
Resources Transcript
Course overview
Creating reports or presentations can hit a bit of a roadblock when it comes to including data. Bringing that data in can be a frustrating task. However, this doesn’t need to be the case. Excel can be integrated with other tools, to easily present the data in the way needed.
This course will show your employees how to integrate Excel with other tools. It’ll focus on how to use it with programs like Word and PowerPoint and connect it to external APIs. Each video will cover a specific tool, so they can choose exactly what they want to learn, at a pace that suits them.
What's covered
Linking and embedding Excel data to Word documents and PowerPoint presentations
Exporting to PDF and connecting Excel to Microsoft Access
Mail merges and external APIs
Using Power Query
Linking Excel to Google Sheets for cross-platform collaboration
Why your teams need this course
This course is ideal for anyone who’s familiar with Excel and wants to integrate their work with other tools. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
