Connecting to External Data with Microsoft Excel 2019

In this course, you will learn how to connect your workbook to external data either from another workbook, from an Access database, or from the web.

Foundation Subscription > Data Science > Connecting to External Data with Microsoft Excel 2019

Part of Foundation Subscription

Intermediate

1 Hour 4 Minutes

Start Course

Course Description

In this course, you will learn how to connect your workbook to external data either from another workbook, from an Access database, or from the web. You will link data that can potentially be updated in real-time. You will use the Get and transform function to connect to and shape your data to meet your project requirements.

Requirements

Excel 2019

Instructor:

Deborah Ashby

Deborah Ashby is a five time TAP Accredited IT Trainer, specializing in the design, delivery, and facilitation of Microsoft courses both online and in the classroom. Ms. Ashby has over 11 years of IT training experience and 24 years in the IT industry. She is also COLF Accredited and is a member of The British Learning Institute.