Book (Practical) Computer Can be done in Excel! Introduction to the practice of automatic collection and analysis of web data Web creation

Product description ※Please note that product information is not in full comprehensive meaning because of the machine translation.

Computers
computers
This book explains techniques for collecting data from the Web using Excel and analyzing the collected data, and how to automate the process (crawling). It explains how to collect data using Excel's "Get Data" and "Web Query" functions, how to collect data using Web functions, how to import Web data using VBA, and how to manipulate IE. In the latter half, it explains how to import data using actual Web sites as examples, and explains how to aggregate and analyze the imported data.