Summary

The lessons in this chapter were designed to teach you how to gather data from various data sources. You should now be able to pull data from text files, CSV files, other Excel files, and web pages. Getting data in your hands is the first step in the data analysis life cycle, and you now have the skills needed for this process. In the next chapter, we will take a look at the last set of data gathering skills that all data analysts should be equipped with. Chapter 2, Connecting to Databases, will guide you through detailed step-by-step instructions on how to connect to Microsoft SQL Server databases using Excel's data connection tools.