Importing Data with Power Query

Topics Covered

• Connecting to Excel workbooks
• Importing CSV files
• Importing text files
• Connecting to databases
• Importing web data
• SharePoint connections
• Folder imports
• Refreshable connections
• Data source settings
• Query management

Module Description

• Participants learn how to connect Excel to multiple internal and external data sources. The module focuses on creating reusable data connections that support automated reporting and eliminate manual copy-and-paste processes.

Hands-on Lab

• Connect to multiple business data sources
• Refresh imported datasets