In this chapter, we described different methods of inputting information into an Excel spreadsheet, going beyond what can be done by hand-typing data. A variety of file types, web data sources, and databases can be analyzed from within Excel by using Power Query and Query Editor to extract, transform, and load data. I encourage you to explore other data sources, since the loading procedure is very similar.
So far, we have seen some very simple data transformations being applied to the data before it was loaded. In the next chapter, we will discuss more advanced techniques for cleansing data.
