MS Query

This lesson focuses exclusively on the Data layer of a model. How do we get large amounts of data into Excel that we can then use to build reports? We learn how to import various text files, set up connections to external databases and even how to connect to webpages to download data.

You can sign up to receive various text files and Microsoft Access databases to practice connecting Excel to other data sources and follow along with the lessons in the book.