February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
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,
Start your free trial
Getting Data from Web Queries
You can import data into Excel through database and web queries and analyze data with formulas and formatting. You can insert columns within query tables and apply formulas and formatting. When data is refreshed, the formatting and analysis are retained. Excel helps you through the process of bringing data from a web page to your worksheet. You can create a new web query as you choose the URL and parameters for how you want to import the web data. Once you save the query, you can run it again at any time.
Get Data from a New Web Query
Click the Data tab.
Click the From Web button.
Type the address for the web ...