Skip to Main Content
Excel Dashboards & Reports For Dummies, 4th Edition
book

Excel Dashboards & Reports For Dummies, 4th Edition

by Michael Alexander
April 2022
Beginner to intermediate content levelBeginner to intermediate
384 pages
9h 47m
English
For Dummies
Content preview from Excel Dashboards & Reports For Dummies, 4th Edition

Chapter 4

Using External Data for Your Dashboards and Reports

IN THIS CHAPTER

Bullet Leveraging Power Query to get external data

Bullet Extracting data from files

Bullet Getting data from external databases

Wouldn’t it be wonderful if all the data you come across could be neatly packed into one easy-to-use Excel table? The reality is that sometimes the data you need comes from external data sources. External data is exactly what it sounds like: data that isn’t located in the Excel workbook in which you’re operating. Some examples of external data sources are text files, Access tables, SQL Server tables, and even other Excel workbooks.

This chapter explores some efficient ways to get external data into your Excel data models. Before jumping in, however, this humble author wants to throw out one disclaimer: There are numerous ways to get data into Excel. In fact, between the functionality found in the user interface and the VBA/code techniques, Excel has too many techniques to focus on in one chapter. Instead, then, in this chapter I focus on a handful of techniques that can be implemented in most situations and don’t come with a lot of pitfalls and gotchas.

Leveraging Power Query to Extract and Transform ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Dashboards and Reports for Dummies, 3rd Edition

Excel Dashboards and Reports for Dummies, 3rd Edition

Michael Alexander

Publisher Resources

ISBN: 9781119844396Purchase Link