Focuses on getting data from different sources into Excel.
Learning Objectives
Differentiate between proper and improper data structure.;Select the best way to import data into Excel.;Identify ways to use Get & Transform/Power Query to clean your data.
Major Topics
Various forms of data sources;Accessing data sources;Working with multiple tables/sources;Importing data for analysis;Introduction to Get & Transform (formerly Power Query)
