Chapter 40 Get & Transform
Questions answered in this chapter:
How can I download recent Bitcoin prices and ensure that the imported data automatically updates each day?
How can I download up-to-date populations of U.S. cities?
Often business analysts need an easy way to import into Excel data from the web, text file, database, or other source. The business analyst often needs to shape or transform this data. Finally, the analyst usually wants the imported data to update to incorporate changes in the source data. In this chapter, we introduce the reader to the amazing capabilities of Excel 2019’s Get & Transform feature, which enables analysts to efficiently import, reshape, and transform data. As shown in Figure 40-1, beginning with Excel ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
