Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

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.