This course focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform).
Learning Objectives:
Differentiate between improper and proper data structure
Select the best way to import data into Excel
Identify ways to use Power Query to clean your data